LemonStand Forum: Error Connecting to Database - LemonStand Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Error Connecting to Database

#1 User is offline   gabecouch 

  • Member
  • Group: Members
  • Posts: 9
  • Joined: 08-July 10

Posted 08 September 2010 - 05:47 AM

Every time I open the site for the first time in the day. It gives me the error in the image. Any thoughts on what would cause this ?
0

#2 User is online   Aleksey 

  • Co-Founder
  • Group: +Administrators
  • Posts: 3,633
  • Joined: 31-October 09

Posted 08 September 2010 - 01:58 PM

Hi!

Is your LemonStand copy hosted on a Mac Os Server machine? It looks like the MySQL persistent connection issue. You can try fixing it by adding the following line to the config/config.php file:

$CONFIG['MYSQL_PERSISTENT'] = false;


Thank you

#3 User is offline   gabecouch 

  • Member
  • Group: Members
  • Posts: 9
  • Joined: 08-July 10

Posted 09 September 2010 - 06:48 AM

Thank you. Will try it out and see. Its actually on a windows machine running apache. Would this still possibly resolve this issue ?
0

#4 User is online   Aleksey 

  • Co-Founder
  • Group: +Administrators
  • Posts: 3,633
  • Joined: 31-October 09

Posted 09 September 2010 - 03:30 PM

Please try the solution. It is not Mac OS Server specific, of course. It is specific to the MySQL configuration. But we have noticed this behavior only on Mac OS Server machines before.

Thanks

#5 User is offline   Beats 

  • Member
  • PipPipPip
  • Group: Members
  • Posts: 193
  • Joined: 18-January 11

Posted 21 December 2011 - 08:26 AM

Sorry, I am having this problem now.

I changed the cPanel UN and PW and once I've done this I am getting this error. I am assuming this is because of the changed PW. Does anyone have any recommendations?

Thanks!
0

#6 User is offline   Eric 

  • Developer
  • PipPipPip
  • Group: Members
  • Posts: 1,290
  • Joined: 04-August 10
  • LocationVancouver, Canada

Posted 21 December 2011 - 09:54 AM

View PostBeats, on 21 December 2011 - 08:26 AM, said:

Sorry, I am having this problem now.

I changed the cPanel UN and PW and once I've done this I am getting this error. I am assuming this is because of the changed PW. Does anyone have any recommendations?

Thanks!


That shouldn't happen unless you were using your root cPanel info as your MySQL info, and they are linked (not sure). You should log into cPanel, create a new MySQL user, add permission to your LS database, and use the Config Tool to change your username/password. http://lemonstandapp...iguration_tool/
0

#7 User is offline   Beats 

  • Member
  • PipPipPip
  • Group: Members
  • Posts: 193
  • Joined: 18-January 11

Posted 21 December 2011 - 10:27 PM

That was it. Thanks.

I changed the UN and PW for the cPanels and it auto-changed the MySQL info.

So I had to login to the config_tool backend and change the UN, PW, and DB to the new updated info.

Thanks Eric!
0

Share this topic:


Page 1 of 1

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users