Hi,
I'm kinda new to the toolserver, I'm currently experimenting with the environment before I begin to write some code, and I have a problem with the database connection.
I readhttps://wiki.toolserver.org/view/Database_access from top to bottom, then tried a few queries from the wiki, only to get the following error:
ERROR 1045 (28000): Access denied for user 'strainu'@'damiana-bge0.esi.toolserver.org' (using password: YES)
I then tried to run the script from https://wiki.toolserver.org/view/Iterating_over_wikis
The output is as follows:
strainu@willow:~$ bash test.bash &> test.out strainu@willow:~$ cat test.out | wc -l 1492 strainu@willow:~$ cat test.out | grep ERROR | wc -l 726
So it would appear I can access only 1492 - 2*726 = 40 tables out of 746. I haven't touched .my.cnf in any way, so I'm guessing the password is correct.
Does anybody have any ideas/suggestions on what's going on?
Thanks, Strainu
Hello, At Friday 09 December 2011 22:08:41 DaB. wrote:
I'm kinda new to the toolserver, I'm currently experimenting with the environment before I begin to write some code, and I have a problem with the database connection.
the problem was on our side, you missed some grants in some database-servers. I fixed that now.
Sincerly, DaB.
----- Original Message -----
From: DaB. WP@daniel.baur4.info
the problem was on our side, you missed some grants in some database-servers. I fixed that now.
Thank DaB. It works perfectly now.
Strainu
On 12/09/2011 09:33 PM, Andrei Cipu wrote:
So it would appear I can access only 1492 - 2*726 = 40 tables out of 746. I haven't touched .my.cnf in any way, so I'm guessing the password is correct.
This might be related to a DNS problem with *.rrdb.toolserver.org, that I tried to report the other week, https://jira.toolserver.org/browse/TS-1233
The bug report now says "answered", but this still fails: $ mysql -h arwiki_p.rrdb arwiki_p ERROR 1049 (42000): Unknown database 'arwiki_p'
Try instead this connection command: mysql -h sql-s${srv}-rr where $srv is 1 for the s1 cluster (enwiki), ... up to 7
What might happen is that you try to connect to xyzwiki.rrdb.toolserver.org, which resides on s7, but that DNS name points to s4 instead, so when MySQL connects it doesn't find the database there.
Hello, At Saturday 10 December 2011 18:05:26 DaB. wrote:
https://jira.toolserver.org/browse/TS-1233
The bug report now says "answered", but this still fails: $ mysql -h arwiki_p.rrdb arwiki_p
that's because it is
mysql -h arwiki-p.rrdb arwiki_p
(like my answer in the bug-report already told you), There is no "_" in DNS :-).
And no, the problems of you both were not related.
Sincerly, DaB.
toolserver-l@lists.wikimedia.org