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

wilshire · 2006-01-17 14:03:43

I would check to see if anything changed in the mysql syntax. If possible try running the command from a command line and you should get a better error message.

alannie · 2006-01-17 15:57:42

Thanks for looking into this, wilshire. I ran the command from Terminal (OS X) and got this error message (username x’d out):

mysqldump: Got error: 1044: Access denied for user ‘xxx’@‘localhost’ to database ‘urm’ when using LOCK TABLES

I don’t know if this has anything to do with it, but the other day when I upgraded mysql on my other machine, I had authentication problems (couldn’t access database at all from TXP or phpMyAdmin), because MySQL 4.1 uses a new password hashing algorithm and I had set up the database password after upgrading. I resolved it by setting the password to use the old authentication protocol . I didn’t have to do that on this machine, however, because the database password was already in place before I upgraded, but could this issue be somehow affecting the plugin authentication? Database backups via rss_admin_db_manager don’t work on either machine.

wilshire · 2006-01-17 18:24:05

There is an option for the plugin to turn off table locking. Did you try that?

alannie · 2006-01-17 20:36:33

I just now turned off table locking, and it appears to work. Thanks!

23:59:59 · 2006-02-18 03:45:59

I have two bug fixes for rss_admin_db_manager:

1) Password uses characters parsed by shell

I had the same problem reported by others here where the mysqldump command would fail because the password has characters that are parsed by the shell. Here’s the fix:

Change:
<notextile>
<pre> $mysql_hup = ‘ -h’.$DB->host.’ -u’.$DB->user.’ -p’.$DB->pass;
</pre>
</notextile>

To:
<notextile>
<pre> $mysql_hup = ‘ -h’.$DB->host.’ -u’.$DB->user.’ -p’.escapeshellcmd($DB->pass);
</pre>
</notextile>

2) Restore fails to create table

When restoring backup files, I was getting the error “FAILED TO RESTORE: 1”, and when running the command from shell mysql reported “ERROR 1064”. This occurred on both of the setups I use (local = mysql 3.23.58, isp = mysql 4.0.25).

The problem is that table txp_priv has column names that are numeric (1, 2, 3, etc). I have been able to fix this by having mysqldump enclose all table names in create table with “`” by using the “-Q” flag to “mysqldump”:

Change:
<notextile>
<pre> $backup_cmd = $rss_dbbk_dump.$mysql_hup.’ —add-drop-table ‘.$lock.$DB->db.’ | gzip > ‘.$backup_path; } else { $backup_cmd = $rss_dbbk_dump.$mysql_hup.’ —add-drop-table ‘.$lock .$DB->db.’ > ‘.$backup_path;
</pre>
</notextile>

To:
<notextile>
<pre> $backup_cmd = $rss_dbbk_dump.$mysql_hup.’ -Q —add-drop-table ‘.$lock.$DB->db.’ | gzip > ‘.$backup_path; } else { $backup_cmd = $rss_dbbk_dump.$mysql_hup.’ -Q —add-drop-table ‘.$lock .$DB->db.’ > ‘.$backup_path;
</pre>
</notextile>

After making this patch, any dumps made by the patched version will restore without error. For previous dumps, you will first need to manually edit the sql file and where the creation of the table txp_priv is performed, enclose the numeric column names with single backquotes (`) and they too will restore correctly.

I am a little surprised no one mentioned this yet. Either some installs of mysql/mysqldump are adding these quotes by default, or people are simply overlooking the missing table since all the other tables are restored.

Could these these fixes be included in the next release?

Thanks.

dquirk · 2006-03-12 06:40:17

I’m on Textdrive and I can’t seem to eliminate the error below—are there any Textdrive users who know how to eliminate this error when trying to do a database backup? What should the mysqldump and mysql paths be?

Warning: unlink(/users/home/dquirk/domains/oregoncleanwater.org/web/public/files/1142136201-oregoncleanwater.sql) [function.unlink]: No such file or directory in /users/home/dquirk/domains/oregoncleanwater.org/web/public/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 82
BACKUP FAILED. ERROR NO: 127

ivorius · 2006-04-01 11:07:43

Warning: escapeshellcmd() has been disabled for security reasons in /home/ivorius.com/textpattern.ivorius.com/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 45

Warning: popen() has been disabled for security reasons in /home/ivorius.com/textpattern.ivorius.com/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 75

