Hi all,
I have a script here:
http://toolserver.org/~dcoetzee/contributionsurveyor/
which accesses a user database u_dcoetzee. Example result page:
http://toolserver.org/~dcoetzee/contributionsurveyor/survey.php?user=Ernesto...
About half the time when loading this page, I receive this error message:
Unknown database 'u_dcoetzee'
Source is here:
http://toolserver.org/~dcoetzee/downloads/contribution_surveyor.tar.gz
This is a new issue and the code has not changed at all, so I suspect some kind of database/server configuration error. In particular, I suspect the requests are being load balanced across two servers, only one of which has correct access to my user database.
Can anyone shed light on what's going on with this? Should I file a bug (if so where)? Thanks.
Hello, At Monday 12 September 2011 23:02:37 DaB. wrote:
About half the time when loading this page, I receive this error message:
Unknown database 'u_dcoetzee'
Source is here:
# Connect to database $toolserver_mycnf = parse_ini_file("/home/".get_current_user()."/.my.cnf"); $db = mysql_connect('enwiki-p.rrdb.toolserver.org', $toolserver_mycnf['user'], $toolserver_mycnf['password']) or die(mysql_error());
As far as I see, here is the problem. You connect to enwiki- p.rrdb.toolserver.org, but that's the round-robin-service for reading, you need enwiki-p.userdb.toolserver.org because you use a user-database later in code (see [1]).
This is a new issue and the code has not changed at all, so I suspect some kind of database/server configuration error
It is this way since we have 2 server for enwiki (many months now). And no, it is not a configuration-error :-).
Sincerly, Dab.
[1] https://wiki.toolserver.org/view/Database_access#By_database_name
It seems to randomly work and not work on refresh. it worked a few times for me then, after refresh, it only shows "Unknown database 'u_dcoetzee'".
Perhaps related to a periodic script screwing up the connection, or one of the webservers being configured differently (load balanced).
-- Krinkle
2011/9/12 Derrick Coetzee dc@moonflare.com
Hi all,
I have a script here:
http://toolserver.org/~dcoetzee/contributionsurveyor/
which accesses a user database u_dcoetzee. Example result page:
http://toolserver.org/~dcoetzee/contributionsurveyor/survey.php?user=Ernesto...
About half the time when loading this page, I receive this error message:
Unknown database 'u_dcoetzee'
Source is here:
http://toolserver.org/~dcoetzee/downloads/contribution_surveyor.tar.gz
This is a new issue and the code has not changed at all, so I suspect some kind of database/server configuration error. In particular, I suspect the requests are being load balanced across two servers, only one of which has correct access to my user database.
Can anyone shed light on what's going on with this? Should I file a bug (if so where)? Thanks.
-- Derrick Coetzee User:Dcoetzee
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
toolserver-l@lists.wikimedia.org