store | blogs | forums | twitter | facebook | wiki | mailing lists | downloads | support portal
Atomic Secure Linux
It is currently Tue May 21, 2013 3:00 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic Share/Bookmark  [ 7 posts ] 
Author Message
 Post subject: backupmng database issue
Unread postPosted: Mon Aug 23, 2010 4:41 am 
Offline
Forum User
Forum User

Joined: Fri Jul 23, 2010 10:03 am
Posts: 38
Location: UK
I've only recently been administrating this server, which is running plesk 9.2.3 and have just noticed that backupmng isn't working and hasn't been for some time.
When trying to schedule from the control panel backupmng produces the error:
Quote:
Error: Unable to update scheduled backup information: MySQL query failed: Unknown column 'backup_time' in 'field list'

If I attempt to run from bash I also get
Quote:
backupmng: Unable to fetch backup tasks from database: Unknown column 'backup_time' in 'where clause'


Unfortunately this doesn't tell me much about where in the (mysql) psa database it's looking or why and I haven't managed to find any information to help with this.

Does anyone have any suggestions/has anyone else had this problem?

Also it appears cron was set to run this 4 times a minute - that seems more than a little extreme - is it perfectly reasonable for me to change it to run daily at 2am or something instead? This way we still have fairly regular backups and it won't affect server load and important times.


Top
 Profile  
 
 Post subject: Re: backupmng database issue
Unread postPosted: Mon Aug 23, 2010 6:15 am 
Offline
Forum User
Forum User

Joined: Fri Jul 23, 2010 10:03 am
Posts: 38
Location: UK
It appears backup_time is supposed to be in the "BackupsScheduled" table
As this table was empty I altered the table to include the column, it then said the column backup_day was missing.
After adding this I now get
Quote:
Error: Unable to update scheduled backup information: MySQL query failed: Column 'last' cannot be null

I am reluctant to continue on this path for now and reverted te table to its previous state.


Top
 Profile  
 
 Post subject: Re: backupmng database issue
Unread postPosted: Mon Aug 23, 2010 8:47 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7420
Location: earth
Was this system upgraded to 9.2? This might be a failed upgrade


Top
 Profile  
 
 Post subject: Re: backupmng database issue
Unread postPosted: Mon Aug 23, 2010 11:49 am 
Offline
Forum User
Forum User

Joined: Fri Jul 23, 2010 10:03 am
Posts: 38
Location: UK
Yes the system was upgraded from a previous version, in January I believe.

Out of curiosity I re-added the backup time and day columns and then set last to allow NULL values.
Plesk did then added everything apart from in the 'last' column. I then put a fake value from earlier in the month into 'last' and set it to NOT NULL again - I won't know if this has done anything until later on though.

(If I try to reschedule though [through plesk CP] it does do it properly this time.)


Top
 Profile  
 
 Post subject: Re: backupmng database issue
Unread postPosted: Tue Aug 24, 2010 4:13 am 
Offline
Forum User
Forum User

Joined: Fri Jul 23, 2010 10:03 am
Posts: 38
Location: UK
The backup went as planned last night. Hopefully there won't be any more problems with it.

However the email I recieve to confirm it's taken place says "Status warnings"
Attached to the email is a file which contains
Quote:
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="warnings">
<object name="domain-name" type="domain">
<message severity="warning" code="msgtext">Error during getting information about spam filter for email-address</message>
</object>
<object name="domain-name2" type="domain">
<message severity="warning" code="msgtext">Error during getting information about spam filter for email-address2</message>
</object>
</execution-result>

except that the list of email addresses is slightly longer.

None of these email addresses are present in the psa.spamfilter table, which I think is why these warnings are appearing.

All of these are email accounts that we set up fairly recently (within the last month or two) Should I worry that these aren't protected properly by spamassassin etc.? or is it nothing to worry about.


Top
 Profile  
 
 Post subject: Re: backupmng database issue
Unread postPosted: Tue Aug 24, 2010 9:23 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7420
Location: earth
You can verify that by look at each email accounts .qmail file, it should reference spamassassin in there pretty clearly


Top
 Profile  
 
 Post subject: Re: backupmng database issue
Unread postPosted: Wed Aug 25, 2010 9:12 am 
Offline
Forum User
Forum User

Joined: Fri Jul 23, 2010 10:03 am
Posts: 38
Location: UK
Thanks a lot Scott, they do still show positive for spam checking.

I am slightly curious as to why new mail accounts are no longer being put in the spamfilter table but at least it isn't a huge issue.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic Share/Bookmark  [ 7 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group