Error reading (/etc/mail/sqlmail.conf)

[Rob Morin]

Hello all, not sure if anyone still reads this list as it seem not to active...

But here i go...

I install the lateset sendmail sql patch sendmail+mysql-8.12.11-7.patch
and sendmail-sql-Makefile-8.12.11-7.patch
All compiled well...

But i keep getting this error in the sendmail log file

sendmail[23090]: Error reading config file (/etc/mail/sqlmail.conf)

I have tried everythign i can think of... chmod 777 that file just in case... deleted it and copied a new one over. removed spaces and put tabs... still same error message and the mappings do NOT work.

here is my sqlmail.conf

MysqlHost               localhost
MysqlSocket             /var/lib/mysql/mysql.sock
#MysqlNetworkPort       3306
MysqlUsername           pop3
MysqlPassword           pop3
MysqlDatabase           sendmail_db
MysqlMapTable           virtusers
#MysqlLHSColumn         default_key_column
#MysqlRHSColumn         default_value_column

Wether i uncomment the comment lines i still get the same error. If i completely delete the file from /etc/mail i still get the same error...

i am using sendmail 8.12.11 on redhat 8.0

Any suggestions??

Thanks...
Rob..

[GG]

this is my /etc/mail/sqlmail.conf file

MysqlHost 127.0.0.1
MysqlUsername <**sql user**>
MysqlPassword <**password**>
MysqlDatabase maildb       <---> your database name is sendmail_db
MysqlUserTable users
MysqlMailboxTable users
MysqlAliasTable alias
#MysqlMapTable maps
MysqlLHSColumn address
MysqlRHSColumn goto

try to check if you can open the database by typing in #mysql -u pop3 -ppop3 sendmail_db

if you get error, you might have problem with your grand statement in the mysql server.

kveja/regards
Gestur