Jump to content
  • 0
javierreg

system error 113 can not connet database misql

Question

well , the last week the shop go down 1 day

today have this error and cant make nothing in my shop

 

link to database not work

 

some people.know what is the problem?

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
seems like it is some host settings problem,
most sources say that this problem is strictly related to settings.

The 113 error shows "no route to host" error. you must configure your ip address on both machines.
of course,it must be routable.else, it wont work.

 

 

this means that your db probably is not accessible from "external" machines because of db privileges. This can be a part of "security" policy on your host.

please make sure that your database user can be connected to db from ip address where the shop is hosted (www and mysql can be on separated, different hosts)

Share this post


Link to post
Share on other sites
  • 0

I have had the same thing happen on my store during the weekend, most likely on Sunday. No changes where made during the weekend.

Link to database cannot be established: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 113

Strange thing is I posted a support ticket as soon as i was told it was down, and in about an hour the store was working again..... however....

 

Now i only have 95 products on the store rather than close to 700 that i should have.... seems that an old backup was restored... don't know why an old backup would have been used when i have one dated 11th August (last Thursday).

 

So at that point i posted another support ticket, asking to have the most recent backup restored..... haven't heard anything from the Prestashop support team.

 

At the moment my store is in maintenance mode, and can't be used.... looks like i now have to start all over again, 5 months of work down the drain!!!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More