Architecture / Installation

Posted by Park JoonHyun 08 Mar 2011 06:42 GMT-0000 posts: 8

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?