The Samba-Bugzilla – Attachment 222 Details for
Bug 622
problems adding users to a mysql pdb
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
some relevant mysql queries
report.bug622 (text/plain), 7.60 KB, created by
Francesco Mosca
on 2003-10-24 02:18:50 UTC
(
hide
)
Description:
some relevant mysql queries
Filename:
MIME Type:
Creator:
Francesco Mosca
Created:
2003-10-24 02:18:50 UTC
Size:
7.60 KB
patch
obsolete
>mysql> insert into user (username,password,uid,gid,posix_homedir) values ("foo","$1$hNsL70rh$ypiLapNqQwgd9lejS.plV/",8000,100,"/tmp"); >Query OK, 1 row affected (0.03 sec) > >users: >+-----------------------+--------------+------+-----+---------+----------------+ >| user_id | int(9) | | PRI | NULL | auto_increment | >| logon_time | int(9) | YES | | NULL | | >| logoff_time | int(9) | YES | | NULL | | >| kickoff_time | int(9) | YES | | NULL | | >| pass_last_set_time | int(9) | YES | | NULL | | >| pass_can_change_time | int(9) | YES | | NULL | | >| pass_must_change_time | int(9) | YES | | NULL | | >| username | varchar(255) | YES | MUL | NULL | | >| domain | varchar(255) | YES | | NULL | | >| nt_username | varchar(255) | YES | | NULL | | >| nt_fullname | varchar(255) | YES | | NULL | | >| home_dir | varchar(255) | YES | | NULL | | >| dir_drive | varchar(4) | YES | | NULL | | >| logon_script | varchar(255) | YES | | NULL | | >| profile_path | varchar(255) | YES | | NULL | | >| acct_desc | varchar(255) | YES | | NULL | | >| workstations | varchar(255) | YES | | NULL | | >| unknown_str | varchar(255) | YES | | NULL | | >| munged_dial | varchar(255) | YES | | NULL | | >| uid | int(9) | | MUL | 0 | | >| gid | int(9) | YES | MUL | NULL | | >| user_sid | varchar(255) | YES | | NULL | | >| group_sid | varchar(255) | YES | | NULL | | >| lm_pw | varchar(255) | YES | | NULL | | >| nt_pw | varchar(255) | YES | | NULL | | >| acct_ctrl | int(9) | YES | | NULL | | >| unknown_3 | int(9) | YES | | NULL | | >| logon_divs | int(9) | YES | | NULL | | >| hours_len | int(9) | YES | | NULL | | >| unknown_5 | int(9) | YES | | NULL | | >| unknown_6 | int(9) | YES | | NULL | | >| realname | varchar(32) | | | | | >| shell | varchar(20) | | | /bin/sh | | >| password | varchar(40) | | | | | >| lastchange | varchar(50) | | | | | >| min | int(11) | | | 0 | | >| max | int(11) | | | 0 | | >| warn | int(11) | | | 7 | | >| inact | int(11) | | | -1 | | >| expire | int(11) | | | -1 | | >| origpw | varchar(50) | YES | | NULL | | >| posix_homedir | varchar(32) | | | /pub | | >+-----------------------+--------------+------+-----+---------+----------------+ > >### after smbpasswd -a: > >mysql> select * from user where username = "foo"; >+---------+------------+-------------+--------------+--------------------+----------------------+-----------------------+----------+--------+-------------+-------------+--------------+-----------+--------------+-----------------------+-----------+--------------+-------------+-------------+------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+----------+---------+------------------------------------+------------+-----+-----+------+-------+--------+--------+---------------+ >| user_id | logon_time | logoff_time | kickoff_time | pass_last_set_time | pass_can_change_time | pass_must_change_time | username | domain | nt_username | nt_fullname | home_dir | dir_drive | logon_script | profile_path | acct_desc | workstations | unknown_str | munged_dial | uid | gid | user_sid | group_sid | lm_pw | nt_pw | acct_ctrl | unknown_3 | logon_divs | hours_len | unknown_5 | unknown_6 | realname | shell | password | lastchange | min | max | warn | inact | expire | origpw | posix_homedir | >+---------+------------+-------------+--------------+--------------------+----------------------+-----------------------+----------+--------+-------------+-------------+--------------+-----------+--------------+-----------------------+-----------+--------------+-------------+-------------+------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+----------+---------+------------------------------------+------------+-----+-----+------+-------+--------+--------+---------------+ >| 51040 | 0 | 0 | 0 | 1066985902 | 1066985902 | 2147483647 | foo | FCESI | NULL | NULL | \\server\foo | NULL | logon.bat | \\server\profiles\foo | NULL | NULL | NULL | NULL | 7002 | 100 | S-1-5-21-2011390343-3838542023-4164093905-15004 | S-1-5-21-2011390343-3838542023-4164093905-1201 | A6428F2551EDEE1BAAD3B435B51404EE | 86C156FC198B358CCCF6278D8BD49B6A | 16 | NULL | 168 | 21 | NULL | NULL | | /bin/sh | $1$aH/xIuYN$H8ffY2mPSyUGLFQ3yFrFb/ | | 0 | 0 | 7 | -1 | -1 | 699083 | /home/foo | >| 51546 | NULL | NULL | NULL | NULL | NULL | NULL | foo | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8000 | 100 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | /bin/sh | $1$hNsL70rh$ypiLapNqQwgd9lejS.plV/ | | 0 | 0 | 7 | -1 | -1 | NULL | /tmp | >+---------+------------+-------------+--------------+--------------------+----------------------+-----------------------+----------+--------+-------------+-------------+--------------+-----------+--------------+-----------------------+-----------+--------------+-------------+-------------+------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+----------+---------+------------------------------------+------------+-----+-----+------+-------+--------+--------+---------------+ >2 rows in set (0.00 sec) >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=222">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 622
:
221
| 222