Welcome Guest, Not a member yet? Register   Sign In
Blank page with PostgreSQL
#1

[eluser]NachoF[/eluser]
Im having a problem connecting to database... on my localhost I cant connect to postgresql database but I can connect just fine to my mysql database.... when I try with postgre I get a blank page immediately... here are my two configs so you can see exactly what I changed.
This works
Code:
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "root";
$db['default']['password'] = "12345";
$db['default']['database'] = "mydatabase";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
This doesnt
Code:
$active_group = "default";
$active_record = TRUE;

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "postgres";
$db['default']['password'] = "12345";
$db['default']['database'] = "mydatabase";
$db['default']['dbdriver'] = "postgre";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

I wish it could at least give me some kind of error

My setup is Windows 7 with XAMPP and PostgreSQl (PGadmin works just fine)
#2

[eluser]WanWizard[/eluser]
A blank page usually suggests a PHP error with error_reporting() turned off. Check your webserver error log to see what the error was...
#3

[eluser]NachoF[/eluser]
well, error reporting is turned on by default in CI... and I am able to get some errors if I purposely mistype something...also, error.log doesnt show anything new after I load the site...

Remember that it works just fine with mysql just not with postgre....

dont know if its got something to do with the fact that I had some troubles installing postgre but its working fine now (at least pgadmin)
#4

[eluser]NachoF[/eluser]
Maybe I have to edit something in my php.ini file?? Im using latest xampp (php 5..3) and newest CI
#5

[eluser]kea13[/eluser]
Hi NachoF,

have you looked at the access permissions for your PostgreSQL database? They're stored in pg_hba.conf.
#6

[eluser]mariek[/eluser]
Hi,
Have you enable pgsql in xampp ? I don't use it, I user wamp instead and postgres is not enabled by default. Try to locate extension=php_pdo_pgsql.dll and extension=php_pgsql.dll in the php.ini.
If you have "unable to load librairy" error, it means you don't have the dll installed.




Theme © iAndrew 2016 - Forum software by © MyBB