Cannot autoload database

[eluser]mistere[/eluser]
INITIAL CONFIGURATION:

System: Ubuntu 8.10
Installed CI 1.7.1 in /var/www/alpha
Installed Postgres 8.3.6
Postgres user account and database set up
Postgres accessible from command line (can log in, create tables, etc.)
Postgres accessible from network: localhost port 5432 using pgAdmin
In alpha/index.php (line 12): error_reporting(E_ALL);

RESULT:

Default CI page shows up at http://localhost/alpha/

SO FAR, SO GOOD.

CHANGE:

Add 'database' to the autoload.php file as follows:
$autoload['libraries'] = array('database');
Configure database parameters in database.php as follows:
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "worker";
$db['default']['password'] = "password";
$db['default']['database'] = "workreport";
$db['default']['dbdriver'] = "postgre";
(these parameters work from the command line)

RESULT:
No page displays - there is nothing received by the browser
No errors appear in alpha/system/application/logs
No errors appear in /var/log/apache2/error.log

What am I missing here?
Thanks,
Eric

[eluser]pistolPete[/eluser]
I think you have to configure the port as well:

From the User Guide:

port - The database port number. Currently only used with the Postgres driver. To use this value you have to add a line to the database config array.

Code:

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

[eluser]mistere[/eluser]
Great catch.

I added the port line to database.php - but there is no difference:
If I remove database from the autoload.php file the site works.
If I add database to the autoload.php file no pages render.

I got the logs to work (directory permissions problem)
and here is what I see:

DEBUG - 2009-03-03 10:44:49 --> Config Class Initialized
DEBUG - 2009-03-03 10:44:49 --> Hooks Class Initialized
DEBUG - 2009-03-03 10:44:49 --> URI Class Initialized
DEBUG - 2009-03-03 10:44:49 --> No URI present. Default controller set.
DEBUG - 2009-03-03 10:44:49 --> Router Class Initialized
DEBUG - 2009-03-03 10:44:49 --> Output Class Initialized
DEBUG - 2009-03-03 10:44:49 --> Input Class Initialized
DEBUG - 2009-03-03 10:44:49 --> Global POST and COOKIE data sanitized
DEBUG - 2009-03-03 10:44:49 --> Language Class Initialized
DEBUG - 2009-03-03 10:44:50 --> Loader Class Initialized
DEBUG - 2009-03-03 10:44:50 --> Database Driver Class Initialized
(END)

This is with log_threshold set to 4.

Any way I can get more detail?

Thanks,
Eric

[eluser]mistere[/eluser]
I switched to mysql 5.0 and the default CI page displays now.

I really like Postgresql better so I'll have to keep trying that. I have several web apps running with Code Igniter 1.6.x and Postgresql 8.2.x. Something changed :-(

[eluser]xwero[/eluser]
do a diff to see what changed in the database/drivers/postgre files. It would be great if you catch the bug.

[eluser]mistere[/eluser]
I'll do that when I get a chance! I'm under a deadline this week :-)

Thanks

[eluser]kmil0[/eluser]
Hi guys, I have the same problem but with CI 1.6.2,
The same machine (Ubuntu 8.10)
but the problem persist with Mysql 5.0 :S

not logs, not info, nothing :S
just a blank page only when I autoload the database library

in the CI log.

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

DEBUG - 2009-03-11 00:06:41 --> Config Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Hooks Class Initialized
DEBUG - 2009-03-11 00:06:41 --> URI Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Router Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Output Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Input Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Global POST and COOKIE data sanitized
DEBUG - 2009-03-11 00:06:41 --> Language Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Loader Class Initialized
DEBUG - 2009-03-11 00:06:41 --> Helpers loaded: url, form, text
DEBUG - 2009-03-11 00:06:41 --> Database Driver Class Initialized

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

an in the apache log

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

127.0.0.1 - - [11/Mar/2009:00:07:51 -0500] "GET / HTTP/1.1" 200 20 "-" "Mozilla/5.0 (X11; U; Linux i686; es-AR; rv:1.9.0.7) Gecko/2009030422 Ubuntu/8.10 (intrepid) Firefox/3.0.7"
===============================


in the Mysql Log (with log = /var/log/mysql/mysql.log )

theres no error no nothing..



in Ubuntu 8.04 works fine. but.. not now :S

any tip?
thanks guys

[eluser]Unknown[/eluser]
The same happened to me with mysql, after a clean php install.

Make sure you have the extension loaded in php (php_pgsql.dll / php_pdo_pqsql.dll)


edit:
Sorry, forgot its on Ubuntu

try something like

Code:

sudo apt-get install php5-pgsql

[eluser]jedd[/eluser]
I really love what Ubuntu's done with my Debian ... {wistfully}

First step - crank up a phpinfo () page to confirm that you're loading all the bits you need to in PHP. Incredibly useful feature, phpinfo ...

Second, please confirm that you can authenticate using the user & pass and db name, using mysql at the CLI, as you have in the configuration file. Do it from the same host - not somewhere else - as MySQL has an ACL that can limit based on where you're coming from. Check the mysql database, specifically the user table, for more insight on the details.

Third, your apache log looks like you're hitting the web root - is that right? Do you have some funky rewrites in /etc/apache/... or in the local htaccess ..? By my understanding, the apache log should be showing /alpha as part of the URL it is trying to respond to / provide.

Fourth, we're assuming you've covered the easy stuff, eg. config/database.php changed:

Code:

$db['default']['dbdriver'] = "mysql";

[eluser]kmil0[/eluser]
Hi guys.
thanks
you have save my day

seem that the problem was with de Mysql CLI authentication.
Ubuntu does not install php5-mysql by default.

thanks again for your support