localhost db hostname for codeigniter app

Question

I am a rails developer working with a client who absolutely demands that I fix their old codeigniter site, then port it into rails (don't ask why, that's a whole different question). Anyway, they seem to have two databases listed in their database.php file, one points to a MySQL DB that I can access via godaddy, no prob. The other, which is the one that has all of the functionality(reading, writing editing etc) has a localhost hostname. There is no record of the tables or db names of this second db in their godaddy account and they have no way to contact the developer that wrote this app or any documentation. And coincidentally that is the DB that I need to modify, as well as port over to the new rails app. Am I just totally missing something obvious here?

$active_group = "default";
$active_record = TRUE;
$db['default']['hostname'] = "hostedresource.com";
$db['default']['username'] = "uname";
$db['default']['password'] = "pword"; 
$db['default']['database'] = "database";
$db['default']['dbdriver'] = "mysqli";
$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'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

// Admin group (for adding and deleting articles)
$db['admin']['hostname'] = "localhost";
$db['admin']['username'] = "username";
$db['admin']['password'] = "password";
$db['admin']['database'] = "other_database";
$db['admin']['dbdriver'] = "mysql";
$db['admin']['dbprefix'] = "";
$db['admin']['active_r'] = TRUE;
$db['admin']['pconnect'] = TRUE;
$db['admin']['db_debug'] = TRUE;
$db['admin']['cache_on'] = FALSE;
$db['admin']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

and heres the mysql_connect call in one of the task files

$conn = mysql_connect("localhost", "username", "password"); mysql_select_db("other_database");

posting the database.php would be helpful

jmadsen
– jmadsen

2013-07-11 22:02:10 +00:00
Commented Jul 11, 2013 at 22:02 — jmadsen
– jmadsen, Commented Jul 11, 2013 at 22:02
can you see that db ?? !!!

zod
– zod

2013-07-11 22:07:22 +00:00
Commented Jul 11, 2013 at 22:07 — zod
– zod, Commented Jul 11, 2013 at 22:07
Posted, and yes I can. That's whats confusing me

mrtriangle
– mrtriangle

2013-07-11 22:08:26 +00:00
Commented Jul 11, 2013 at 22:08 — mrtriangle
– mrtriangle, Commented Jul 11, 2013 at 22:08

Dani · Accepted Answer · 2013-07-11 22:35:42Z

2

is godaddy hosting the site? I'm going to guess not, because I know godaddy keeps all web and mysql hosting separate.

I've had a simliar situation where I was accessing an old go-daddy sql db, but also using a new one (which was local to the VM i was using from hostgator) basically the same code as you have above(except I used the new mysqli Extension like you are supposed to)

localhost in this instance means that the DB is on the same machine running the PHP. So The localhost db should be located on the machine your web-server is running off of If you have SSH access to your server, you should be able to run mysql from the shell and get the info you need.

you can also just try yoururl/phpmyadmin ... a lot of servers come with it preinstalled...

now, I just hope you have the credentials :-p

=======

now that you are getting

#2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 110

typically this means your local ip (your computer) isn't on the access control list for PHPmyadmin.

If your host has a control panel, you should be able to add your ip address to the Allowable Hosts section in the phpmyadmin settings (most control panels like cpanel have this).

try yoururl/cpanel or yoururl:2083 maybe we will get lucky

if not you need to find the phpmyadmin ini file, on my server it is located at /etc/httpd/conf.d/phpMyAdmin.conf but that's going to depend on your set up.

in the ini file

#obviously the path is dependent on your setup

<Directory "/usr/share/phpMyAdmin"> 
Options FollowSymLinks
AllowOverride None
Order allow,deny
#put your ip address here
Allow from 111.111.111.111
</Directory>

edited Jul 11, 2013 at 22:35

answered Jul 11, 2013 at 22:11

Dani

1,2507 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mrtriangle Over a year ago

I went for your suggestion, got somewhere, then got this gem: #2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 110

Dani Over a year ago

this is good! I'm guessing you were able to get to phpmyadmin...almost updating my answer now :)

Collectives™ on Stack Overflow

localhost db hostname for codeigniter app

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related