Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

net-carver
Archived Plugin Author
Registered: 2006-03-08
Posts: 1,648

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

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 mysqlno 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.


Steve

Offline

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

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

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

net-carver wrote:

is your backup path…

  1. … writable? (I’m pretty sure you’ll have checked this.)
  2. … 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!

Offline

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

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

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

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!


Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

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

net-carver
Archived Plugin Author
Registered: 2006-03-08
Posts: 1,648

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

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.


Steve

Offline

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

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

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

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?


Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

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

net-carver
Archived Plugin Author
Registered: 2006-03-08
Posts: 1,648

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

Victor (the_ghost) wrote:

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

  1. passthru() and
  2. 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.


Steve

Offline

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

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

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

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?


Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

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

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:)


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

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

merz1
Member
From: Hamburg
Registered: 2006-05-04
Posts: 994
Website

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

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.


Get all online mentions of Textpattern via OPML subscription: TXP Info Sources: Textpattern RSS feeds as dynamic OPML

Offline

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

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

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

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)

Offline

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

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

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

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


Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

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

candyman
Member
From: Italy
Registered: 2006-08-08
Posts: 684

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

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.

Offline

Board footer

Powered by FluxBB