Connection Errors and Internal Server Errors.

[just_some_guy]

Hey,

I have been using coppermine for about 3 months now and every thing has been going smoothly. But reacently i have noticed that i get the odd Internal Server Error. I just need to wait about 10 secs and refresh the page. And sometimes i get a "mysql connection error cannot locate host ****.*******.net"

Can you see anything wrong, or resource intensive?

The site is www.mysimtractor.com

login:

username - test
password - test123

Thanks!

[Joachim Müller]

There are way too many details on your index page, both in terms of resources as well as in terms of confusion for the visitor. I suggest turning off "Show first level album thumbnails in categories".

And sometimes i get a "mysql connection error cannot locate host ****.*******.net"

Ask your webhost for support on this issue.

[just_some_guy]

Okay thanks very much, i will do that.

[just_some_guy]

Hmm the problem is still occuring... Can you see a problem?

Thanks,

[Nibbler]

What did your webhost say?

[just_some_guy]

This is a quote from the hosts website:

External/Third party software
Unfortunately we do not allow external server software/applications to be installed onto our shared servers.

This is due to both security and performance issues. Web based applications can be installed such as phpBB, Joomla,oscommerce etc, but unfortunately our support team are unable to provide support for the installation or maintenance of these applications.

They cannot help with maintenance with problems realting to third-pary web based software. I was hoping you guys could help me.

Thanks!

[Joachim Müller]

If they don't allow third party software on their servers at all, you should look for a new webhost. But my guess is that they refer to something else in this case: they won't allow you to install stuff on webserver-level (e.g. something like ImageMagick), but they probably allow you to run pre-made scripts on your webspace (because that's what coppermine actually is). Of course they will not support you with setup problems caused by coppermine, that is understandable. However, the mysql error message you see just shines through in coppermine: it's actually an error message that your webhost is responsible for: coppermine just calls the address of the mysql server you set up in coppermine's config. If the webserver is unable to resolve the address of the mysql database, the result will be an error message similar to the one you got. Bottom line: this is something that your webhost has to take care off. If they are reluctant to do so, refer to this thread. It's something in their webserver setup if the lookup for the database fails. So don't just look at some FAQ pages of your webhost, but file a support ticket. It's vital that you stress that you're not asking them to fix coppermine issues for you, but that they need to look into things that are directly related to their webserver setup.

[just_some_guy]

Ok, thanks for making it more clear, i have subbmited a support ticket and will get a responce within 24hrs.

[just_some_guy]

They would like to see the file(s) that cause the errors and the links to the error messages.

What would the files be?, i think it happens when viewing the index page and maybe images.

Where can i find the error message coppermine outputs when it cant connect?

Thanks,

[Joachim Müller]

The mysql access data are being stored in include/config.inc.php. The actual queries are being run in include/init.inc.php and include/functions.inc.php
If queries fail, Coppermine just echoes the message it got from mysql. Subsequently, if coppermine displays

mysql connection error cannot locate host ****.*******.net

, this error message actually comes from mysql and just shines through coppermine. Tell your webhost to review this thread - they should get all information they need.

[just_some_guy]

I sent them a reply showing them which files to look at, and i also mentioned they should view this thread.

[just_some_guy]

I got a reply from my host and they said they were not aware of a problem with my server and they will monitor the situation.

Thanks for the help GauGau,

[just_some_guy]

I caught it in action, when i was editing a pictures file information and selected save this happened: see attached picture.

Coppermine critical error:
Unable to connect to database !

MySQL said: Unknown MySQL server host 'mysql11.streamline.net' (2)

[Joachim Müller]

As suggested: report the error message to your webhost.

[just_some_guy]

Just got a "Critical error - error whilst proccessing a database query", on a similar screen to the above image. Will this be realted to the problem? what is that error in mysql, when it does not shine-through cpg?

[Nibbler]

http://coppermine-gallery.net/tutorial/debug_mode.php

[just_some_guy]

The host would like to know the "mysql setting" what is the setting for cpg?

Thanks,

[Nibbler]

The phrase "mysql setting" is meaningless.

[just_some_guy]

This is what the host said: "Can you please confirm the mysql setting so we can test this for you."

do you want to see the debug?

[just_some_guy]

The host said that they have tested the access to the database and have found no issues. So its not a problem with the database or the webserver...strange...