search for: logon_time

...** this's registering of Windows Workstation (NUA) at domain: everything's OK! (for debugging purpose samba user is mysql root) 040413 12:29:53 59 Connect root@localhost on samba 60 Connect root@localhost on samba 60 Query SELECT 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_d rive,logon_script,profile_path,acct_desc,workstations,unknown_str,munged_dia l,user_sid,group_sid,lm_pw,nt_pw,NULL,acct_ctrl,unknown_3,logon_divs,hours_l en...

...1 (include bad password count et logon time) + }; + +// Index of the most recent version +#define TDB_FORMAT_NEWEST_VERSION 1 + /********************************************************************** Intialize a SAM_ACCOUNT struct from a BYTE buffer of size len @@ -1284,6 +1300,7 @@ uint32 logon_time, logoff_time, kickoff_time, + lockout_time, pass_last_set_time, pass_can_change_time, pass_must_change_time; @@ -1304,12 +1321,13 @@ fullname_len, homedir_len, logon_script_len, profile_path_len, acct_desc_len, workstations_len; - uint32 user_rid, group_rid, unknown_3, hou...

...-----------+-------------+-------------+-------+------+-------------------------------------------------+------------------------------------------------+----------------------------------+----------------------------------+-----------+-----------+------------+-----------+-----------+-----------+ | 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_si...

...ff -u -r1.85.2.11 parse_net.c --- rpc_parse/parse_net.c 26 May 2003 06:59:38 -0000 1.85.2.11 +++ rpc_parse/parse_net.c 3 Jul 2003 03:49:09 -0000 @@ -1283,6 +1283,7 @@ /* need to count the number of space-delimited sids */ unsigned int i; int num_other_sids = 0; + char *username; NTTIME logon_time, logoff_time, kickoff_time, pass_last_set_time, pass_can_change_time, @@ -1294,7 +1295,21 @@ int len_logon_srv = strlen(logon_srv); int len_logon_dom = strlen(logon_dom); - len_user_name = strlen(user_name ); + + /* do some cleanup on the user name here to deal with users from...

...-g "%g" "%u" add machine script = /usr/sbin/adduser -d /dev/null -s /bin/false "%u" # grep rodrigo /etc/passwd rodrigo:x:7821:100::/home/rodrigo:/bin/bash # grep rodrigo /etc/shadow rodrigo:$1$iv7a45PI$3HkB6lqM0kF7I2K/u/bki.:14488:0:99999:7::: CREATE TABLE user ( logon_time int(9) default NULL, logoff_time int(9) default NULL, kickoff_time int(9) default NULL, pass_last_set_time int(9) default NULL, pass_can_change_time int(9) default '0', pass_must_change_time int(9) default '2147483647', username varchar(255) default NULL, domain varchar(255)...

...09 at 04:00 PM -- Server version: 5.0.51 -- PHP Version: 5.2.4-2ubuntu5.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `samba_auth` -- -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `logon_time` int(9) default NULL, `logoff_time` int(9) default NULL, `kickoff_time` int(9) default NULL, `pass_last_set_time` int(9) default NULL, `pass_can_change_time` int(9) default '0', `pass_must_change_time` int(9) default '2147483647', `username` varchar(255) default NULL,...

...smb.conf ok, or do i need to mention each database column separately ? i have seen examples without separate mentioning... i appended a dump of my mysql-table and my smb.conf file thanks in advance Florian Stichlberger Hall in Tirol, Austria ##### MySQL-Dump of Database CREATE TABLE `user` ( `logon_time` int(9) default NULL, `logoff_time` int(9) default NULL, `kickoff_time` int(9) default NULL, `pass_last_set_time` int(9) default NULL, `pass_can_change_time` int(9) default NULL, `pass_must_change_time` int(9) default NULL, `username` varchar(255) default NULL, `domain` varchar(255) d...

...I get the following error: "Username not found!" My command looks like this: pdbedit -d 20 -a -u <username> -f "<Users name>" -c U Doing a little debugging I can tell that pdbedit tries to do a select statement after adding the user: Executing query SELECT 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_d rive,logon_script,profile_path,acct_desc,workstations,unknown_str,munged_dia l,user_sid,group_sid,lm_pw,nt_pw,NULL,acct_ctrl,logon_divs,hours_len,bad_pas...

...---+------+------------------------------------------ +---------------------------------------------- +----------------------------------+---------------------------------- +-----------+-----------+------------+-----------+----------- +-----------+--------------------+-------------+-------------+ | 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...

...1 [2007/02/27 12:09:16, 3] smbd/uid.c:push_conn_ctx(345) push_conn_ctx(0) : conn_ctx_stack_ndx = 0 [2007/02/27 12:09:16, 3] smbd/sec_ctx.c:set_sec_ctx(241) setting sec ctx (0, 0) - sec_ctx_stack_ndx = 1 [2007/02/27 12:09:16, 2] pdb_mysql.c:mysqlsam_select_by_field(292) Executing query SELECT 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,user_sid,group_sid,lm_pw,nt_pw,NULL,acct_ctrl,logon_divs,hours_len,bad_password_...

...er token: (NULL) >[2006/08/27 20:03:03, 5, pid=18112] auth/auth_util.c:debug_unix_user_token(474) > UNIX token of user 0 > Primary group is 0 and contains 0 supplementary groups >[2006/08/27 20:03:03, 5, pid=18112] pdb_mysql.c:mysqlsam_select_by_field(292) > Executing query SELECT logon_time,logoff_time,0,pass_last_set_time,pass_can_change_time,pass_must_change_time,username,'GSB',username,gecos,home_smb,NULL,logon_script,profile_path,NULL,NULL,NULL,NULL,user_sid,group_sid,pass_lm,pass_nt,NULL,acct_ctrl,logon_divs,NULL,NULL,NULL,NULL,'?????????????????????',NULL FROM us...

...r_token(448) NT user token: (NULL) [2006/08/27 20:03:03, 5, pid=18112] auth/auth_util.c:debug_unix_user_token(474) UNIX token of user 0 Primary group is 0 and contains 0 supplementary groups [2006/08/27 20:03:03, 5, pid=18112] pdb_mysql.c:mysqlsam_select_by_field(292) Executing query SELECT logon_time,logoff_time,0,pass_last_set_time,pass_can_change_time,pass_must_change_time,username,'GSB',username,gecos,home_smb,NULL,logon_script,profile_path,NULL,NULL,NULL,NULL,user_sid,group_sid,pass_lm,pass_nt,NULL,acct_ctrl,logon_divs,NULL,NULL,NULL,NULL,'?????????????????????',NULL FROM us...

...8 [2007/02/17 16:28:04, 5] rpc_parse/parse_prs.c:prs_uint32(642) 0054 bufferlenhi: 00000000 [2007/02/17 16:28:04, 5] rpc_parse/parse_prs.c:prs_uint32(642) 0058 pointer: 00020000 [2007/02/17 16:28:04, 8] rpc_parse/parse_prs.c:prs_debug(82) 00005c smb_io_time logon_time [2007/02/17 16:28:04, 5] rpc_parse/parse_prs.c:prs_uint32(642) 005c low : e1f4ca1a [2007/02/17 16:28:04, 5] rpc_parse/parse_prs.c:prs_uint32(642) 0060 high: 01c752a7 [2007/02/17 16:28:04, 8] rpc_parse/parse_prs.c:prs_debug(82) 000064 smb_io_time log...