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?