[3.3.0] Auto db Backup

[Tino23]

German language file

de.zip

[rwg]

Hi,

first, thanks for providing such a useful extension. I have been using it for some time (before it was hosted here), and updated to the latest version a month or so back.

I have had a problem with both the older and the latest version - deleting old backup files was just not working. I had some time today to look into it and by adding various logging throughout the cron task, it seems that for some reason it was having a problem deleting one or more of the files using 'unlink'. This was then causing the cron task to fail to complete successfully, leaving the cron lock in place, etc.

I tried to work out what was going on with the delete failure by adding a try/catch, but annoyingly I saw one catch log message and then after that everything seemed to work on following runs, deleting files as required.

Along the way, I think I also saw cases where the backup was failing to complete the SQL saving stage, a couple of times in the (rather large) search tables - maybe this is some sort of timeout from my hosting provider? Anyway, I also hacked the code to skip the _search_* tables from the backup, since they can be regenerated. Might be a nice option?

My auto_db_backup_last_gc is still stuck in 2020 and doesn't seem to update, but the _next_gc config is fine, so the backup seems to run as required. I think I will not worry about that one!

cheers,

Robin

[devspace]

If you have a large database it is possible that php is timing out - try, if you can, increasing the max execution time.

[rwg]

Yes, that's quite possible - the database isn't enormous (a few hundred megabytes), but as far as I can work out there is probably a 60s timeout from the hosting provider for PHP which I cannot alter.

I am going to try setting gzip rather than bzip to increase the speed of creating the backup, and ignoring the search tables definitely helps.

I wonder how long it has been since I had a successful backup that actually completed rather than being cut off? It's a shame that this error is basically 'silent' ... Unless you notice the lack of 'backup completed' entries in the logs then you might never notice.

Maybe if there was a bit of code at the end of the cron task to write a 'backupOK' file or to set a setting to 'last backup ran OK' then the ACP page could flag up the fact that backups were failing?

cheers,

Robin

[devspace]

Maybe if there was a bit of code at the end of the cron task to write a 'backupOK'

There is - it's in the Admin log

[rwg]

Hi,

yes, I guess, but I guess that my argument would be that it would be nice to have a 'backup failed' entry in the admin log in this case, rather than just a lack of a 'backup completed OK' entry. The former is much more noticeable.

cheers,

Robin

[donsenilo]

First I get the

Module ACP_AUTO_DB_BACKUP does not exist

-Error and after uploading the de-Translationfile I get

SQL ERROR [ mysqli ]

Duplicate entry 'devspace/autodbbackup' for key 'ext_name' [1062]

SQL

INSERT INTO phpbb_ext (ext_name, ext_active, ext_state) VALUES ('devspace/autodbbackup', 0, 'b:1;')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 202
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 179
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 241
CALL: phpbb\extension\manager->update_state()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

I use phpBB 3.3.10

[devspace]

What are the steps that you have done?

[donsenilo]

As you noted

If you are using any other version of this extension then it must be Disabled /Delete data and the original files deleted before installing this version

and then upload and (try to) activate as usual.

[david.matthewson]

Hi

I'm a newbie to this and wonder if you can give me some advice pls. I've installed the Auto db Backup but when I try to configure it I get:

Information

There is a problem with your timezone setting in the UCP.


Any suggestions as to where I should go to try to fix this please?

Thanks

David

[david.matthewson]

OK, sorted this. In my UCP it was set to UTC+1 which did not work. Setting it to Europe/London (giving the same actual time) did work.
Thanks

[donsenilo]

Tried it again and get as before

Ein erforderliches Modul existiert nicht: ACP_AUTO_DB_BACKUP

[david.matthewson]

Yes, great extension - after a minor issue with time zones on our server this works well and is a really useful tool. Thanks to devspace.

[proviter]

Devspace please tell me.
For this extension, in the ACP - Server settings - Planner of the cron, what value should be set? Yes or No?
I have a value Yes, because another script has been installed to execute.

