Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 30th April 2013, 10:30
oliware oliware is offline
Junior Member
 
Join Date: Jan 2013
Posts: 7
Thanks: 2
Thanked 1 Time in 1 Post
Default daily backups of websites are empty.

The daily backup of all my websites are failing. The database files are empty.

I can restore all files, but the mysqldump is empty.

fe: db_c1devoogdt_wp_2013-04-28_22-32.sql.gz has a size of 58 bytes, when I unzip the file, size is 0.

How can I determine what is wrong?

I have a lot of entries like this in my cron.log:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

But where can I find where it gets his password ?
Reply With Quote
Sponsored Links
  #2  
Old 30th April 2013, 10:56
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,692
Thanks: 819
Thanked 5,319 Times in 4,172 Posts
Default

Set the correct mysql root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 30th April 2013, 11:00
oliware oliware is offline
Junior Member
 
Join Date: Jan 2013
Posts: 7
Thanks: 2
Thanked 1 Time in 1 Post
Default

when I manually login with that password, I can logon, but...
A typically buggie thing, my password is something like this:

<?php

$clientdb_host = 'localhost';
$clientdb_user = 'root';
$clientdb_password = 'abcd20C&';

?>

Can it be that the & is causing problems ?
Reply With Quote
  #4  
Old 30th April 2013, 11:04
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,692
Thanks: 819
Thanked 5,319 Times in 4,172 Posts
Default

Yes, better use a password that does not contain chars that get interpreted on the shell as operators.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
oliware (30th April 2013)
  #5  
Old 30th April 2013, 11:15
oliware oliware is offline
Junior Member
 
Join Date: Jan 2013
Posts: 7
Thanks: 2
Thanked 1 Time in 1 Post
Default

indeed that was the problem, this shouldn't happen anymore anno 2013
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in using : perfect-server-ubuntu-12.10-apache2-bind-dovecot-ispconfig-3, rezabagheri Installation/Configuration 7 30th October 2012 22:55
Bind9 failed to start after server restart laptop_user Installation/Configuration 2 1st October 2011 10:35
Vhosts...conf not synced to changes crypted General 50 24th April 2010 00:54
Ubuntu Hardy chrooted bind9 fails to start Djamu Server Operation 35 21st April 2010 08:28
Automated sending of ISPConfig daily backups to an FTP Server hmfireball Tips/Tricks/Mods 0 19th June 2008 23:10


All times are GMT +2. The time now is 12:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.