Add example for MySQL

diff --git a/examples/pdb/mysql/mysql.dump b/examples/pdb/mysql/mysql.dump
new file mode 100644 (file)
index 0000000..12eac6c
--- /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 (file)
index 0000000..61a3f19
--- /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