[resolved] connect_to_sql: unable to connect to any dataset (IPSc. 3 / debian 8.4 / dovecot)

Hello,

and first of all thanks for the great tutorial(s). I used this tut to install ISPConfig:
https://www.howtoforge.com/tutorial...ix-dovecot-mysql-phpmyadmin-rkhunter-binutils

Everything is just fine but i'm not getting the mailserver ready.

Here's the output of my "mail failure protocol":

Code:

Jun 12 07:11:46 rs33131 amavis[17532]: (17532-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 07:16:46 rs33131 amavis[1546]: (01546-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 07:21:46 rs33131 amavis[15146]: (15146-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 08:21:46 rs33131 amavis[26216]: (26216-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 08:26:46 rs33131 amavis[4961]: (04961-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.

And the output of "mail warning protocol"

Code:

Jun 12 19:01:46 rs33131 amavis[31387]: (31387-01) (!)Requesting process rundown after fatal error
Jun 12 20:01:46 rs33131 amavis[8151]: (08151-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Access denied for user 'ispconfig'@'localhost' (using password: YES)
Jun 12 20:01:46 rs33131 amavis[8151]: (08151-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 20:01:46 rs33131 amavis[8151]: (08151-01) (!)Requesting process rundown after fatal error
Jun 12 20:06:46 rs33131 amavis[16831]: (16831-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Access denied for user 'ispconfig'@'localhost' (using password: YES)
Jun 12 20:06:46 rs33131 amavis[16831]: (16831-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 20:06:46 rs33131 amavis[16831]: (16831-01) (!)Requesting process rundown after fatal error
Jun 12 20:11:46 rs33131 amavis[31651]: (31651-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Access denied for user 'ispconfig'@'localhost' (using password: YES)
Jun 12 20:11:46 rs33131 amavis[31651]: (31651-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.
Jun 12 20:11:46 rs33131 amavis[31651]: (31651-01) (!)Requesting process rundown after fatal error
Jun 12 21:11:46 rs33131 amavis[10309]: (10309-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Access denied for user 'ispconfig'@'localhost' (using password: YES)
Jun 12 21:11:46 rs33131 amavis[10309]: (10309-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 96) line 252.

I can access the database when i try to login with the credentials in dovecot-sql.conf.

Here's the output of netstat -tap:

Code:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:ftp                   *:*                     LISTEN      26985/pure-ftpd (SE
tcp        0      0 rs33131.domainte:domain *:*                     LISTEN      30400/named
tcp        0      0 localhost:domain        *:*                     LISTEN      30400/named
tcp        0      0 *:ssh                   *:*                     LISTEN      31677/sshd
tcp        0      0 *:smtp                  *:*                     LISTEN      21357/smtpd
tcp        0      0 localhost:953           *:*                     LISTEN      30400/named
tcp        0      0 *:https                 *:*                     LISTEN      707/apache2
tcp        0      0 *:imaps                 *:*                     LISTEN      17879/dovecot
tcp        0      0 *:pop3s                 *:*                     LISTEN      17879/dovecot
tcp        0      0 localhost:8999          *:*                     LISTEN      4641/php-fpm.conf)
tcp        0      0 localhost:10024         *:*                     LISTEN      16427/amavisd-new (
tcp        0      0 localhost:10025         *:*                     LISTEN      22345/master
tcp        0      0 *:mysql                 *:*                     LISTEN      23990/mysqld
tcp        0      0 localhost:11211         *:*                     LISTEN      31118/memcached
tcp        0      0 *:pop3                  *:*                     LISTEN      17879/dovecot
tcp        0      0 *:imap2                 *:*                     LISTEN      17879/dovecot
tcp        0      0 *:http-alt              *:*                     LISTEN      707/apache2
tcp        0      0 *:http                  *:*                     LISTEN      707/apache2
tcp        0      0 *:tproxy                *:*                     LISTEN      707/apache2

I'm really an amateur in linux thing so please go easy on me....

Thank you for your help! It's really urgent (actually)...

Thanks,
Niko

 

Output of the system test script:
https://www.howtoforge.com/community/threads/please-read-before-posting.58408/

Code:

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
IP-address(es) (as per ifconfig): ***.***.***.***
[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.0.5.4p9


##### VERSION CHECK #####

[INFO] php (cli) version is 5.6.20-0+deb8u1
[INFO] php-cgi (used for cgi php in default vhost!) is version 5.6.20-0+deb8u1

##### PORT CHECK #####

[WARN] Port 465 (SMTP server SSL) seems NOT to be listening

##### MAIL SERVER CHECK #####


##### RUNNING SERVER PROCESSES #####

[INFO] I found the following web server(s):
        Apache 2 (PID 7390)
[INFO] I found the following mail server(s):
        Unknown process (smtpd) (PID 21794)
[INFO] I found the following pop3 server(s):
        Dovecot (PID 17879)
[INFO] I found the following imap server(s):
        Dovecot (PID 17879)
[INFO] I found the following ftp server(s):
        PureFTP (PID 26985)

##### LISTENING PORTS #####
(only           ()
Local           (Address)
[anywhere]:21           (26985/pure-ftpd)
***.***.***.***:53              (30400/named)
[localhost]:53          (30400/named)
[anywhere]:22           (31677/sshd)
[anywhere]:25           (21794/smtpd)
[localhost]:953         (30400/named)
[anywhere]:443          (7390/apache2)
[anywhere]:993          (17879/dovecot)
[anywhere]:995          (17879/dovecot)
[localhost]:8999                (4641/php-fpm.conf))
[localhost]:10024               (5610/amavisd-new)
[localhost]:10025               (22345/master)
[anywhere]:3306         (23990/mysqld)
[localhost]:11211               (31118/memcached)
[anywhere]:110          (17879/dovecot)
[anywhere]:143          (17879/dovecot)
[anywhere]:8080         (7390/apache2)
[anywhere]:80           (7390/apache2)
[anywhere]:8081         (7390/apache2)

 

Thank you for your reply. - I just resolved the problem by myself --> reconfigured postfix, amavis, spamassain and clamav.

I really don't know where i made a mistake but seems like something went wrong while installing ISPConfig.

Thank you anyway!
Niko

 

Hi Niko,

I am suffering by the exact same issue (well I do get the same error messages in the logs).
How did you reconfigured postfix, amavis, spamassain and clamav?
Was it a matter of "apt-get purge" and then reinstall following the tutorial?
Did you have to run the ispconfig update script, post reconfiguring the packages above?

Do you mind sharing a bit more detail on your "fix"?

Thanks in advance,
GeorgeG