Problem with database connection - Cannot make MySQL server connection.

[eluser]FuriKuri[/eluser]
Hi all.

I have been developing an app into a localhost server (xampp lite version, for more details) and everything was fine, but once i decided to move into a subfolder of a OVH hosting i started having problems with the database connetion.

My default_controller (login) can connect to the mySQL and querys go well, but the problem start when this controller redirects to the next page, at this point all the controllers cannot connect to the mysql database, and if they try to do that the next error appears:

Error!
Cannot make MySQL server connection.

I'm a noob with Codeignitor, so plz be patient with me. If u need more information plz ask.

PS: Sorry for my english.

[eluser]Jamongkad[/eluser]
Hi Furikuri,

If you check the config folder in your CodeIgniter directory there is a file called "database.php". It looks like this...

Code:

/*
| -------------------------------------------------------------------
| DATABASE CONNECTIVITY SETTINGS
| -------------------------------------------------------------------
| This file will contain the settings needed to access your database.
|
| For complete instructions please consult the "Database Connection"
| page of the User Guide.
|
| -------------------------------------------------------------------
| EXPLANATION OF VARIABLES
| -------------------------------------------------------------------
|
|    ['hostname'] The hostname of your database server.
|    ['username'] The username used to connect to the database
|    ['password'] The password used to connect to the database
|    ['database'] The name of the database you want to connect to
|    ['dbdriver'] The database type. ie: mysql.  Currently supported:
                 mysql, mysqli, postgre, odbc, mssql
|    ['dbprefix'] You can add an optional prefix, which will be added
|                 to the table name when using the  Active Record class
|    ['pconnect'] TRUE/FALSE - Whether to use a persistent connection
|    ['db_debug'] TRUE/FALSE - Whether database errors should be displayed.
|    ['active_r'] TRUE/FALSE - Whether to load the active record class
|    ['cache_on'] TRUE/FALSE - Enables/disables query caching
|    ['cachedir'] The path to the folder where cache files should be stored
|
| The $active_group variable lets you choose which connection group to
| make active.  By default there is only one group (the "default" group).
|
*/

$active_group = "default";

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "";
$db['default']['password'] = "";
$db['default']['database'] = "";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";

Here you can set the database. The comments are pretty self explanatory...

[eluser]FuriKuri[/eluser]
[quote author="Jamongkad" date="1186597946"]Hi Furikuri,

If you check the config folder in your CodeIgniter directory there is a file called "database.php". It looks like this...
Here you can set the database. The comments are pretty self explanatory...[/quote]

Heres mine:

Code:

<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');
/*
| -------------------------------------------------------------------
| DATABASE CONNECTIVITY SETTINGS
| -------------------------------------------------------------------
| This file will contain the settings needed to access your database.
|
| For complete instructions please consult the "Database Connection"
| page of the User Guide.
|
| -------------------------------------------------------------------
| EXPLANATION OF VARIABLES
| -------------------------------------------------------------------
|
|    ['hostname'] The hostname of your database server.
|    ['username'] The username used to connect to the database
|    ['password'] The password used to connect to the database
|    ['database'] The name of the database you want to connect to
|    ['dbdriver'] The database type. ie: mysql.  Currently supported:
                 mysql, mysqli, postgre, odbc, mssql
|    ['dbprefix'] You can add an optional prefix, which will be added
|                 to the table name when using the  Active Record class
|    ['pconnect'] TRUE/FALSE - Whether to use a persistent connection
|    ['db_debug'] TRUE/FALSE - Whether database errors should be displayed.
|    ['active_r'] TRUE/FALSE - Whether to load the active record class
|    ['cache_on'] TRUE/FALSE - Enables/disables query caching
|    ['cachedir'] The path to the folder where cache files should be stored
|
| The $active_group variable lets you choose which connection group to
| make active.  By default there is only one group (the "default" group).
|
*/

$active_group = "default";

$db['default']['hostname'] = "mysql5-12";
$db['default']['username'] = "animesaifuri";
$db['default']['password'] = "***************";
$db['default']['database'] = "animesaifuri";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";


?>

The database is already set, in fact when i access the first controller (login) it can connect to the database and querys work well, but after that, when its redirect to the next page i got this error.

Error!
Cannot make MySQL server connection.

When i access the same web at localhost i can connect and interact with my mysql database without any problem, so i figure theres any difference between the localhost server (xampp) and the remote host.

Any idea?

[eluser]FuriKuri[/eluser]
Also if i have not configured my database i would obtain the next error:


An Error Was Encountered

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


Insted of:

Error!
Cannot make MySQL server connection.

[eluser]FuriKuri[/eluser]
Plz at least guide me to the solution. What should i watch?

[eluser]Jamongkad[/eluser]
[quote author="FuriKuri" date="1186626789"]Plz at least guide me to the solution. What should i watch?[/quote]

If you look into your Autoload.php file do you have the database on autoload?

[eluser]FuriKuri[/eluser]
[quote author="Jamongkad" date="1186662949"][quote author="FuriKuri" date="1186626789"]Plz at least guide me to the solution. What should i watch?[/quote]

If you look into your Autoload.php file do you have the database on autoload?[/quote]

Yes. Its there, and i can connect once to the database, after that the conexión seems broken.

My default_controller (login) can connect to the mySQL and querys go well, but the problem start when this controller redirects to the next page, at this point all the controllers cannot connect to the mysql database, and if they try to do that the next error appears:

[eluser]Jamongkad[/eluser]
That is strange friend, I've never had that problem when I was developing in XAMPP. If you can why don't you download WAMP and try your App there?

[eluser]FuriKuri[/eluser]
[quote author="Jamongkad" date="1186664540"]That is strange friend, I've never had that problem when I was developing in XAMPP. If you can why don't you download WAMP and try your App there?[/quote]

I have no problem developing with xampp, i use it in my local computer, and works fine. The problem appears when i upload the entire web to my hosting.

[eluser]Jamongkad[/eluser]
[quote author="FuriKuri" date="1186664961"][quote author="Jamongkad" date="1186664540"]That is strange friend, I've never had that problem when I was developing in XAMPP. If you can why don't you download WAMP and try your App there?[/quote]

I have no problem developing with xampp, i use it in my local computer, and works fine. The problem appears when i upload the entire web to my hosting.[/quote]

Did try asking your hosting company for any details about this matter? probably some incompatibility with mysql(Although highly unlikely). Let's wait for other people to pitch in on your problem.