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

net-carver · 2007-11-29 11:26:34

You might want to ask your host if they disable any of the following: passthru , popen or pclose.

Can you check if php safe mode is on or off? If it’s on then your mysqldump Path should say mysqldump and your mysql Path should read mysql — no path components at all in those fields. Then you need to ask your host if mysql and mysqldump are in the safe_mode_exec_dir directory.

candyman · 2007-11-29 22:54:38

net-carver wrote:

is your backup path…

… writable? (I’m pretty sure you’ll have checked this.)

… set correctly in the Extensions > DB Backup > Backup Path field? (On my Dreamhost setup this is an absolute path with no trailing slash at the end.)

Thanks for your help, net-carver. Yes, the directory is writeable (appear the 20kb backup if I use the gzipped option) and the path is OK, ‘cause if I change it I get the ERROR NO. 127.

I forwarded all your advices to my ISP: toworrow we’ll know.

Thanks again!

the_ghost · 2007-12-03 23:50:44

How can i restore *.sql backup if popen() function is off for security reasons at my new hoster? I’ve installed clear txp. Can i impoert this sql right into mysql using phpmyadmin? Or is there any other way to use plugin without this (popen()) function?

Thanks!

net-carver · 2007-12-04 07:35:42

Victor the_ghost

You should be able to import the .sql file directly via phpmyadmin, I think it can even handle the gzipped version too but I’m not sure. Do backup your original db first.

However, if passthru() is available and not disabled on your host then the plugin should still work.

the_ghost · 2007-12-04 10:50:23

net-carver
When I try to restore sql on my new host it shows an error:

Warning: popen() has been disabled for security reasons in /home/u78707/cosmakc.ru/www/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 136
Warning: pclose(): supplied argument is not a valid stream resource in /home/u78707/cosmakc.ru/www/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 137

So, as you see restore doesn’t work at all. May be it’s possible to change anything in source-code of plugin?

net-carver · 2007-12-04 15:33:55

Victor (the_ghost) wrote:

Yes, the plugin won’t work on any host that has…

passthru() and
popen() / pclose()

disabled for whatever reason.

So, as you see restore doesn’t work at all. May be it’s possible to change anything in source-code of plugin?

I don’t know what to change it to. AFAIK, those functions your host has blocked are the correct ways to call external programs from php.

If your host has locked down those calls to prevent arbitrary script / program execution from hosted php files then I doubt they’ll leave other doors open — but I could be wrong.

the_ghost · 2007-12-04 16:36:17

net-carver
About back-door you are partly right – there is way to compile mine php-compiler at host with requered params. But it’s rather difficult to me.

P.S. Does anyone can write simple instruction how to move txp?

colak · 2007-12-04 17:22:50

If you have access to phpMyAdmin all you need to do is

log into it
Choose your database from the left column
Click export from the top menu
Choose the tables from the select menu
Below that choose SQL if it is not already chosen
Click zipped or gzipped from the bottom of the page
Click “Go” at the bottom right
Wait….

To import it to a new db

Click import from the top menu
Click ‘browse’ to find your (g)zipped file
Click Go

Hope that helps:)

merz1 · 2007-12-04 17:40:38

Pls. always use gzipped! Otherwise you may run into other file size limitations when restoring the backup. As far as I remember there is some 2MB limitation when uploading via browser.

candyman · 2007-12-04 18:55:54

Returning to the 20Kb and error NO. 2 problem…

I asked my Host about the impossibility to make the backup: they said that the error may be in the :3306 that I add at the end of the name server (I am on a server with different users) that I’ve specified during installation in the config.php. So I’ve changed:

mysql.myhost.com:3306

in

mysql.myhost.com

and now I get the ERROR NO. 127:

Warning: unlink(/var/www/vhosts/mydomain.it/httpdocs/backup/1196793700-nameofdatabase_1.sql) [function.unlink]: No such file or directory in /var/www/vhosts/mydomain.it/httpdocs/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 95

Now it seems an url problem. Any suggestions, please?

Last edited by candyman (2007-12-04 18:57:35)

the_ghost · 2007-12-05 01:46:19

candyman – check paths in plugin options, i think..

candyman · 2007-12-05 11:55:21

They are OK.

I’ve changed the config.php removing the :3306 at the end of the server name and the error appeared. Then I replaced the original file but the error remained. It seems like something got corrupted.

Textpattern CMS

Textpattern CMS support forum

#181 2007-11-29 11:26:34

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

#182 2007-11-29 22:54:38

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

#183 2007-12-03 23:50:44

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

#184 2007-12-04 07:35:42

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

#185 2007-12-04 10:50:23

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

#186 2007-12-04 15:33:55

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

#187 2007-12-04 16:36:17

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

#188 2007-12-04 17:22:50

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

#189 2007-12-04 17:40:38

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

#190 2007-12-04 18:55:54

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

#191 2007-12-05 01:46:19

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

#192 2007-12-05 11:55:21

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

Board footer