Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

Unable to have dbmail work on Fedora 11

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


jean.naimard at gmail

Jun 26, 2009, 2:51 PM

Post #1 of 2 (790 views)
Permalink
Unable to have dbmail work on Fedora 11

Greetings.

I am unable to have dbmail work; I have tried to look in the archives,
but they don’t seem to be searchable, all there is is a directory tree.

My problem:

I just installed dbmail on a brand new Fedora 11 server.

Sendmail and procmail work perfectly well (I ran a stress test that had
about 1 gigabytes go through the mail system); I installed dbmail with
the applications manager, created the database back-end with the proper
users and reconfigured sendmail (I use webmin).

I have configured /etc/dbmail.conf with the proper user name, password,
socket path.

It appears I can access the IMAP server; the log reads:


Jun 26 17:28:50 domus dbmail/imap4d[9654]: Message:[serverchild]
serverchild.c,PerformChildTask(+349): incoming connection from [xxxxx]
by pid [9654]
Jun 26 17:28:51 domus dbmail/imap4d[11158]: Message:[server]
pool.c,child_register(+299): register child [11158]
Jun 26 17:28:51 domus dbmail/imap4d[9650]: Message:[server]
pool.c,scoreboard_state(+590): Scoreboard state: children [3/10], spares
[2 (2 - 4)]
Jun 26 17:28:54 domus dbmail/imap4d[9654]: Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1623): user (id:4,
name xxxxx) tries login
Jun 26 17:28:54 domus dbmail/imap4d[9654]: Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1644): user (id 4,
name xxxxx) login accepted


However, the mail does not seems to go to dbmail, but in the “normal”
inbox in /var/spool/mail; which is why I get no mail through IMAP or
even POP (by hand with telnetting into port# 110).


Then, by exploring the various utilities that come with dbmail, listing
the users yields the following:

$ dbmail-users -l *
Jun 26 17:34:45 domus dbmail-users[11177]: Error:[sql]
dbmysql.c,db_connect(+172): mysql_real_connect failed: Access denied for
user 'dbmail'@'xxxxx' to database '/var/lib/dbmail/dbmail.db'
Failed. Could not connect to database (check log)
Command failed.

The log reads:

Jun 26 17:34:45 domus dbmail/user[11177]: Error:[sql]
dbmysql.c,db_connect(+172): mysql_real_connect failed: Access denied for
user 'dbmail'@'xxxxx' to database '/var/lib/dbmail/dbmail.db'



It is possible to connect to the database either locally with "mysql
dbmail -u dbmail -p" on the server or with MySQL Query Browser remotely
and create tables in the dbmail database, fill them with data and
whatnot. The dbmail tables all return an empty set, except for
dbmail_users, which has those 3 records:

+-----------+--------------------------------+
| user_idnr | userid | (I do not show the
+-----------+--------------------------------+
| 1 | __@!internal_delivery_user!@__ | other fields who
| 2 | anyone |
| 3 | __public__ | have zeroes in them)
+-----------+--------------------------------+


So it is not a question of dbase permissions nor of network access being
invalid.


Does anyone would have a clue of what I could be doing wrong?


Thanks in advance.

(Subsidiary question: no chance of a webmin module for dbmail?)

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


vulture at netvulture

Jun 26, 2009, 6:58 PM

Post #2 of 2 (733 views)
Permalink
Re: Unable to have dbmail work on Fedora 11 [In reply to]

Jean Naimard wrote:
> $ dbmail-users -l *
> Jun 26 17:34:45 domus dbmail-users[11177]: Error:[sql]
> dbmysql.c,db_connect(+172): mysql_real_connect failed: Access denied for
> user 'dbmail'@'xxxxx' to database '/var/lib/dbmail/dbmail.db'
> Failed. Could not connect to database (check log)
> Command failed.
>
> The log reads:
>
> Jun 26 17:34:45 domus dbmail/user[11177]: Error:[sql]
> dbmysql.c,db_connect(+172): mysql_real_connect failed: Access denied for
> user 'dbmail'@'xxxxx' to database '/var/lib/dbmail/dbmail.db'
>
It would appear that you have the path to the database not the name of
it in your dbmail.conf as it is trying to use /var/lib/dbmail/dbmail.db
make sure that you have "db = dbmail" in your dbmail.conf. I'm guessing
that you have set driver = mysql already.

-Jon

--
Scanned for viruses and dangerous content by MailScanner

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.