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

georgeM · 2008-07-31 15:59:11

uli, thanks for your prompt reply, and you are correct. I’ve tried the one from colak and it still returns that error. This is the original one that I wanted to use of course, because it is fixed for 4.0.6. Hopefully I’ll get to the bottom of this!

Thanks again.

EDIT: Uli has sent along his custom version of rss_admin_db_manager, and this is working perfectly in my own TXP v4.0.6 install. Grab it below!

rss_admin_db_manager_v4.3_zip.txt_fixed_for_4.0.6.zip

Hope this helps anyone else out there with these issues…and thanks again to Uli!

Last edited by georgeM (2008-07-31 18:37:45)

Mr. Smith · 2008-08-12 09:51:07

Can anyone tell me what Warning: unlink(/var/www/myhost.com/folder/files/1218534495-backup_com_db.sql) [function.unlink]: No such file or directory in /var/www/myhost.com/folder/textpattern/lib/txplib_misc.php(574) : eval()'d code on line 97 is all about?

net-carver · 2008-08-12 11:29:47

Mr. Smith

AFAIK, it’s trying to delete (unlink) a file (the .sql one) that’s not there (or perhaps that it has no permission to delete?)

The error is happening on line 97 of the code that is being evaluated on line 574 of txplib_misc.php. I’d guess that would be 97 lines into the body of the rss_admin_db_manager plugin’s code section.

Mr. Smith · 2008-08-12 14:57:51

Apparently the 127 error means that the mysql and mysqldump paths are incorrect. I will ask my host for the path. :-)

idoremus · 2008-09-25 21:30:31

A newbie question. I installed this plugin and activated it but never got the new tabs installed in my Admin panel. The information pages explains “The rss_admin_db_manager plugin adds 3 new tabs to your Textpattern admin interface…”

How can I troubleshoot this?

Thanks in advance,
Ian

swf · 2008-09-25 21:56:45

The plugin has not been updated ot work with 4.06, but if you check out this post you can download an updated version. I’ve installed it and it works.

aeonflux · 2008-10-01 22:32:50

Maniqui, Candyman and maybe netcarver…

Hope your problems are solved … I got the same 127 error, but after copy pasting the debug mode output in my ssh terminal connection a figured out that locking tables was what was giving the troubles:

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

So changed Locked tables to no what worked for me
And if you have a SSH login you can check the path of your mysql/mysqldump by typing whereis mysql and whereis mysqldump

kvnmcwebn · 2008-10-14 17:09:24

im getting the 127 error on my local host. i only get it when i back up an sql file though, not gz…
were can i find the path to the dump? i mean to check that its correct.

Last edited by kvnmcwebn (2008-10-14 17:11:23)

azw · 2008-10-14 17:38:01

I just use the FTP client I use to upload files to the site to check on the file being on the server. Do you wee the file on the server with your FTP client or perhaps Control Panel’s File Manager?

Mike Montgomery · 2008-10-20 15:46:59

Thanks to Uli for fixing this very important plugin!

kvnmcwebn · 2008-10-21 13:33:04

Hi,
regarding 127 error…
Im getting it in a localhost environment, running on mamp.
As far as I can tell the mysql Path is:
/Users/username/Applications/MAMP/db/mysql/site

But whats the mysql dump path?

azw wrote:

I just use the FTP client I use to upload files to the site to check on the file being on the server. Do you wee the file on the server with your FTP client or perhaps Control Panel’s File Manager?

maniqui · 2008-10-21 14:20:02

aeonflux wrote:

Hope your problems are solved … I got the same 127 error, but after copy pasting the debug mode output in my ssh terminal connection a figured out that locking tables was what was giving the troubles.

thanks, aeonflux.
I tried the same (copy-pasting the debug mode output in ssh terminal) and I get the following:

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

I’ve search for that error on the web, but haven’t find anything helpful yet.

azw · 2008-10-21 16:29:02

This is for Kevin of kvnmcwebn.

Sorry, this may not be what you’re asking for.

You define your paths for rss_admin_db_manager on this page in textpattern installation:
http://YOUR_DOMAIN.com/textpattern/index.php?event=rss_db_bk

That page also lists the backups you’ve got in your backups folder and gives you an option to download it to your My Documents folder (or where ever you put that kind of thing).

I suspect that a local installation makes this a little more difficult to define. I installed my local server with the separate parts, not as MAMP, so I’m not able to help you with the locations.

For textpattern on remote servers, I use the Backup Path as the place I store the backups, both on my server and in my computer in the office, so I can use FTP to move them back and forth.

On a remote server, my paths are set like this:
Backup Path: /home/MY_DOMAIN/public_html/dbbackups
mysqldump Path: mysqldump
mysql Path: mysql

I hope that’s at least somewhat helpful.

kvnmcwebn · 2008-10-23 18:20:57

aeonflux wrote:

So changed Locked tables to no what worked for me
And if you have a SSH login you can check the path of your mysql/mysqldump by typing whereis mysql and whereis mysqldump

anyone know how i could do this in terminal on osx?

and thanks azw

ok i found the mysql dump path: /Users/username/Applications/MAMP/Library/bin/mysqldump

and the db path
/Users/username/Applications/MAMP/db/mysql/sitefoldername

but still no luck…

Last edited by kvnmcwebn (2008-10-23 19:51:56)

koobs · 2008-11-25 14:49:51

@ kvnmcwebn

try setting the paths to:

/Applications/MAMP/Library/bin/mysqldump

/Applications/MAMP/Library/bin/mysql

Textpattern CMS

Textpattern CMS support forum

#241 2008-07-31 15:59:11

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

#242 2008-08-12 09:51:07

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

#243 2008-08-12 11:29:47

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

#244 2008-08-12 14:57:51

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

#245 2008-09-25 21:30:31

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

#246 2008-09-25 21:56:45

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

#247 2008-10-01 22:32:50

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

#248 2008-10-14 17:09:24

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

#249 2008-10-14 17:38:01

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

#250 2008-10-20 15:46:59

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

#251 2008-10-21 13:33:04

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

#252 2008-10-21 14:20:02

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

#253 2008-10-21 16:29:02

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

#254 2008-10-23 18:20:57

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

#255 2008-11-25 14:49:51

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

Board footer