[resolved] Too many simultaneous requests?

qwaq

Joined: 2009-11-11
Posts: 14
Posted: Wed, 2009-11-11 15:07

Hi,

Quite new to these website maintenance stuff... please apologize if this question is awkward..

I set up a Gallery2 site. I have an error message when attempting to access the website.
Discussions with the french hebergeur (OVH) lead to the conclusion that my site has too many simultaneous requests.

Basically, I don't know what these requests are, and neither what to change and how to change it to correct this.
Without access to my site, I do not have access to the administrative section. Only have access via FileZilla.

Thanks for your help :)
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-11-11 16:13

Without seeing the entire error message, I'm betting this is coming from the database and you're host has heavily restricted limits on system and database resources (most likely so they can get the most bang for their buck and really over sell their services)

You can try editing your config.php file and setting the usePersistentConnections setting to false if it's not already:
$storeConfig['usePersistentConnections'] = false;

Do you have any idea how many people are visiting your site?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Wed, 2009-11-11 17:36

Well,

Thanks for the reply...
There is no "entire error message": entering the www.patati.patata.fr subdomain address in a browser address bar is followed by a long long long loading time which finally ends with a blank page with "Error" written on :)

Regarding the question of my website traffic: I would say very few to few people. It's a gallery for friends and family to see my daughter growing from kneeling to walking on her feet :)

I've checked the config.php line you mentioned: unfortunately, it already is set to False.

Would you have any other idea - beside arguing with my host...?

Many thanks!
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-11-11 17:52

Did you typo your site address? I can't access it, period. Unknown host.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Mon, 2009-11-16 20:42

www.
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-11-11 19:24

o.k. Put Gallery into buffered debug mode and post back when you've done that.

FAQ: How to set/use Gallery in debug mode?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Wed, 2009-11-11 19:57

done.

ouptut text is quite long.

starts with:

Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage.class at line 263 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 588 (mysqlstorage::_getconnection)
* in modules/core/classes/GalleryCoreApi.class at line 2912 (mysqlstorage::getmapentry)
* in modules/core/classes/GallerySession.class at line 872 (gallerycoreapi::getmapentry)
* in modules/core/classes/GallerySession.class at line 231 (gallerysession::_loadsessiondata)
* in modules/core/classes/Gallery.class at line 287 (gallerysession::init)
* in init.inc at line 124 (gallery::initsession)
* in main.php at line 81
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Mon, 2009-11-16 20:41

do you have access to the full output file?

error output [/output.txt[/url]
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-11-11 20:24

Ah, here we go:

Quote:
mysql error: [1045: Access denied for user '539787-2'@'10.0.75.116' (using
password: YES)] in CONNECT(sql3.modules, ?, ?, 539787-2)

In config.php, double check your database connection settings:
username
password
hostname
database name

Something isn't right with at least one of those.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Wed, 2009-11-11 20:32

ok.
I've checked these lines.
The thing is, I have absolutely no idea what these are.
I mean, this is what I got:

$storeConfig['hostname'] = 'sql3.modules';
$storeConfig['database'] = '539787-2';
$storeConfig['username'] = '539787-2';
$storeConfig['password'] = 'xxxxxxxxx';

and... I just don't know: never heard of these things...

Let me guess: the best I can do is ask my sql connection settings to my host, change the config.php file with these, and hope it'll work?
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-11-11 20:37

I'd ask your host to verify that those settings are correct. I'm suspecting that sql3.modules is not a valid hostname (computer name), but I don't know how your host has things setup.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Wed, 2009-11-11 20:47

ok; so I'll go ask my host.
I'll go back to this topic as soon as I have their answer - few days I guess...

Anyway, thank you for your help!

be back as soon as I can :)
 
qwaq

Joined: 2009-11-11
Posts: 14
Posted: Mon, 2009-11-16 20:40

Hi,

I've ask a friend of mine to try to see what he could do. Well, I don't know what he did, but he did it good: my gallery is back.

Still, I'll have to figure out where this mess comes from...

Anyway, great thanks for your help, and for the time you spent on this :)