有做过smba+mysql的

flyfreebsd

我是想通过mysql 管理用户，


这个是我在网上查到的方法
Configure Samba to use a MySQL database for the password backend.
cd /tmp
wget http://us3.samba.org/samba/ftp/samba-latest.tar.gz
cd /usr/local/src
tar zxvf /tmp/samba-latest.tar.gz
cd samba-X.YZ
./configure --with-expsam=mysql
make
sudo make install

Create a database for Samba, and assign permissions for it.

mysql -uroot -p
> create database samba;
> grant all privileges on samba.* to samba@localhost identified by 'samba';
> quit;

Load the SQL schema.

mysql -uroot -p samba < /usr/local/src/samba-X.YZ/examples/pdb/mysql/mysql.dump

Edit /usr/local/samba/lib/smb.conf to taste.
NOTE: the full SQL schema must be loaded or Samba will throw an error. Even if you declare a column NULL in smb.conf, the column must actually exist in the database.

[global]
security = domain
domain logons = yes
domain master = yes
passdb backend = mysql:mysql
mysql:mysql host = localhost
mysql:mysql user = samba
mysql:mysql password = samba
mysql:mysql database = samba

# rows we don't use
mysql:unknown string column = NULL
mysql:munged dial column = NULL
mysql:plain pass column = NULL
mysql:unknown 3 column = NULL
mysql:logon divs column = NULL
mysql:hours len column = NULL
mysql:bad password count column = NULL
mysql:unknown 6 column = NULL
# do we need this one?  I don't know, so play it safe
;mysql:acct ctrl column = ???

Add a user.

cd /usr/local/samba/bin
./smbpasswd -a skippy

Test.

mkntpwd
Compile mkntpwd

cd /usr/local/src/samba-X.YZ/examples/LDAP/smbldap-tools/mkntpwd
make
sudo cp mkntpwd /usr/local/bin

Usage:

$ echo password | mkntpwd -f -
E52CAC67419A9A224A3B108F3FA6CB6D:8846F7EAEE8FB117AD06BDD830B7586C

PHP admin script to come.


我现在遇到的问题是 samba 无法建立用户 “./smbpasswd -a skippy”
测试访问调用的是samba 本身的数据库。 而不是mysql

flyfreebsd

请求 支援

flyfreebsd

需要在user表 增加logon_hours 键值  
通过 ./smbpasswd -a skippy  建立用户