Thread

when I load database library, im getting error…. I really dont know how to solve this problem :down: :down: :down:

here is my error message.. :

A Database Error Occurred

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

Filename: core/Loader.php

Line Number: 242

That means your connection info is wrong in config/database.php

You should double or triple check those settings.

no..im pretty sure that my connection settings are correct… :roll:
it just happend in my web hosting..

I dont have problems like this before in getcloudigniter.com free web hosting

who is your new host?

some hosting companies put prefixes in front of database names. Can you show your database config file? blank out the username and password fields.

here is my database config file :

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

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = '';
$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';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

im using default settings from codeigniter…
this problem really make me confused….

You can not use the default setting!

You need to fill in the others…

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

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'your username';
$db['default']['password'] = 'your password';
$db['default']['database'] = 'your database name';
$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';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

If you do not have a databse then you will need to create one.

InsiteFX

no, I was setting it correctly, and I’ve made a user and database…
but I still getting error like that….  🙄
I think the problem is in my webhosting..
but I don’t know correctly..

Email your hosting support and ask them what your settings should be.

InsiteFX

 
 
For debugging Database connection problems I use this script at the end of my ./config/database.php

...
  ...
  ...
  echo '<pre>';
     print_r($db['default']);
  echo '</pre><p>‘;</p>

<p>  echo ‘Trying to connect to database: ’ .$db[‘default’][‘database’];<br />
  $dbh=mysql_connect<br />
  (<br />
    $db[‘default’][‘hostname’],<br />
    $db[‘default’][‘username’],<br />
    $db[‘default’][‘password’])<br />
    or die(‘Cannot connect to the database because: ’ . mysql_error());<br />
    mysql_select_db ($db[‘default’][‘database’]);</p>

<p>    echo ‘<br />
   Connected OK:’  ;<br />
    die( ‘file: ’ .__FILE__ . ‘—> Line: ’ .__LINE__);

 
 
For debugging Database connection problems I use this script at the end of my ./config/database.php

...
  ...
  ...
  echo '<pre>';
     print_r($db['default']);
  echo '</pre><p>‘;</p>

<p>  echo ‘Trying to connect to database: ’ .$db[‘default’][‘database’];<br />
  $dbh=mysql_connect<br />
  (<br />
    $db[‘default’][‘hostname’],<br />
    $db[‘default’][‘username’],<br />
    $db[‘default’][‘password’])<br />
    or die(‘Cannot connect to the database because: ’ . mysql_error());<br />
    mysql_select_db ($db[‘default’][‘database’]);</p>

<p>    echo ‘<br />
   Connected OK:’  ;<br />
    die( ‘file: ’ .__FILE__ . ‘—> Line: ’ .__LINE__);

</pre>
 
 
 

BRILLIANT! I had the same problem connecting to my db - and it was not my first try with CI… But this one, I simply couldnt figure out why it couldnt connect.

With your debugscript, I noticed that I had mixed up the database name and password, and your script told me that it tried to connect to Database: mypassword.

Really good debug script, thank you very much 😊

great script… :lol:
so the problem is my web hosting… =_=’

Do not forget the bug in MySQL with PHP 5.3

It will not accept localhost for hostname, you have to specify 127.0.0.1

This is a MySQL BUG!

InsiteFX

Do not forget the bug in MySQL with PHP 5.3

It will not accept localhost for hostname, you have to specify 127.0.0.1

This is a MySQL BUG!

InsiteFX

I’ve change this line…

$db['default']['hostname'] = '127.0.0.1';

but, the result is same as before…

Have you asked your Web Hosting what your settings shoud be?

InsiteFX

I’ve asked this problem to the admin..
but he said that he still dont know how to resolve this problem… :roll: :roll: :roll: :roll: