Problems with postfix-mysql

[Pelle]

Hey!

Thank you very much for the help here! I cant explain the problem, but the solution have been:

Have seperate users for the database and restart!

Of some reason it helped when I created a new user!

I found that, because of some mistake when editing some of the mysql*.cf files I removed the user line! and then the /var/log/mail.log told me that it was the wrong username and password?!

And now my mail server works! thank you for the help!

NOTE! The user for the database I first used worked well and is still in use now, just only for pureftpd-mysql!

[gus]

Hi all

I've a Debian sarge testing server (i'd tried with stable too) and a month ago i'd to reinstall, but the server never was the same

in the past I was running with courier+postfix+mysql but at reinstallation i've the same error every time i try to connect via smtp (courier pop & imap are ok):

Nov <timestamp> lared postfix/trivial-rewrite[9542]: fatal: mysql:/etc/postfix/virtual.cf(0,100): table lookup problem

i've tried using mysql 4.1 and 5.0 (i don't remember what version of mysql-server was running before), it's all ok, all users, all passwords... i tried with root user too!!

any idea??

[falko]

Originally Posted by gus

Hi all

I've a Debian sarge testing server (i'd tried with stable too) and a month ago i'd to reinstall, but the server never was the same

in the past I was running with courier+postfix+mysql but at reinstallation i've the same error every time i try to connect via smtp (courier pop & imap are ok):

Nov <timestamp> lared postfix/trivial-rewrite[9542]: fatal: mysql:/etc/postfix/virtual.cf(0,100): table lookup problem

i've tried using mysql 4.1 and 5.0 (i don't remember what version of mysql-server was running before), it's all ok, all users, all passwords... i tried with root user too!!

any idea??

Make sure that the MySQL user and password are correct. Which Postfix version do you use? Run

postconf -d | grep mail_version

to find that out.

[gus]

server:/etc/postfix# postconf -d | grep mail_version
mail_version = 2.2.4

user & passwords are ok, i'd tryed loggin directly too:

server:/etc/postfix# mysql -u <user>
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 101 to server version: 5.0.13-rc-Debian_1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

[falko]

Ok, the format of the MySQL lookups changed from Postfix 2.1 to Postfix 2.2 (in Debian stable you have Postfix 2.1.5). What's in /etc/postfix/virtual.cf?

BTW, is your problem somehow related to this tutorial: http://www.howtoforge.com/virtual_po..._quota_courier?

[gus]

virtual.cf contents:

user = <user_name>
password = -> I left blank password while errors
dbname = maildb
table = virtual
select_field = goto
where_field = address
hosts = server

server = computer name = LAN IP Address... don't rules with localhost and 127.0.0.1 too

My virtual table is:

CREATE TABLE virtual (
address varchar(255) NOT NULL default '',
goto varchar(255) NOT NULL default '',
UNIQUE KEY address (address)
) TYPE=MyISAM;

My guide to config was this (in spanish): http://lared.dsland.org/tmp/Postfix%...20MySQL%20.txt that i got from http://valenciawireless.net/weblog/v...03062417002455

My server was running with sarge testing from june to october (postfix was running perfect), stable in october (problems) and testing again three weeks ago (still having problems)

Now... How we name the baby?

[falko]

Try this in your virtual.cf:

user = <user_name>
password = <password>
hosts = server
dbname = maildb
query = SELECT goto FROM virtual WHERE address='%s'

and restart Postfix.

[gus]

nothing happens

the problem is there yet

no incoming / outgoing mail throught postfix

I should change all .cf files 'cause all appears at /var/log/mail.err with a "table lookup problem" message

I think the problem isn't in postfix configuration, is in the postfix-mysql connector.

how could I downgrade postfix with aptitude?

thanks for your help

[falko]

Originally Posted by gus

I think the problem isn't in postfix configuration, is in the postfix-mysql connector.

I don't think it's a problem with the Postfix package (your Postfix package is from testing, not unstable), but rather with the configuration.
Did you have a look at this tutorial: http://www.howtoforge.com/virtual_po..._quota_courier?

[gus]

I'll read it tomorrow after job...

thanks