Database Error: Connection Failed!

Discuss according roundcube product has the main webmail managed by artica

Re: Database Error: Connection Failed! [CLOSED]

New postby zetar » Sun Mar 31, 2013 8:55 am

Finally something said, here is output

11:04:15 [14517] [DAEMON]:::::TestingConnection:: mysql_connect(127.0.0.1:3306,..failed (N:2003) "Can't connect to MySQL server on '127.0.0.1' (99)" called by exec.syslog-engine.php ipblocks() line 53 (L.233) in class.mysql.inc line 233
11:04:15 [14517] [DAEMON]:::::TestingConnection:: mysql_connect(127.0.0.1:3306,..failed (N:2003) "Can't connect to MySQL server on '127.0.0.1' (99)" called by exec.syslog-engine.php ipblocks() line 53 (L.233) in class.mysql.inc line 233
11:04:15 [14517] [DAEMON]:::::TestingConnection:: mysql_connect(127.0.0.1:3306,..failed (N:2003) "Can't connect to MySQL server on '127.0.0.1' (99)" called by exec.syslog-engine.php ipblocks() line 53 (L.233) in class.mysql.inc line 233
11:04:15 [14517] [DAEMON]:::::TestingConnection:: mysql_connect(127.0.0.1:3306,..failed (N:2003) "Can't connect to MySQL server on '127.0.0.1' (99)" called by exec.syslog-engine.php ipblocks() line 53 (L.233) in class.mysql.inc line 233
11:04:15 [14517] [DAEMON]:::::TestingConnection:: mysql_connect(127.0.0.1:3306,..failed (N:2003) "Can't connect to MySQL server on '127.0.0.1' (99)" called by exec.syslog-engine.php ipblocks() line 53 (L.233) in class.mysql.inc line 233

)" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
11:15:24 [31531] [DAEMON]:::::system_admin_events_checks:: system_admin_events:scanarp_mysql/exec.arpscan.php: Task `0` 93 bytes in exec.syslog-engine.php line 862

This error after putting in a MySQL root password that was not there before
11:52:59 [21645] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"artica_events" Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND DATE_FORMAT( time_connect, '%Y-%m-%d' ) = DATE_FORMAT( NOW( ) , '%Y-%m-%d'' at line 2
WHERE () AND DATE_FORMAT( time_connect, '%Y-%m-%d' ) = DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) AND (whitelisted=1)" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
zetar
 
Posts: 345
Joined: Sat Dec 11, 2010 9:31 am
Artica servers number: 1
Linux System: Ubuntu
Technical skills: A newbee

Re: Database Error: Connection Failed!

New postby abolinhas » Sun Mar 31, 2013 3:20 pm

what is your artica version ?
Cumprimentos / Best Regards

André Bolinhas
Twitter: @abolinhas
User avatar
abolinhas
 
Posts: 1015
Joined: Fri Jun 19, 2009 8:50 am
Location: Portugal
Artica servers number: 4
Linux System: Ubuntu
Technical skills: A Linux System Administrator

Re: Database Error: Connection Failed!

New postby admin » Sun Mar 31, 2013 10:52 pm

try with the new release
User avatar
admin
Site Admin
 
Posts: 11941
Joined: Wed Oct 17, 2007 7:59 am
Location: France

Re: Database Error: Connection Failed!

New postby zetar » Mon Apr 01, 2013 10:09 am

Version Artica: 1.7.040113
This' output after upgrading.

16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field='uid'' at line 1
called by class.mysql.squid.builder.php FIELD_EXISTS() line 765 "SHOW FULL FIELDS FROM WHERE Field='uid';" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: "uid" does not exists in table in squidlogs (L.1852) in class.mysql.inc line 1852
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: SHOW FULL FIELDS FROM WHERE Field='uid'; (L.1853) in class.mysql.inc line 1853
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Incorrect table name ''
called by class.mysql.squid.builder.php QUERY_SQL() line 1991 "ALTER TABLE `` ADD `uid` VARCHAR( 128 ) NOT NULL,ADD INDEX ( uid )" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Specified key was too long; max key length is 1000 bytes
called by class.mysql.squid.builder.php QUERY_SQL() line 3311 "CREATE TABLE IF NOT EXISTS `squidlogs`.`usersisp` (
) ENGINE = MYISAM;" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php FIELD_EXISTS() line 765 "SHOW FULL FIELDS FROM usersisp WHERE Field='wwwname';" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: "wwwname" does not exists in table usersisp in squidlogs (L.1852) in class.mysql.inc line 1852
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: SHOW FULL FIELDS FROM usersisp WHERE Field='wwwname'; (L.1853) in class.mysql.inc line 1853
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php QUERY_SQL() line 3314 "ALTER TABLE `usersisp` ADD `wwwname` VARCHAR( 255 ) NOT NULL ,ADD KEY `wwwname` (`wwwname`)" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php FIELD_EXISTS() line 765 "SHOW FULL FIELDS FROM usersisp WHERE Field='ProxyPacDatas';" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: "ProxyPacDatas" does not exists in table usersisp in squidlogs (L.1852) in class.mysql.inc line 1852
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: SHOW FULL FIELDS FROM usersisp WHERE Field='ProxyPacDatas'; (L.1853) in class.mysql.inc line 1853
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php QUERY_SQL() line 3363 "ALTER TABLE `usersisp` ADD `ProxyPacDatas` TEXT" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php FIELD_EXISTS() line 765 "SHOW FULL FIELDS FROM usersisp WHERE Field='ProxyPacRemoveProxyListAtTheEnd';" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: "ProxyPacRemoveProxyListAtTheEnd" does not exists in table usersisp in squidlogs (L.1852) in class.mysql.inc line 1852
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: SHOW FULL FIELDS FROM usersisp WHERE Field='ProxyPacRemoveProxyListAtTheEnd'; (L.1853) in class.mysql.inc line 1853
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php QUERY_SQL() line 3364 "ALTER TABLE `usersisp` ADD `ProxyPacRemoveProxyListAtTheEnd` SMALLINT( 1 ) NOT NULL" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php FIELD_EXISTS() line 765 "SHOW FULL FIELDS FROM usersisp WHERE Field='ProxyPacCompiled';" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: "ProxyPacCompiled" does not exists in table usersisp in squidlogs (L.1852) in class.mysql.inc line 1852
16:35:04 [14608] [DAEMON]:::::FIELD_EXISTS:: SHOW FULL FIELDS FROM usersisp WHERE Field='ProxyPacCompiled'; (L.1853) in class.mysql.inc line 1853
16:35:04 [14608] [DAEMON]:::::mysql/QUERY_SQL:: QUERY_SQL:: DB:"squidlogs" Error Table 'squidlogs.usersisp' doesn't exist
called by class.mysql.squid.builder.php QUERY_SQL() line 3365 "ALTER TABLE `usersisp` ADD `ProxyPacCompiled` TEXT NOT NULL" line:801 of class.mysql.inc (L.0) in class.mysql.inc0
16:35:33 [15678] [DAEMON]:::::system_admin_events_checks:: system_admin_events:scanarp_mysql/exec.arpscan.php: Task `0` 93 bytes in exec.syslog-engine.php line 862
zetar
 
Posts: 345
Joined: Sat Dec 11, 2010 9:31 am
Artica servers number: 1
Linux System: Ubuntu
Technical skills: A newbee

Re: Database Error: Connection Failed!

New postby abolinhas » Mon Apr 01, 2013 4:00 pm

This errors are all about squid services.
The roundcube still don't working ?
Cumprimentos / Best Regards

André Bolinhas
Twitter: @abolinhas
User avatar
abolinhas
 
Posts: 1015
Joined: Fri Jun 19, 2009 8:50 am
Location: Portugal
Artica servers number: 4
Linux System: Ubuntu
Technical skills: A Linux System Administrator

Re: Database Error: Connection Failed!

New postby zetar » Mon Apr 01, 2013 5:08 pm

I have seen, I do not use Squid.
For roundcube we have to wait a few days, because it was not a constant error.
leave open the post a few days. ok
Thank you ..
zetar
 
Posts: 345
Joined: Sat Dec 11, 2010 9:31 am
Artica servers number: 1
Linux System: Ubuntu
Technical skills: A newbee

Re: Database Error: Connection Failed!

New postby abolinhas » Mon Apr 01, 2013 5:29 pm

sure
Cumprimentos / Best Regards

André Bolinhas
Twitter: @abolinhas
User avatar
abolinhas
 
Posts: 1015
Joined: Fri Jun 19, 2009 8:50 am
Location: Portugal
Artica servers number: 4
Linux System: Ubuntu
Technical skills: A Linux System Administrator

Re: Database Error: Connection Failed!

New postby zetar » Mon Apr 08, 2013 8:46 am

Hello, it seems that for the moment there are no database errors.
We can close the post.
Thanks for your cooperation.
zetar
 
Posts: 345
Joined: Sat Dec 11, 2010 9:31 am
Artica servers number: 1
Linux System: Ubuntu
Technical skills: A newbee

Previous

Return to RoundCube

Who is online

Users browsing this forum: No registered users and 2 guests

cron