[devspace]

Devspace please tell me.
For this extension, in the ACP - Server settings - Planner of the cron, what value should be set? Yes or No?
I have a value Yes, because another script has been installed to execute.

To run the autobackup that would need to be set to "No". Never tried running it outside of phpBB and not sure if it would work.

[proviter]

Devspace please tell me.
For this extension, in the ACP - Server settings - Planner of the cron, what value should be set? Yes or No?
I have a value Yes, because another script has been installed to execute.

To run the autobackup that would need to be set to "No". Never tried running it outside of phpBB and not sure if it would work.

Thank you!
I have phpbb 3.3.10. But I have a script of an automatic backup db, with sending to the mail. Schedule launch, in the crown

[RomaamoR]

I can't go to the extension settings. I always get the answer that - There is a problem with your timezone setting in the UCP.
I tried changing the time to something else. Did not help. How to solve this problem ?

[devspace]

I tried changing the time to something else. Did not help. How to solve this problem ?

Not time but timezone.

Post a screen grab of those settings

[RomaamoR]

Not time but timezone.

I tried changing the time zone.

[devspace]

That is the Guest setting in the ACP - you need to set the correct timezone in your UCP

[RomaamoR]

Thank you. It works now.

[sourekvladimir]

Hello,
I would like to migrate from older version (2.1.0-rc2) to this one. I have disabled previous version, deleted data and ext. files.
Then installed new one but I can't access settings:

This page isn’t working xxx is currently unable to handle this request.
HTTP ERROR 500

Currently I have rolled back to 2.1.0-rc2.
Any advice where to look for error?
Thanks a lot.
Vlada

[devspace]

Any advice where to look for error?

Server error logs would be my first choice

[sourekvladimir]

Code: Select all

[Sun Dec 03 13:54:54.618096 2023] [fcgid:warn] [pid 2965084] [client 88.101.166.125:0] mod_fcgid: stderr: PHP Fatal error:  Uncaught phpbb\\exception\\runtime_exception: FSOCK_DISABLED in /var/www/vhosts/sitename/sitename/phpbb/file_downloader.php:96, referer: https://sitename/adm/index.php?sid=eeda671156c07602fcd367e6a223125b&i=256
[Sun Dec 03 13:54:54.618127 2023] [fcgid:warn] [pid 2965084] [client 88.101.166.125:0] mod_fcgid: stderr: Stack trace:, referer: https://sitename/adm/index.php?sid=eeda671156c07602fcd367e6a223125b&i=256

Code: Select all

Sun Dec 03 13:55:08.586121 2023] [fcgid:warn] [pid 2958822] [client 88.101.166.125:0] mod_fcgid: stderr: #4 /var/www/vhosts/sitename/sitename/ext/devspace/autodbbackup/core/functions.php(88): phpbb\\extension\\manager->version_check(), referer: https://sitename/adm/index.php?sid=eeda671156c07602fcd367e6a223125b&i=256
[Sun Dec 03 13:55:08.586128 2023] [fcgid:warn] [pid 2958822] [client 88.101.166.125:0] mod_fcgid: stderr: #5 /var/www/vhosts/sitename/sitename/ext/devspace/autodbbackup/controller/admin_controller.php(154): devspace\\autodbbackup\\core\\functions->version_check(), referer: https://sitename/adm/index.php?sid=eeda671156c07602fcd367e6a223125b&i=256
[Sun Dec 03 13:55:08.586134 2023] [fcgid:warn] [pid 2958822] [client 88.101.166.125:0] mod_fcgid: stderr: #6 /var/www/vhosts/sitename/sitename/ext/devspace/autodbbacku in /var/www/vhosts/sitename/sitename/phpbb/file_downloader.php on line 96, referer: https://sitename/adm/index.php?sid=eeda671156c07602fcd367e6a223125b&i=256

Are there any clues? FSOCK_DISABLED probably?
Thanks

[devspace]

FSOCK_DISABLED probably?

Definitely