[plugin] [ORPHAN] rss_admin_db_manager - database backups and more

aba · 2005-09-10 23:25:19

> Warning: popen,escapeshellcmd,proc_open,proc_nice() has been disabled for security reasons in /www/htdocs/txpa/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 75

> Anybody an idea what i have to fix?

It depends where you get this error. If it is your server, check the php.ini, if it is a hosted server you are probably out of luck. The message is misleading, these commands have been found in txplib_misc.php not disabled there. They are disabled globally.

serff · 2005-09-17 22:35:32

> andreas wrote:

> I tried to use the plugin but get an error message:

><code>
>Warning: unlink(/home/www/ww6199/html/akv2/_db-backup/1126388389-usr_ww6199_4.sql.gz): File or >Directory not found in /home/www/ww6199/html/akv2/textpattern/lib/txplib_misc.php(429) : eval()’d code on line >82
></code>

>BACKUP FAILED. ERROR NO: 126

>Any ideas? The paths to mysql and mysqldump are correct (I checked with my host)

I was having this same problem and I think there is a bug in what ever calls mysqldump. I have a “(” in my password and so you put mysqldump -u me -p(jfkdjslkfj blah…. and mysqldump barfs on it. If you out quotes around the password, it works. For now, I’m just changing my password.

wet · 2005-10-13 20:23:04

I’d like to suggest one minor addition to clarify the location of backups for the novice user:

97: tr(tdcs(hed("Previous Backup Files in $file_base_path",1),7)).

Adding ‘DESCRIBE’ to the set of valid SQL commands might also come handy for those among us who haven’t inhaled TxP’s table structure yet (me).

Sorry to say but I am one of those poor souls whose hosting provider has disabled popen(), so backup and restore won’t work:

Warning: popen() has been disabled for security reasons in /www/xxxxx/textpattern/lib/txplib_misc.php(429) : eval()’d code on line 32

colak · 2005-11-23 09:23:42

Site hosted in textdrive. I get ‘ BACKUP FAILED. ERROR NO: 2’ when trying to backup an SQL file. gzipped files seem to be created fine.

Also can somebody explain the option: Lock Tables?

soulship · 2005-11-23 10:30:21

colak,

What server are you on? I have accounts on Pendrell, Bidwell and Burnaby and it seems to work fine on all three for me. I’m sure that doesn’t help, but it’s something to good to know.

<p style=“margin:0px 0px 0px 20px; color: #6C6C6C; font-weight: bold; font-size: 9pt;”>Quote: </p> <div style=“margin:0px 20px 0px 20px; padding:10px 10px 10px 10px; background-color:#EBEBEB; border:1px dotted #D1D1D1; font-size: 9pt;” ><em>—lock-tables, -lLocks all tables on the server before starting the dump. MySQL uses a READ LOCAL lock, which allows concurrent inserts.</em></div>

colak · 2005-11-23 13:13:53

> soulship wrote:

> colak,

What server are you on? I have accounts on Pendrell, Bidwell and Burnaby and it seems to work fine on all three for me. I’m sure that doesn’t help, but it’s something to good to know.

Hi Jamie
I’m on jervis.

Also thanks for the explanation re the lock tables. :)

andreizinca · 2005-11-23 13:53:11

Hello Rob.

First, I want to thank you for such a wonderful plugin. It is a real time saver and very useful.

I have installed it on textpattern 4.0 with success. But, on textpattern 4.0.2 it sais plugin install failed.
What to do ?

Thank you!

Last edited by andreizinca (2005-11-23 13:53:28)

shishira · 2005-11-23 16:07:57

anybody else got it running with 4.0.2 thanks

soulship · 2005-11-23 16:36:14

I have it working in 4.02 on quite a few installs. I am wondering if you have someting blocked by your host maybe? I don’t know enough about the back side of this to know what functions might be turned away from a hosting co. though….

maniqui · 2005-11-23 16:45:52

Mmm, after seeing this last posts, I have tried to do a backup with rss_admin_db_manager and I get the following error:

Warning: unlink(/home/elefante/public_html/cluster/files/1132763980-elefante_txp2.sql): No existe el fichero o el directorio in /home/elefante/public_html/cluster/textpattern/lib/txplib_misc.php(455) : eval()’d code on line 82
BACKUP FAILED. ERROR NO: 127

I’m with 4.0.2
It used to worki in 4.0.1

I have tested in various TXP installation (in same enviroment) and all have the same problem.
The “db_manager” tab seems to work as expected, but the function of “db_backup” tab doesnt work.

Last edited by maniqui (2005-11-23 17:03:48)

alannie · 2005-12-15 22:29:30

Thanks for a great plugin! I would like for the backup functionality to also be available to my managing editors and content editors, so that they can make a database backup before making changes. I’ve already tried editing permissions in admin_config.php for tab.extensions, but it still doesn’t seem to allow managing editors and content editors to view the plugin’s db backup interface.

Is there some other change I need to make?

steventer · 2006-01-06 18:19:23

> maniqui wrote:
…
BACKUP FAILED. ERROR NO: 127

I get the same error, using 4.0.3

wilshire · 2006-01-07 04:09:30

Based on some previous research I think error code 127 means “program not found” meaning the path the mysql and/or mysqldump are incorrect but I haven’t tested this above 4.0.1 yet.

alannie – You’ll need to add a line of code to the plugin to do that. Just replace the first line of the plugin code with this:

<code>
if (@txpinterface == ‘admin’) { add_privs(‘rss_db_bk’,‘1,2,3’);
</code>

alannie · 2006-01-16 21:45:03

I recently upgraded to MySQL 4.1.16 and now am getting errors with the rss_admin_db_manager plugin (v4.0.2). I’m running Textpattern v4.0.3 When I try to back up my database, I get this:

BACKUP FAILED. ERROR NO: 2

Debug mode shows this (I’ve x’d out username and password):

/usr/local/mysql-standard-4.1.16-apple-darwin7.9.0-powerpc/bin/mysqldump -hlocalhost -uxxx -pxxx —add-drop-table urm > /Library/WebServer/Documents/_urm/files/1137447510-urm.sql

I’ve checked to make sure I’m using the correct mysql and mysqldump paths. The username and password are correct as well. All other database functionality in Textpattern seems to work fine, and phpMyAdmin works. Is there something else I need to check, or is it an issue with the plugin and MySQL 4.1.16?

Thanks,
Alicia

alannie · 2006-01-16 21:51:21

By the way, I am running PHP 4.3.11 on Apache 1.3.33 .

Textpattern CMS

Textpattern CMS support forum

#76 2005-09-10 23:25:19

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#77 2005-09-17 22:35:32

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#78 2005-10-13 20:23:04

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#79 2005-11-23 09:23:42

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#80 2005-11-23 10:30:21

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#81 2005-11-23 13:13:53

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#82 2005-11-23 13:53:11

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#83 2005-11-23 16:07:57

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#84 2005-11-23 16:36:14

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#85 2005-11-23 16:45:52

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#86 2005-12-15 22:29:30

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#87 2006-01-06 18:19:23

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#88 2006-01-07 04:09:30

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#89 2006-01-16 21:45:03

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

#90 2006-01-16 21:51:21

Re: [plugin] [ORPHAN] rss_admin_db_manager - database backups and more

Board footer