Help talk:Toolforge/Archives/2020

Rendered with Parsoid
From Wikitech
Latest comment: 3 years ago by ShohagS in topic Help on databse
Warning! 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)Reply

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)Reply

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)Reply

@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)Reply
@BryanDavis: Thanks a lot. But It still giving me an error after connection to the tools.db.svc.eqiad.wmflabs using mysql --defaults-file=$HOME/replica.my.cnf -h tools.db.svc.eqiad.wmflabs command. The error was like this ERROR 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)Reply
@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)Reply
@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)Reply