Login

08-10-2011, 01:00 AM

[eluser]kadishmal[/eluser]
Just in case, here is the configurations necessary to establish DB Connection with CUBRID.

Code:
$db['default']['hostname'] = 'localhost';

$db['default']['port'] = '33000';

$db['default']['username'] = 'dba';

$db['default']['password'] = 'ci_pass';

$db['default']['database'] = 'ci_demo';

$db['default']['auto_commit'] = TRUE;

$db['default']['dbdriver'] = 'cubrid';

$db['default']['dbprefix'] = 'tbl_';

1. port parameter represents the port of the CUBRID Broker. By default it is 33000. To check which one is yours, run the following command. This assumes that your CUBRID Service is running.

Code:
% cubrid service status

should output something like:

Code:
@ cubrid master status

++ cubrid master is running.

@ cubrid server status

 Server ci_demo (rel 8.4, pid 5042)

@ cubrid broker status

  NAME           PID  PORT  AS  JQ      REQ  TPS  QPS    LONG-T    LONG-Q  ERR-Q

================================================================================

* query_editor  5007 30000   5   0        0    0    0    0/0.0    0/0.0      0

* broker1       5017 33000   5   0       12   10    4    0/0.0    0/0.0      0

@ cubrid manager server status

++ cubrid manager server is running.

As you can see the CUBRID Broker (broker1) is listening to port 33000.

2. Also you can set the auto_commit parameter to FALSE which will allow you to run your Web app in dry mode, i.e. all INSERTs to the DB will not be committed.

If any questions, feel free to ask.