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
-- Ritesh http://www.riteshn.com _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
