Euku created this task. Euku added projects: Pywikibot, DBA, Tools. Restricted Application added subscribers: pywikibot-bugs-list, Aklapper.
TASK DESCRIPTION The tool/project under https://pb.toolforge.org/ offers a file base API to my bot (tool name: spbot). That means the bot imports /data/project/pb/pb/pyapi/wppb.py to its main script (/data/project/spbot/bot/scripts/userscripts/pers-bek-to-db-bot.py) in order to make changes to the database. But it can't anymore since June 6th. When the bot tries to add data it gets an error in return: //The MariaDB server is running with the --read-only option so it cannot execute this statement// The bot uses `db_name = "s51344__pb"` with `host='tools-db'` and `user='s51344'` But when I try to change something in the command line it works: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 218259186 Server version: 10.1.39-MariaDB MariaDB Server ... MariaDB [s51344__pb]> select * FROM user where user_name ='Euku'; +---------+-----------+--------------+-------------------------+---------------------+---------------------+----------------+-----------------+ | user_id | user_name | user_comment | user_participates_since | user_verified_since | user_last_update | user_is_hidden | user_was_banned | +---------+-----------+--------------+-------------------------+---------------------+---------------------+----------------+-----------------+ | 108107 | Euku | NULL | 2008-03-18 00:00:00 | 2008-03-28 09:21:00 | 2009-10-03 17:20:00 | 0 | 0 | +---------+-----------+--------------+-------------------------+---------------------+---------------------+----------------+-----------------+ 1 row in set (0.001 sec) MariaDB [s51344__pb]> update user set user_comment = '' where user_name = 'Euku'; Query OK, 1 row affected (0.003 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [s51344__pb]> update user set user_comment = NULL where user_name = 'Euku'; Query OK, 1 row affected (0.005 sec) Rows matched: 1 Changed: 1 Warnings: 0 ... connected with `mysql --defaults-file=~/replica.pb-db.cnf -h tools-db s51344__pb` cat replica.pb-db.cnf [client] user='s51344' password='xxx' host='dewiki.labsdb' Can some please support me? TASK DETAIL https://phabricator.wikimedia.org/T311373 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Euku Cc: Aklapper, pywikibot-bugs-list, Euku, Devnull, LSobanski, Jyoo1011, JohnsonLee01, SHEKH, Dijkstra, Khutuck, Nintendofan885, Zkhalido, Iflorez, Viztor, Wenyi, skpuneethumar, Zylc, 1978Gage2001, Operator873, Bsandipan, DSquirrelGM, Jayprakash12345, Chicocvenancio, Tbscho, MayS, Marostegui, Minhnv-2809, Mdupont, JJMC89, Dvorapa, Altostratus, Avicennasis, mys_721tx, Jitrixis, Xqt, Gryllida, jayvdb, Masti, scfc, Alchimista, Ladsgroup, Mbch331, Jay8g, Krenair
_______________________________________________ pywikibot-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
