aciditys-computer:/var/log acidity$ dbmail-users -l -f /etc/dbmail.conf
May 24 19:59:01 Error:[sql] dbmysql.c,db_query(+296): [No database
selected] [SELECT userid FROM dbmail_users ORDER BY userid]
May 24 19:59:01 Error:[auth] authsql.c,__auth_query(+273): error executing query
May 24 19:59:01 Error:[auth] authsql.c,auth_get_known_users(+80):
could not retrieve user list
aciditys-computer:/var/log acidity$ cd
/usr/local/mysql-max-5.0.24a-osx10.4-i686/
aciditys-computer:/usr/local/mysql-max-5.0.24a-osx10.4-i686 acidity$
sudo cat data/mysql.log
Password:
/usr/local/mysql/bin/mysqld, Version: 5.0.24a-max-log. started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
070524 19:59:01 1 Connect [EMAIL PROTECTED] as anonymous on
1 Query SHOW VARIABLES LIKE 'collation_%'
1 Query SELECT userid FROM dbmail_users
ORDER BY userid
1 Quit
aciditys-computer:/usr/local/mysql-max-5.0.24a-osx10.4-i686 acidity$
sudo cat data/mysql-error.log
070524 19:46:20 mysqld started
070524 19:46:20 [Warning] Setting lower_case_table_names=2 because
file system for /usr/local/mysql/data/ is case insensitive
070524 19:46:20 InnoDB: Started; log sequence number 0 315770
070524 19:46:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.24a-max-log' socket: '/tmp/mysql.sock' port: 3306
MySQL Community Edition - Experimental (GPL)
Nothing seems to be wrong. I will try an old stable version now.
Probably that will help.
On 5/24/07, Jorge Bastos <[EMAIL PROTECTED]> wrote:
Can be something on mysql.
If you put mysql loggin and check the logs u see anything?
----- Original Message -----
From: "Ritesh Nadhani" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Thursday, May 24, 2007 9:19 PM
Subject: Re: [Dbmail] Problem getting dbmail to run on Mac OS X Tiger
(bugfound)
> Same problem.
>
> aciditys-computer:/etc/postfix acidity$ dbmail-users -l -f
> /etc/dbmail.conf
> May 24 15:17:22 Error:[sql] dbmysql.c,db_query(+296): [No database
> selected] [SELECT userid FROM dbmail_users ORDER BY userid]
> May 24 15:17:22 Error:[auth] authsql.c,__auth_query(+273): error executing
> query
> May 24 15:17:22 Error:[auth] authsql.c,auth_get_known_users(+80):
> could not retrieve user list
>
> And here is my dbmail.conf which is there in /etc/
>
> http://cs.uiowa.edu/~rnadhani/dbmail.conf
>
> Do you want me to download an earlier version and try?
>
> On 5/24/07, Paul J Stevens <[EMAIL PROTECTED]> wrote:
>>
>> 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
>>
>
>
> --
> Ritesh
> http://www.riteshn.com
> _______________________________________________
> DBmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
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
