Opened 5 months ago

Closed 5 months ago

#13596 closed Bug/Something is broken (fixed)

red-dump-db-list error on erica

Reported by: https://id.mayfirst.org/jaimev Owned by: https://id.mayfirst.org/jamie
Priority: High Component: Tech
Keywords: mysql, backups Cc: https://id.mayfirst.org/jamie
Sensitive: no

Description

/home/member/*/sites/*/backups directories have not been ceated on erica.

Studying the puppet/modules/mayfirst/manifests/m_backupninja.pp recipe file I see that backupninja is setup to call and external bash script /etc/backup.d/10_mysql.sh to backup mysql databases locally.

That script in turn calls the /usr/local/share/red/node/sbin/red-dump-db-list php script to write a colon separated list of databases,database users, and corresponding site directories to the file /var/lib/red/dbs.txt .

This script is failing on Erica.

-rwxr-xr-x 1 root root 2343 Jan 24 16:07 /usr/local/share/red/node/sbin/red-dump-db-list
0 erica:~# /usr/local/share/red/node/sbin/red-dump-db-list
PHP Notice:  Use of undefined constant MYSQL_CLIENT_SSL - assumed 'MYSQL_CLIENT_SSL' in /usr/local/share/red/node/sbin/red-dump-db-list on line 28
PHP Warning:  mysqli::real_connect(): (HY000/1045): Access denied for user 'red-erica'@'erica.mayfirst.org' (using password: YES) in /usr/local/share/red/node/sbin/red-dump-db-list on line 34
failed to really connect
PHP Warning:  mysqli_select_db(): invalid object or resource mysqli
 in /usr/local/share/red/node/sbin/red-dump-db-list on line 38

Change History (2)

comment:1 Changed 5 months ago by https://id.mayfirst.org/jamie

  • Owner set to https://id.mayfirst.org/jamie
  • Status changed from new to assigned

Ack - another stretch/red failure. Working on it...

comment:2 Changed 5 months ago by https://id.mayfirst.org/jamie

  • Resolution set to fixed
  • Status changed from assigned to closed

Should be fixed now. Also, when the backup doesn't know where to put the database dump, it always puts it in /var/local/db-backups/sqldumps - which is where the backup of all member databases is now.

Tomorrow morning, they new dumps should be placed in the right location.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.