Mail get stuck in queue

Hi i have installed sql driven postfix from this gude "Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.04)".

And the problem is all mails i send to it gets stuck in queue and i can't figure out why it dosen't get delivered. Here is what the log says when it tries to retrew mail

found this in /var/log/mail.err log, its a few hours erlier but will post it anyway
Jul 27 20:43:04 web1 postfix/qmgr[565]: fatal: timeout connecting to transport: virtual

 

Code:

Jul 27 20:43:04 web1 postfix/qmgr[565]: fatal: timeout connecting to transport: virtual

You get this more often?

add a "-v" to the virtual line in your master.cf to see why it's giving that error.

 

After i put in -v in master.cf i got this when i revice mail

Could this be the issue?

 

Code:

Jul 28 11:18:09 web1 postfix/virtual[7865]: dict_open: proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf

if i'm not mistaking, that should be:

Code:

mysql:/etc/postfix/mysql-virtual_mailboxes.cf

(in main.cf)

edit: Also, could you show me the contents of /etc/postfix/mysql-virtual_mailboxes.cf and the contents of /etc/hosts and the output of "netstat -tapn | grep 3306" ?

 

Changing from:
proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
to
mysql:/etc/postfix/mysql-virtual_mailboxes.cf

did the trick, now every mail has been delivered.

Thank you very mutch for your help!

 

awesome