This topic is locked

Manual DB configuration

6/22/2015 9:29:46 PM
PHPRunner General questions
S
sgchan author

Hi, it used to be that you'd modify the DBCOMMON.php file to reconfigure the db connection when you deploy. Now that has changed with PHPRunner v8. May I ask what needs to be done?
I have modified the ConnectionManager.php



$data = array();

$data["dbType"] = 0;

$data["connId"] = "kuok_oa_at_localhost";

$data["connName"] = "kuok_oa at localhost";

$data["connStringType"] = "mysql";

$data["connectionString"] = "mysql;localhost;kuokfoun_oa;P455word!@#$%;;kuokfoun_oa;;1"; //currently unused
$this->_connectionsIdByName["kuok_oa at localhost"] = "kuok_oa_at_localhost";
$data["connInfo"] = array();

$data["ODBCUID"] = "[UserName]";

$data["ODBCPWD"] = "[Password]";

$data["leftWrap"] = "";
$data["rightWrap"] = "
";
$data["DBPath"] = "db"; //currently unused

$data["useServerMapPath"] = 1; //currently unused
$data["connInfo"][0] = "localhost";

$data["connInfo"][1] = "[UserName]";

$data["connInfo"][2] = "[Password]";

$data["connInfo"][3] = "";

$data["connInfo"][4] = "[DatabaseName]";

$data["connInfo"][5] = ""; //currently unused

$data["connInfo"][6] = "1"; //currently unused

$data["ODBCString"] = "DRIVER={MySQL ODBC 5.1 Driver};Server=localhost;Uid=[UserName];Pwd=[Password];Database=[DatabaseName];OPTION=3";

$connectionsData["kuok_oa_at_localhost"] = $data;

$this->_connectionsData = $connectionsData;


When I load the system it will give the below error message:



Notice: Undefined index: myqsladdress in /home/kuokfoundation/public_html/apply/connections/MySQLiConnection.php on line 64

Notice: Undefined index: line in /home/kuokfoundation/public_html/apply/include/phpfunctions.php on line 2286

Notice: Undefined index: file in /home/kuokfoundation/public_html/apply/include/phpfunctions.php on line 2287
Error type 2

Error description Cannot modify header information - headers already sent by (output started at /home/kuokfoundation/public_html/apply/connections/MySQLiConnection.php:64)

URL <some URL>

Error file /home/folder/public_html/apply/include/commonfunctions.php

Error line 2610


But if I refresh page, the error is resolved. What is the proper way to deploy manually?