I'm wondering whether you are actually loading the config file at all. Try 'dbmail-users -l -f /full/path/to/dbmail.conf'
Ritesh Nadhani wrote: > 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 >> > > -- ________________________________________________________________ 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
