Aleksander Kamenik wrote:
Beryl Snyder wrote:
Aleksander Kamenik wrote:
Beryl Snyder wrote:
The database is working fine, mail is sent and revived fine.
any idea where to look at next?
Increase TRACE_STDERR in dbmail.conf and try again from the
commandline. 0 is nothing and 5 is a lot.
.
They only had TRACE_LEVEL i set that equal to 5,still no go;
What the hell is TRACE_LEVEL? Is that something from the 2.0.x or
earlier era? What version of dbmail are you using?
No idea, I inherited this box and TRACE_LEVEL was in the .conf file,
but i am running Version 2.2.5 Swiched to TRACE_SYSLOG and that worked
See Below
You should have two TRACE_ options in dbmail.conf (dbmail 2.2.x).
TRACE_STDERR sets the log level of stderr - errors thrown to your
console. And TRACE_SYSLOG, which will send the errors to /var/log/mail
or /var/log/maillog depending on your distro.
I tryed connecting another dbmail server to that database and adding
a user that way and I got an error. would there be any negative
ramifications if i just manually edited the table to add the
user?(still need to get this fixed but could i use as a work around)
It's easier to fix this probably, so let's solve it.
I added
Thanks, now I have the error messages from TRACE_SYSLOG
[EMAIL PROTECTED] ~]# tail -f /var/log/maillog |grep asdfasdfasdfasdf
Feb 5 16:12:31 .... dbmail/user[22612]: Debug:[user]
dbmail-user.c,do_add(+68): Adding user asdfasdfasdfasdf with password
type ,0 bytes mailbox limit and clientid 0...
Feb 5 16:12:31 .... dbmail/user[22612]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('asdfasdfasdfasdf')]
Feb 5 16:12:31 .... dbmail/user[22612]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT * FROM dbmail_users WHERE userid
= 'asdfasdfasdfasdf']
Feb 5 16:12:31 .... dbmail/user[22612]: Debug:[sql]
dbmysql.c,db_query(+290): query [INSERT INTO dbmail_users
(userid,passwd,client_idnr,maxmail_size,encryption_type, last_login)
VALUES ('asdfasdfasdfasdf','',0,0,'', CURRENT_TIMESTAMP)]
Feb 5 16:12:31 .... dbmail/user[22612]: Error:[sql]
dbmysql.c,db_query(+292): [Duplicate entry '2' for key 1] [INSERT INTO
dbmail_users (userid,passwd,client_idnr,maxmail_size,encryption_type,
last_login) VALUES ('asdfasdfasdfasdf','',0,0,'', CURRENT_TIMESTAMP)]
Regards,
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
