Squirrelmail login failure

Discussion in 'Installation/Configuration' started by Cracklefish, Jun 23, 2010.

  1. Cracklefish

    Cracklefish Member

    Since upgrading to ISPC 3.0.2.1, Squirrelmail has stopped working. As it is only occasionally used, it took some time for the problem to become apparent so this might not be due to the upgrade.

    At the login page an error message - "You must be logged in to access this page. " is received after correct username and password.

    An incorrect username or password results in "Unknown user or password incorrect."

    Another post suggested that a reinstall of Postfix would be a cure but it didn't work for me.

    System is openSUSE 11.1 and Perfect Server Tutorial
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Thois does not seem to be a squirrelmail error message. Please post a screenshot.
     
  3. Cracklefish

    Cracklefish Member

    mmmmmmmmmmmmmmmm
     

    Attached Files:

  4. Cracklefish

    Cracklefish Member

    And in reinstalling Postfix, I seem to have broken the SMPT server. This is refusing connections. Is this because the Yast install routine has modified the config files?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    The login in squirrelmail is handled by either courier or dovecot and not postfix. But I doubt that your problem has to do with a authentication problem of these services, most likely it is an apache or browser issue with session permissions.

    Regarding your postfix problem: Yes, yast destroys the config on a reinstall of a application. You have to download the latest ispconfig, run the update.php script and select to reconfigure services to fix this.
     
  6. Cracklefish

    Cracklefish Member

    The ISPC Upgrade/reinstall went fine with no errors but still theSMTP server is refusing connections.
     
  7. falko

    falko Super Moderator Howtoforge Staff

    Are there any errors in your mail log?
     
  8. Cracklefish

    Cracklefish Member

    Here is an excerpt from val/log/mail...

    Code:
    Jun 30 10:45:10 Golf1 postfix/qmgr[7759]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:45:11 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7759 exit status 1
    Jun 30 10:45:11 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:45:13 Golf1 postfix/smtpd[7760]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:45:14 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7760 exit status 1
    Jun 30 10:45:14 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:45:18 Golf1 postfix/pickup[6970]: fatal: watchdog timeout
    Jun 30 10:45:19 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/pickup pid 6970 exit status 1
    Jun 30 10:45:19 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/pickup: bad command startup -- throttling
    Jun 30 10:45:35 Golf1 postfix/proxymap[7764]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:45:36 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:45:36 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 7764 exit status 1
    Jun 30 10:45:36 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:46:11 Golf1 postfix/qmgr[7794]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:46:12 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7794 exit status 1
    Jun 30 10:46:12 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:46:14 Golf1 postfix/smtpd[7795]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:46:15 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7795 exit status 1
    Jun 30 10:46:15 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:46:36 Golf1 postfix/proxymap[7797]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:46:37 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:46:37 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 7797 exit status 1
    Jun 30 10:46:37 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:47:12 Golf1 postfix/qmgr[7830]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:47:13 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7830 exit status 1
    Jun 30 10:47:13 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:47:15 Golf1 postfix/smtpd[7831]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:47:16 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7831 exit status 1
    Jun 30 10:47:16 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:47:37 Golf1 postfix/proxymap[7832]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:47:38 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:47:38 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 7832 exit status 1
    Jun 30 10:47:38 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:48:13 Golf1 postfix/qmgr[7865]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:48:14 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7865 exit status 1
    Jun 30 10:48:14 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:48:16 Golf1 postfix/smtpd[7866]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:48:17 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7866 exit status 1
    Jun 30 10:48:17 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:48:38 Golf1 postfix/proxymap[7868]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:48:39 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 7868 exit status 1
    Jun 30 10:48:39 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:48:39 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:49:01 Golf1 clamd[5319]: SelfCheck: Database status OK.
    Jun 30 10:49:14 Golf1 postfix/qmgr[7899]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:49:15 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7899 exit status 1
    Jun 30 10:49:15 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:49:17 Golf1 postfix/smtpd[7900]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:49:18 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7900 exit status 1
    Jun 30 10:49:18 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:49:39 Golf1 postfix/proxymap[7901]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:49:40 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:49:40 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 7901 exit status 1
    Jun 30 10:49:40 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:50:02 Golf1 pop3d: Connection, ip=[::ffff:127.0.0.1]
    Jun 30 10:50:02 Golf1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
    Jun 30 10:50:02 Golf1 imapd: Connection, ip=[::ffff:127.0.0.1]
    Jun 30 10:50:02 Golf1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
    Jun 30 10:50:15 Golf1 postfix/qmgr[7962]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:50:16 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7962 exit status 1
    Jun 30 10:50:16 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:50:18 Golf1 postfix/smtpd[7963]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:50:19 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7963 exit status 1
    Jun 30 10:50:19 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:50:40 Golf1 postfix/proxymap[7964]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:50:41 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:50:41 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 7964 exit status 1
    Jun 30 10:50:41 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:51:16 Golf1 postfix/qmgr[7996]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:51:17 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 7996 exit status 1
    Jun 30 10:51:17 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:51:19 Golf1 postfix/smtpd[7999]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:51:20 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 7999 exit status 1
    Jun 30 10:51:20 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:51:42 Golf1 postfix/proxymap[8004]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:51:43 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 8004 exit status 1
    Jun 30 10:51:43 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:51:43 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:52:17 Golf1 postfix/qmgr[8034]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:52:18 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 8034 exit status 1
    Jun 30 10:52:18 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:52:20 Golf1 postfix/smtpd[8035]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:52:21 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 8035 exit status 1
    Jun 30 10:52:21 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:52:43 Golf1 postfix/proxymap[8038]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:52:44 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 8038 exit status 1
    Jun 30 10:52:44 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:52:44 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:53:18 Golf1 postfix/qmgr[8070]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:53:19 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 8070 exit status 1
    Jun 30 10:53:19 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:53:21 Golf1 postfix/smtpd[8071]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:53:22 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 8071 exit status 1
    Jun 30 10:53:22 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:53:44 Golf1 postfix/proxymap[8072]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:53:45 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:53:45 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 8072 exit status 1
    Jun 30 10:53:45 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:54:19 Golf1 postfix/qmgr[8105]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:54:20 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 8105 exit status 1
    Jun 30 10:54:20 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:54:22 Golf1 postfix/smtpd[8106]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:54:23 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 8106 exit status 1
    Jun 30 10:54:23 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Jun 30 10:54:45 Golf1 postfix/proxymap[8107]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:54:46 Golf1 postfix/cleanup[28951]: warning: private/proxymap socket: service dict_proxy_open: Success
    Jun 30 10:54:46 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/proxymap pid 8107 exit status 1
    Jun 30 10:54:46 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
    Jun 30 10:55:01 Golf1 pop3d: Connection, ip=[::ffff:86.157.196.106]
    Jun 30 10:55:02 Golf1 pop3d: Connection, ip=[::ffff:86.157.196.106]
    Jun 30 10:55:02 Golf1 pop3d: Connection, ip=[::ffff:86.157.196.106]
    Jun 30 10:55:02 Golf1 pop3d: LOGIN, user=***@greenway.co.uk, ip=[::ffff:86.157.196.106], port=[64068]
    Jun 30 10:55:02 Golf1 pop3d: Connection, ip=[::ffff:127.0.0.1]
    Jun 30 10:55:02 Golf1 pop3d: Disconnected, ip=[::ffff:127.0.0.1]
    Jun 30 10:55:02 Golf1 imapd: Connection, ip=[::ffff:127.0.0.1]
    Jun 30 10:55:02 Golf1 imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
    Jun 30 10:55:02 Golf1 pop3d: LOGOUT, user=***@greenway.co.uk, ip=[::ffff:86.157.196.106], port=[64068], top=0, retr=0, rcvd=12, sent=39, time=0
    Jun 30 10:55:02 Golf1 pop3d: Connection, ip=[::ffff:86.157.196.106]
    Jun 30 10:55:02 Golf1 pop3d: LOGIN, user=***@grange-associates.com, ip=[::ffff:86.157.196.106], port=[64063]
    Jun 30 10:55:02 Golf1 pop3d: LOGIN, user=***@crosoer.com, ip=[::ffff:86.157.196.106], port=[64061]
    Jun 30 10:55:03 Golf1 pop3d: LOGOUT, user=***@grange-associates.com, ip=[::ffff:86.157.196.106], port=[64063], top=0, retr=0, rcvd=12, sent=39, time=1
    Jun 30 10:55:03 Golf1 pop3d: LOGIN, user=***@news-source.co.uk, ip=[::ffff:86.157.196.106], port=[64064]
    Jun 30 10:55:03 Golf1 pop3d: LOGOUT, user=***@crosoer.com, ip=[::ffff:86.157.196.106], port=[64061], top=0, retr=0, rcvd=24, sent=1345, time=1
    Jun 30 10:55:05 Golf1 pop3d: LOGOUT, [email protected], ip=[::ffff:86.157.196.106], port=[64064], top=0, retr=0, rcvd=24, sent=847, time=2
    Jun 30 10:55:20 Golf1 postfix/qmgr[8178]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:55:21 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/qmgr pid 8178 exit status 1
    Jun 30 10:55:21 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling
    Jun 30 10:55:23 Golf1 postfix/smtpd[8179]: fatal: dict_open: unsupported dictionary type: mysql:  Is the postfix-mysql package installed?
    Jun 30 10:55:24 Golf1 postfix/master[5214]: warning: process /usr/lib/postfix/smtpd pid 8179 exit status 1
    Jun 30 10:55:24 Golf1 postfix/master[5214]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    
    According to Yast postfix-mysql is not installed. No idea how it got lost, how should I reinstall it? might this explain why the Squirrrelmail login is failing?
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    You have a postfix package installed which does not support mysql. Please install the postfix mysql package. If this does not fix the problem, then run a update on ispconfig and choose to reconfigure services.

    Please compare your setup with the perfect setup guide for the opensuse version that you use. If not all packages are installed as described in this guide, your setup might not work correctly.
     
  10. Cracklefish

    Cracklefish Member

    Brilliant, that has fixed the smtp server. Just got the Squirrelmail problem left now.
     

Share This Page