Warning: pclose(): supplied argument is not a valid stream resource in /home/ivorius.com/textpattern.ivorius.com/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 76

warmbeat · 2006-04-29 19:29:18

Hello all.

I’ve been running v4.1 of this plugin for a while and it installed first time.

However, I’ve recently setup a hosting account with Media Temple and can’t get it to work. When I go to make a backup i get an error: “BACKUP FAILED: folder is not writable”.

I’m 100% sure that im using the right urls – it didn’t work with the default settings.

Backup path: /var/www/html/backup
Mysqldump path: /usr/bin/mysqldump
Mysql path: /usr/bin/mysql

I’ve also checked the folder permissions. MySQL v3.23.58 is installed on my Media Temple account.

Any ideas? Cant see why it works on one and not the other.

P.S. – This is the code that the debugger is kicking out:

<code>/usr/bin/mysqldump-hblank -ublank -pblank -Q —add-drop-table —skip-lock-tables —skip-add-locks myres_co_uk_-_textpattern > /var/www/html/backup/1146339044-myres_co_uk_-_textpattern.sql</code>

Last edited by warmbeat (2006-04-29 19:35:09)

warmbeat · 2006-05-01 13:40:11

Has anybody got any thoughts on this? Or has successfuly installed the plugin on a Media Temple account?

Timid&friendly · 2006-06-20 18:30:46

I have this error

Warning: popen() has been disabled for security reasons in
/usr/local/pem/vhosts/8696/webspace/httpdocs/pixelicious/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 75

Warning: pclose() has been disabled for security reasons in
/usr/local/pem/vhosts/8696/webspace/httpdocs/pixelicious/textpattern/lib/txplib_misc.php(459) : eval()’d code on line 76

What is the function popen and what does it do?
How can i solve this?

Any ideas?

Last edited by Timid&friendly (2006-06-29 09:45:17)

Timid&friendly · 2006-06-29 13:53:01

please lol :p

saccade · 2006-07-29 14:02:15

Very fine plugin.
I have it running on different txp-installt without problems.

Unfortunately I couldn’t manage to run this plugin on my textdrive-account.
It “backups” – without error message – but the backup has only 20 bytes and there is definitely more content.

I think it has to do with “mysqldump” and “mysql” but couldn’t find which path to use.

Can anyone help me?

Sencer · 2006-07-29 14:21:41

Log in via ssh and type:
which mysqldump
That should give you the full path to the executable, if it is in your path (usually the case). Otherwise you can try locate mysqldump to find it.

saccade · 2006-07-29 14:33:51

Thank you, that was a really fast answer!
And it works now, problem resolved, thank you very much :-)
Michael

snozle · 2006-08-21 19:58:33

I just want to thank you for your amazing plugins. I currently use the rss_thumbpop one on one of my client’s sites. If you are interested you can view it here http://aoh-nj.org/gallery/gallery.

I wanted to use the rss_admin_db_manager, but when i try to install it I encounter an error. I load the plugin via the plugin tab and when I click upload it displays a preview of the PHP code, but when I click install it says that the page does not exist and gives me a 404. I have encountered a similar error on several other ‘long’ plugins, and I was wondering if you know why this is happening, I am using the new 4.0.3 version of Textpattern.

Again, thank you for the plugins, they are an enormous help. Oh, by the way, the automatic image resize plugin you linked to wasn’t there anymore so I created several automator actions on my mac to resize the original images, create thumbnails, and rename the thumbnails for import with nhn_image_import. If you would like me to send you the actions (if you use a mac) I will.

Last edited by snozle (2006-08-21 20:00:02)

Textpattern CMS

Textpattern CMS support forum

#91 2006-01-17 14:03:43

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

#92 2006-01-17 15:57:42

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

#93 2006-01-17 18:24:05

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

#94 2006-01-17 20:36:33

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

#95 2006-02-18 03:45:59

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

#96 2006-03-12 06:40:17

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

#97 2006-04-01 11:07:43

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

#98 2006-04-29 19:29:18

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

#99 2006-05-01 13:40:11

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

#100 2006-06-20 18:30:46

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

#101 2006-06-29 13:53:01

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

#102 2006-07-29 14:02:15

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

#103 2006-07-29 14:21:41

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

#104 2006-07-29 14:33:51

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

#105 2006-08-21 19:58:33

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

Board footer