Since I am stuck with this issue as of now. I tried installing dbmail
on an ubuntu server and I followed the exact same steps that I
followed to install on Mac OS X by reading the INSTALL file.
This time though, the example command given in docs:
[EMAIL PROTECTED]:/etc$ dbmail-users -a john -w secret -g 0 -m 25M
-s [EMAIL PROTECTED] [EMAIL PROTECTED] @net.com
Adding INBOX for new user... ok.
[EMAIL PROTECTED]
Done
john:x:4:0:25.00:0.00:@net.com
As you can see...it works. Thus I believe there is some problem while
reading the conf file in Mac OS X.
To check if its an issue introduced in the latest RC, i downloaded an
earlier stable version, 2.2.4 and tried to compile it and I get the
error:
/bin/sh ../libtool --tag=CC --mode=link gcc -I/usr/local/mysql/include
-Os -arch i386 -fno-common -g -O2 -I/sw/include/glib-2.0
-I/sw/lib/glib-2.0/include -I/sw/include/glib-2.0
-I/sw/lib/glib-2.0/include -I/sw/include/gmime-2.0 -W -Wall
-Wpointer-arith -Wstrict-prototypes -module -L/sw/lib -lglib-2.0
-lintl -liconv -L/sw/lib -lgmime-2.0 -lz -lgobject-2.0 -lglib-2.0
-lintl -liconv -o libauth_sql.la -rpath /usr/local/lib/dbmail
authsql.lo -lcrypt
gcc ${wl}-flat_namespace ${wl}-undefined ${wl}suppress -o
.libs/libauth_sql.0.0.0.so -bundle .libs/authsql.o -L/sw/lib
/sw/lib/libgmime-2.0.dylib /sw/lib/libgmodule-2.0.dylib
/sw/lib/libgthread-2.0.dylib -lz /sw/lib/libgobject-2.0.dylib
/sw/lib/libglib-2.0.dylib /sw/lib/libintl.dylib /sw/lib/libiconv.dylib
-lcrypt -arch i386
/usr/bin/ld: can't locate file for: -lcrypt
collect2: ld returned 1 exit status
make[2]: *** [libauth_sql.la] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2
So I am not even able to compile this version.
Any ideas?
On 5/24/07, Ritesh Nadhani <[EMAIL PROTECTED]> wrote:
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
--
Ritesh
http://www.riteshn.com
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
