Loading...
 
Architecture / Installation

Architecture / Installation


SQLSTATE[HY000] [2003] Can't connect to MySQL server

posts: 8 South Korea

I got the following error messages when I install Tiki 6.2 using remote mysql database, and with changed mysql listen port from 3306 to 3321.

SQLSTATEHY000 2003 Can't connect to MySQL server on '122.34.xxx.xxx' (111)

I have several test case;

-- Case #1
Local database and use 3321 listen port, Tiki install was succeed.

-- Case #2
Remote database and use 3306 listen port, Tiki install was succeed.

--Case #3
Remote database and use 3321 listen port (not default port), Tiki install was failed. At this case, mysql command connect to remote database is okay. That is,

mysql -u testwiki -p xxxx -h 122.34.xxx.xxx

But Tiki install was failed with following error messages

Error message from Web browser:
SQLSTATEHY000 2003 Can't connect to MySQL server on '122.34.151.75' (111)

Error message from Apache error_log:
Tue Mar 08 14:59:20 2011 error client 192.168.3.1 PHP Warning: array_shift() expects parameter 1 to be array, boolean given in /d1/scms/tiki/installer/tiki-installer.php on line 1010, referer: http://hactus99.seriends.co.kr:8080/tiki-install.php
Tue Mar 08 14:59:20 2011 error client 192.168.3.1 PHP Warning: array_shift() expects parameter 1 to be array, boolean given in /d1/scms/tiki/installer/tiki-installer.php on line 1011, referer: http://hactus99.seriends.co.kr:8080/tiki-install.php

(IP address 192.168.3.1 is the local gateway address)

That is I can't understand how to specify database listen port at Tiki Wiki when I install Tiki Wiki?

There are no comments at this time.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting