Menu

sql problem

Anonymous
2003-07-29
2003-08-06
  • Anonymous

    Anonymous - 2003-07-29

    Hello,
    I have the line in /etc/mail/sqlmail.conf:
    MysqlUserTable          user

    When I send some email, it remains in queue with status deferred. Here is what is happening in mysql:

    120 Connect     root@localhost on sendmail
    120 Query       SELECT * FROM (null) WHERE username = 'root'
    120 Quit
    121 Connect     root@localhost on sendmail
    121 Query       select rhs from alias where lhs = 'bobo'
    121 Quit
    122 Connect     root@localhost on sendmail
    122 Query       SELECT * FROM (null) WHERE username = 'bobo'
    122 Quit

    Also, I did not find documented the field maildrop from user table. Please help me with this problem. I use Redhat 9.0 last-patched, and your last version of sendmail-mysql installed as binary rpm.

    Thanks.

     
    • Anonymous

      Anonymous - 2003-07-30

      Solved the problem adding MysqlMailboxTable parameter to sqlmail.conf. That parameter is not added to rpm.

       
    • Kev Green

      Kev Green - 2003-08-06

      Back from holiday now. Glad you sussed it :-)

       

Log in to post a comment.