Help talk:Toolforge/Archives/2020
Appearance
Latest comment: 4 years ago by ShohagS in topic Help on databse
![]() |
Please do not post any new comments on this page. This is a discussion archive See current discussion or the archives index. |
Lists are offline
Dear all, I was an avid user of wmflabs lists, especially the one regarding itwiki. Since 3 days they stopped working. Does anybody know who is in charge for them? Is this wikimedia website the right place to ask? Thanks in advance. --Luckyz (talk) 13:11, 31 January 2020 (UTC)
- Luckyz, I would suggest that you try to report this problem to the "list" tool's maintainers: Alessio, Fale, Incola, and Mess. --BryanDavis (talk) 16:48, 31 January 2020 (UTC)
Help on databse
@BryanDavis: Hello, BryanDavis! I found you in the previous topic. I am interested in running bots from toolforge. I am connected to toolforge by ssh. Whenever I am trying to create a database, It shows an error that I don't have permissions. I need to use database to run my bot perfectly. Please, help me a bit. regards, --ShohagS (talk) 04:31, 14 October 2020 (UTC)
- @ShohagS: have you read Help:Toolforge/Database#User databases? Your question does not have enough context for me provide more help than that link. --BryanDavis (talk) 19:45, 14 October 2020 (UTC)
- @BryanDavis: Thanks a lot. But It still giving me an error after connection to the
tools.db.svc.eqiad.wmflabs
usingmysql --defaults-file=$HOME/replica.my.cnf -h tools.db.svc.eqiad.wmflabs
command. The error was like thisERROR 1044 (42000): Access denied for user 's54497'@'%' to database 's54497_SBB'
. Can you provide more help or does my account need permission? --ShohagS (talk) 03:23, 15 October 2020 (UTC)- @ShohagS: I am not seeing any databases owned by your suggestbotbn tool: toolforge:tool-db-usage/owner/s54497. The database name you supplied above (s54497_SBB) also does not meet the requirement of having two
_
characters after your tool's credential user name. See Help:Toolforge/Database#Steps_to_create_a_user_database_on_tools.db.svc.eqiad.wmflabs for a detailed explanation of the requirements and process of creating a new database. --BryanDavis (talk) 15:23, 15 October 2020 (UTC)- @BryanDavis: I forgot to thank you while I was a bit busy. But just remembered you while I am stuck again. Apologies for that. I am truly sorry. I am using that database in web here but whenever I am trying to use that database through jsub It shows error
pymysql.err.InternalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
. Not when I run the python3 script (to update the database) manually. It works nicely then. Why is that? Please let me know. ShohagS (talk) 14:57, 26 October 2020 (UTC)
- @BryanDavis: I forgot to thank you while I was a bit busy. But just remembered you while I am stuck again. Apologies for that. I am truly sorry. I am using that database in web here but whenever I am trying to use that database through jsub It shows error
- @ShohagS: I am not seeing any databases owned by your suggestbotbn tool: toolforge:tool-db-usage/owner/s54497. The database name you supplied above (s54497_SBB) also does not meet the requirement of having two
- @BryanDavis: Thanks a lot. But It still giving me an error after connection to the