summaryrefslogtreecommitdiff
path: root/examples/pdb/mysql
diff options
context:
space:
mode:
authorJelmer Vernooij <jelmer@samba.org>2002-11-10 12:07:54 +0000
committerJelmer Vernooij <jelmer@samba.org>2002-11-10 12:07:54 +0000
commitc9bd108a81c2419ae5a5750d3eb1c253a7294fd9 (patch)
treecef5f693d5029e29a1d39ca5c6626b34ce0ba311 /examples/pdb/mysql
parent10968f47cf413d5471c7ca63394b376eac9eef40 (diff)
downloadsamba-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.dump35
-rw-r--r--examples/pdb/mysql/smb.conf11
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