Okay, this gets even more strange. I reverted back dbmysql.c to the one given in distribution (removed my debugging code). Compiled and installed it.
Updated dbmail.conf with TRACE_SYSLOG = 5 ran: dbmail-users -l get output: May 24 12:05:07 Error:[sql] dbmysql.c,db_query(+296): [No database selected] [SELECT userid FROM dbmail_users ORDER BY userid] May 24 12:05:07 Error:[auth] authsql.c,__auth_query(+273): error executing query May 24 12:05:07 Error:[auth] authsql.c,auth_get_known_users(+80): could not retrieve user list Now: aciditys-computer:/ acidity$ cd /var/log/ aciditys-computer:/var/log acidity$ ls dbm*.* ls: dbm*.*: No such file or directory There are no log files :( I have no idea why the log files are not generated. Doing sudo dbmail-users -l dosnt help too....!!!!! On 5/24/07, Paul J Stevens <[EMAIL PROTECTED]> wrote:
Ritesh, Please set TRACE_SYSLOG=5 Do 'dbmail-users -l' And sent us the *complete* log generated by this. Ritesh Nadhani wrote: > Hello > > On 5/24/07, Aaron Stone <[EMAIL PROTECTED]> wrote: >> All of the steps to installation are described in the INSTALL file... >> Did you create the tables in MySQL? >> > > Yes. And I think I found the bug. > > I followed all the steps as mentioned in INSTALL file. My dbmail.conf > can be found at: > > http://cs.uiowa.edu/~rnadhani/dbmail.conf > > I created the MySQL tables too. > > aciditys-computer:/ acidity$ mysql -u dbmail -p dbmail > Enter password: dbmail > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 18 to server version: 5.0.24a-max > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show tables; > +---------------------------+ > | Tables_in_dbmail | > +---------------------------+ > | dbmail_acl | > | dbmail_aliases | > | dbmail_auto_notifications | > | dbmail_auto_replies | > | dbmail_ccfield | > | dbmail_datefield | > | dbmail_envelope | > | dbmail_fromfield | > | dbmail_headername | > | dbmail_headervalue | > | dbmail_mailboxes | > | dbmail_messageblks | > | dbmail_messages | > | dbmail_pbsp | > | dbmail_physmessage | > | dbmail_referencesfield | > | dbmail_replycache | > | dbmail_replytofield | > | dbmail_sievescripts | > | dbmail_subjectfield | > | dbmail_subscription | > | dbmail_tofield | > | dbmail_usermap | > | dbmail_users | > +---------------------------+ > 24 rows in set (0.00 sec) > > So its there......... > > Now if do: dbmail-users -a ritesh -w ritesh, I get: > > May 24 10:45:08 Error:[sql] dbmysql.c,db_query(+296): [No database > selected] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = > lower('ritesh')] > May 24 10:45:08 Error:[db] db.c,db_user_exists(+4649): could not > select user information > > So it looks like that the connector code is not taking dbmail db as > default. So I edited dbmysql.c with the following addition of code > before mysql_real_connect..... > > printf( "[host = %s]\n", _db_params.host); > printf( "[user = %s]\n", _db_params.user); > printf( "[pass = %s]\n", _db_params.pass); > printf( "[db = %s]\n", _db_params.db); > printf( "[port = %d]\n", _db_params.port); > > Compiled, installed and ran the command again. > > This is what I get now: > > [host = ] > [user = ] > [pass = ] > [db = ] > [port = 3306] > May 24 10:49:33 Error:[sql] dbmysql.c,db_query(+296): [No database > selected] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = > lower('ritesh')] > May 24 10:49:33 Error:[db] db.c,db_user_exists(+4649): could not > select user information > Failed: check logs for details > Command failed. > > So evidently none of the values from the conf file is loaded up. Thus > I hardcode the value in dbmysql.c. Compile, install it again. > > aciditys-computer:~/Documents/Downloads/dbmail-2.2.5rc3 acidity$ > dbmail-users -a ritesh -w ritesh > [host = ] > [user = ] > [pass = ] > [db = ] > [port = 3306] > Adding INBOX for new user... ok. > Done > ritesh:x:4:0:0.00:0.00: > > I think its a bug. > > Ritesh > >> Aaron >> >> On Wed, 2007-05-23 at 22:49 -0500, Ritesh Nadhani wrote: >> > Hi >> > >> > I am running Mac OS Tiger with the built in postfix. >> > >> > This is my first time with dbmail. Downloaded the source and compiled >> > it accordingly. >> > >> > ./configure --with-mysql >> > make all >> > sudo make install >> > >> > All the binaries got installed /usr/local/dbmail and libraries got >> > installed in /usr/local/lib/dbmail >> > >> > Now I changed the master.cf as described at: >> > http://www.dbmail.org/dokuwiki/doku.php?id=setup_postfix with LMTP >> > support. >> > >> > Restarted postfix: >> > >> > # postmap /etc/postfix/transport >> > # postfix reload >> > >> > Went of well. >> > >> > Now I went to creating user stage. According to >> > http://www.dbmail.org/dokuwiki/doku.php?id=manage_users, I did: >> > >> > dbmail-users -a ritesh -w ritesh >> > >> > gave an error that dbmail.conf was not found in /etc. I dont know why >> > it was not created nor anything was written in the docs. So I created >> > it by hand with details similar to: >> > >> > http://www.mail-archive.com/dbmail%40dbmail.org/msg12080.html >> > >> > Executing the command again gave me: >> > >> > May 23 22:47:42 Debug:[db] dbmodule.c,db_load_driver(+53): no value >> > for library_directory, using default [/usr/lib/dbmail] >> > M >> > >> > Now I remember that while building it copied to >> > /usr/local/lib/dbmail...so I copied the complete folder from there >> > /usr/lib/dbmail >> > >> > Executing the command again gave me: >> > >> > May 23 22:48:45 Debug:[db] dbmodule.c,db_load_driver(+53): no value >> > for library_directory, using default [/usr/lib/dbmail] >> > May 23 22:48:45 Debug:[db] dbmodule.c,db_load_driver(+69): looking for >> > mysql as /usr/lib/dbmail/libmysql.so >> > May 23 22:48:45 Debug:[sql] dbmysql.c,db_query(+290): query [SHOW >> > VARIABLES LIKE 'collation_%'] >> > May 23 22:48:45 Debug:[sql] dbmysql.c,db_mysql_check_collations(+120): >> > does [collation_database:latin1_swedish_ci] match >> > [collation_connection:latin1_swedish_ci]? >> > May 23 22:48:45 Debug:[auth] authmodule.c,auth_load_driver(+48): no >> > value for library_directory, using default [/usr/lib/dbmail] >> > May 23 22:48:45 Debug:[auth] authmodule.c,auth_load_driver(+64): >> > looking for auth_sql as /usr/lib/dbmail/libauth_sql.so >> > May 23 22:48:45 Debug:[user] dbmail-user.c,do_add(+68): Adding user >> > ritesh with password type ,0 bytes mailbox limit and clientid 0... >> > May 23 22:48:45 Debug:[sql] dbmysql.c,db_query(+290): query [SELECT >> > user_idnr FROM dbmail_users WHERE lower(userid) = lower('ritesh')] >> > May 23 22:48:45 Error:[sql] dbmysql.c,db_query(+292): [No database >> > selected] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = >> > lower('ritesh')] >> > May 23 22:48:45 Error:[db] db.c,db_user_exists(+4649): could not >> > select user information >> > Failed: check logs for details >> > Command failed. >> > >> > Now I am stuck? What should I do? >> > >> >> _______________________________________________ >> DBmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- Ritesh http://www.riteshn.com _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
