diff options
author | Jelmer Vernooij <jelmer@samba.org> | 2002-11-10 12:07:54 +0000 |
---|---|---|
committer | Jelmer Vernooij <jelmer@samba.org> | 2002-11-10 12:07:54 +0000 |
commit | c9bd108a81c2419ae5a5750d3eb1c253a7294fd9 (patch) | |
tree | cef5f693d5029e29a1d39ca5c6626b34ce0ba311 /examples/pdb/mysql | |
parent | 10968f47cf413d5471c7ca63394b376eac9eef40 (diff) | |
download | samba-c9bd108a81c2419ae5a5750d3eb1c253a7294fd9.tar.gz samba-c9bd108a81c2419ae5a5750d3eb1c253a7294fd9.tar.bz2 samba-c9bd108a81c2419ae5a5750d3eb1c253a7294fd9.zip |
Add example for MySQL
(This used to be commit de136d294fce59bdc4d0a65d35071c2837ef92a5)
Diffstat (limited to 'examples/pdb/mysql')
-rw-r--r-- | examples/pdb/mysql/mysql.dump | 35 | ||||
-rw-r--r-- | examples/pdb/mysql/smb.conf | 11 |
2 files changed, 46 insertions, 0 deletions
diff --git a/examples/pdb/mysql/mysql.dump b/examples/pdb/mysql/mysql.dump new file mode 100644 index 0000000000..12eac6cdc7 --- /dev/null +++ b/examples/pdb/mysql/mysql.dump @@ -0,0 +1,35 @@ +# Put this in your MySQL database by running +# mysql -u<user> -p<password> -h<host> <database> < mysql.dump + +CREATE TABEL user ( + logon_time int(9), + logoff_time int(9), + kickoff_time int(9), + pass_last_set_time int(9), + pass_can_change_time int(9), + pass_must_change_time int(9), + username varchar(255), + domain varchar(255), + nt_username varchar(255), + nt_fullname varchar(255), + home_dir varchar(255), + dir_drive varchar(4), + logon_script varchar(255), + profile_path varchar(255), + acct_desc varchar(255), + workstations varchar(255), + unknown_str varchar(255), + munged_dial varchar(255), + uid int(9) NOT NULL DEFAULT "0" PRIMARY KEY auto_increment, + gid int(9), + user_sid varchar(255), + group_sid varchar(255), + lm_pw varchar(255), + nt_pw varchar(255), + acct_ctrl int(9), + unknown_3 int(9), + logon_divs int(9), + hours_len int(9), + unknown_5 int(9), + unknown_6 int(9) +); diff --git a/examples/pdb/mysql/smb.conf b/examples/pdb/mysql/smb.conf new file mode 100644 index 0000000000..61a3f19816 --- /dev/null +++ b/examples/pdb/mysql/smb.conf @@ -0,0 +1,11 @@ +[global] +netbios name = FOOBAR +workgroup = TESTGROUP +security = domain +domain logons = yes +domain master = yes +passdb backend = plugin:/usr/local/samba/lib/pdb_mysql.so:mysql +mysql:mysql host = rhonwyn +mysql:mysql user = samba +mysql:mysql password = ambas +mysql:mysql database = samba |