+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Need error logging 101 (/showthread.php?tid=32379)
Need error logging 101 - El Forum - 07-21-2010
[eluser]jmanpa[/eluser]
I'm new to CI and am trying to troubleshoot a DB connection problem but I can't determine if there is more information being captured on the error than the unhelpful message from ci in the browser:
"A Database Error Occurred
Unable to connect to your database server using the provided settings."
I checked the Apache log and nothing
I read up on the CI error handling but I don't see reference to which log file it writes to - Apache or some file in the logs directory. The ci logs directory is empty except for index.html.
Where is the ci logging going or why do I seem to not be getting any? My threshold is set thusly:
$config['log_threshold'] = 3;
Need error logging 101 - El Forum - 07-21-2010
[eluser]pickupman[/eluser]
You probably won't find what your are looking for with your error logging level. What type of DB are you trying to connect to?
Need error logging 101 - El Forum - 07-23-2010
[eluser]jmanpa[/eluser]
MySQL DB. I'm on Amazon EC2 but trying to connect to DB on Hostgator server. I wouldn't be surprised if it is a port/permissions thing but I need some decent logging to help me figure it out.
Need error logging 101 - El Forum - 07-23-2010
[eluser]pickupman[/eluser]
Hostgator runs mysql under localhost. You will to login to HG cpanel, go to Remote MySQL, and add your host/ip to the list. By default 192.168.1.% is only thing enabled. You might also by to use sql tunneling if that doesn't work.
Need error logging 101 - El Forum - 07-23-2010
[eluser]jmanpa[/eluser]
I fixed it. I had added two IPs to Hostgator but neither of them were correct.
However, to troubleshoot it I had to do native PHP mysql connection code so as to get the real error message. I would think a framework like CI should be able to present the error to me, somehow.