Welcome Guest, Not a member yet? Register   Sign In
Basic - Postgres database connectivity
#1

[eluser]Geek[/eluser]
Hi,

I'm pretty new to CodeIgniter, but I have developed a few working pages in the past. I'm trying to refactor those pages and developing them in a Windows box; but I'm stuck with a Postgres database connectivity issue and I'm getting the following error:

Quote:A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: C:\Subayogam_v2.0\Codeigniter\system\database\DB_driver.php

Line Number: 124

I know that this error comes up when the database configuration is missing, but I do have a valid DB configuration at C:\Subayogam_v2.0\Codeigniter\application\config\database.php. Given below is the config file data:

Code:
$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'postgres';
$db['default']['password'] = 'mypassword';
$db['default']['database'] = 'subayogam_v2.0';
$db['default']['dbdriver'] = 'postgre';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = TRUE;
/*$db['default']['cachedir'] = '/var/subayogam_2.0/cache';*/
$db['default']['cachedir'] = 'C:\Subayogam_v2.0\Codeigniter\cache';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

I double checked the cache folder path and also tried a simple PHP page that connects to the same DB to see if the drivers are working, and I'm able to see results from the database. No useful error messages in Apache error log either.

What could be wrong? Is there any specific log file that can provide me with more information on the error?

Thanks in advance!


Messages In This Thread
Basic - Postgres database connectivity - by El Forum - 08-30-2012, 09:53 AM
Basic - Postgres database connectivity - by El Forum - 08-31-2012, 10:13 AM
Basic - Postgres database connectivity - by El Forum - 08-31-2012, 01:09 PM
Basic - Postgres database connectivity - by El Forum - 08-31-2012, 01:23 PM
Basic - Postgres database connectivity - by El Forum - 08-31-2012, 03:32 PM
Basic - Postgres database connectivity - by El Forum - 09-01-2012, 08:42 PM



Theme © iAndrew 2016 - Forum software by © MyBB