Welcome to Geeklog, Anonymous Saturday, July 13 2024 @ 11:25 am EDT

Geeklog Forums

DB Backup issue and some other easier questions


Status: offline

staypuftman

Forum User
Newbie
Registered: 11/01/04
Posts: 3
confused
When I try to backup my database from inside of Geeklog, I get the following error on the admin/database.php page:

Incorrect path or mysqldump utility not executable.
Check $_DB_mysqldump_path definition in config.php.
Variable currently defined as: /usr/bin/mysqldump


Above and outside the structure of my page it says:

Warning: is_executable(): open_basedir restriction in effect. File(/usr/bin/mysqldump) is not within the allowed path(s): (/home/httpd/vhosts/texasfairtrade.org/httpdocs:/tmp) in /home/httpd/vhosts/texasfairtrade.org/httpdocs/admin/database.php on line 78.

After reading all this it seemed to be that the problem was the mysqldump location defined in config.php was outside of my httpdocs folder. I then went into config.php and edited the $_DB_mysqldump_path to be inside the httpdocs folder. I stuck it inside of the backups folder like it seemed to want. I got the same error with another file location:

Incorrect path or mysqldump utility not executable.
Check $_DB_mysqldump_path definition in config.php.
Variable currently defined as: /httpdocs/backups/mysqldump


Wouldnt you ideally want the backup to be outside of the httpdocs folder so that no one could access it? Maybe I really just dont understand what is wrong here - which is very likely. Any help would be much appreciated.

Also here are some little things Ive noticed in digging around old geeklog

For some reason the default time on my site is 2 hours off my particular time zone. Where do you edit this thing? Is time dependent upon the location of the server?

I turned on the RSS feed thing the other day - just to experiment. I have noticed it appears that there is no way to access it. Does geeklog do something special or should i manually link to it? I really want that little RSS icon to pop up in the address bar of firefox.

One last thing...can you make the topic headings in the left block link directly to static pages? I really want to set up static pages with blog elements in them - does geeklog have dynamic blogging variables that you plug into static pages, like moveable type does?

Dirk & company...this is excellent software by the way. Thanks for all the hard work and dedication to the project.

Best
John Serrao Its a deal - shaking hands
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
About mysqldump: Talk to your hosting service - they should let you access that program without having to put everything into your document root. Failing that, try this plugin.


For the timezone problem, search for "Timezone Hack" (also in your config.php).


For the RSS feed, an entry is added automatically to your site's header if you choose that option when setting up the feed ("Header link in topic: all", for example).


The topics block is only for topics. I have no idea what "blogging variables" are in MT, so you may want to explain that in some more detail ...

bye, Dirk (too lazy to quote today)
 Quote

Status: offline

arturs

Forum User
Newbie
Registered: 05/19/06
Posts: 6
Location:Israel
mysqldump owned by root:root.

what permissions should i set in order to allow geeklog to use it?

or else?

thank you.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by arturs: what permissions should i set in order to allow geeklog to use it?

Keep in mind that when Geeklog calls mysqldump, it's really the webserver / webserver's user calling mysqldump. So you have to set permissions accordingly.

bye, Dirk
 Quote

Status: offline

arturs

Forum User
Newbie
Registered: 05/19/06
Posts: 6
Location:Israel

hi Dirk,

apache runs with nobody:nobody
sites are owned by site_admin:site_number, i.e. master6:site6

is there a way to set perms for mysqldump so EVERY site could use it?
what perms should i apply in this case?

thank you.
 Quote

All times are EDT. The time is now 11:25 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content