Topic: Backup from v7.1 and restore to v7.3?

[dmacgregor963]

I have experienced difficulty doing a yum update to v7.3, quite likely related to the fact that I am coming all the way from v7.1.  I thought I would try to do a fresh install of v7.3 and then bring over the data from v7.1.  Is it likely that a backup created on v7.1 could be restored to  v7.3 and have a properly working v.7.3 server as the result?  Alternatively, how can get a list of necessary files in addition to /home that I would need to copy over manually?

[raem]

dmacgregor963

Please read the FAQ especially
http://wiki.contribs.org/SME_Server:Documentation:FAQ#Updating_from_SME_7.x_to_SME_7.2

yum upgrade should work OK as long as you follow the config issues in the FAQ.
Alternatively download the 7.3 CD iso, burn a disk and do a CD upgrade by  selecting the upgrade option

Details about what is included in a backup are here (but you won't really need to use that, just get yum working and you should be right).
http://wiki.contribs.org/Backup_server_config

[dmacgregor963]

I finally got the backup together and did the CD upgrade and encountered the same problem as before.  Being a relative newbie to smeserver I would like to get feedback on what I see before I report a bug.  In particular, a workaround would be very helpful so I don't have to revert to 7.1 so the server can be up for users in the morning -- that involves a lot of extra work.

The problem is that outgoing mail won't go out.  From the qpsmtpd log, it appears to me that the outgoing virus scan is failing due to an configuration issue with clamd.conf and keeping the message from being sent.  It looks like I need to get a boolean value set for LogFileUnlock which is currently blank.  I tried setting it to yes but that didn't do it

So near and yet so far!! Please someone help get this going so I can put this server back in operation.  Many thanks in advance!!

Here is extract from qpsmtpd log:

@4000000047c1f0ac0c889094 11645 spooling message to disk
@4000000047c1f0ac12dde32c 11645 virus::clamav plugin: Changing permissions on file to permit scanner access
@4000000047c1f0ac131c8654 11645 virus::clamav plugin: clamscan results: ERROR: Parse error at line 28: Option LogFileUnlock requires boolean argument.
@4000000047c1f0ac131c95f4 WARNING: Can't parse the configuration file.
@4000000047c1f0ac132037a4 11645 virus::clamav plugin: ClamAV error: /usr/bin/clamdscan --stdout  --config-file=/etc/clamd.conf --disable-summary /var/spool/qpsmtpd/1203892386:11645:0 2>&1: 2
@4000000047c1f0ac1320435c
@4000000047c1f0ac1332a27c 11645 logging::logterse plugin: ` 192.168.3.138   pc-00138.*****.com   RDSupport   <christina.welsh@*****.com>   <doug@*****.com>   virus::clamav   902      msg denied before queued
@4000000047c1f0ac1341775c 11645 logterse plugin: ` 192.168.3.138   pc-00138.*****.com   RDSupport   <christina.welsh@*****.com>   <doug@*****.com>   virus::clamav   902      msg denied before queued
@4000000047c1f0ac134aed3c 11645 452 Message denied temporarily
@4000000047c1f0ae31408f04 11645 dispatching QUIT
@4000000047c1f0ae314a5ad4 11645 221 *****.com closing connection. Have a wonderful day.
@4000000047c1f0ae314edb2c 11645 click, disconnecting

Here is clamd.conf

#------------------------------------------------------------
#          !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------
ArchiveBlockEncrypted no
ArchiveBlockMax no
ArchiveMaxCompressionRatio 300
ArchiveMaxFileSize 15M
ArchiveMaxFiles 1500
ArchiveMaxRecursion 8
DatabaseDirectory /var/clamav
Debug no
DetectBrokenExecutables no
FixStaleSocket yes
Foreground yes
IdleTimeout 60
LeaveTemporaryFiles no
LocalSocket /var/clamav/clamd.socket
LogClean no
LogFile /dev/stderr
LogFileMaxSize 0
LogFileUnlock
LogTime no
LogVerbose yes
MaxConnectionQueueLength 30
MaxDirectoryRecursion 20
MaxThreads 20
ReadTimeout 300
ScanArchive yes
ScanHTML yes
ScanMail yes
ScanOLE2 yes
ScanPE yes
#ScanRAR

SelfCheck 1800
# Close the connection if this limit is exceeded.
StreamMaxLength 25M
#TCPAddr 127.0.0.1
#TCPSocket 3310
TemporaryDirectory /var/tmp
User clamav
AllowSupplementaryGroups yes

[dmacgregor963]

I had to go and revert back to 7.1 for now.    Before doing so I tried setting LogFileUnlock to no but that didn't work either.  I see that LogFileUnlock doesn't appear at all in clamd.conf in smeserver7.1

[raem]

dmacgregor963

Do you have additional custom templates or db settings.
Here's my sme7.3 /etc/clamd.conf which does not have LogFileUnlock

#------------------------------------------------------------
#              !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------
ArchiveBlockEncrypted no
ArchiveBlockMax no
ArchiveMaxCompressionRatio 300
ArchiveMaxFileSize 55M
ArchiveMaxFiles 1500
ArchiveMaxRecursion 8
DatabaseDirectory /var/clamav
Debug no
DetectBrokenExecutables no
FixStaleSocket yes
Foreground yes
IdleTimeout 60
LeaveTemporaryFiles no
LocalSocket /var/clamav/clamd.socket
LogClean no
LogTime no
LogVerbose yes
MaxConnectionQueueLength 30
MaxDirectoryRecursion 20
MaxThreads 20
ReadTimeout 300
ScanArchive yes
ScanHTML yes
ScanMail yes
ScanOLE2 yes
ScanPE yes
SelfCheck 1800
# Close the connection if this limit is exceeded.
StreamMaxLength 25M
#TCPAddr 127.0.0.1
#TCPSocket 3310
TemporaryDirectory /var/tmp
User clamav
AllowSupplementaryGroups yes

[dmacgregor963]

No, nothing customized that I know of.  I simply downloaded the latest iso, burnt the CD and ran an upgrade installation against my working server, which is at the 7.1 level.  7.1.3 to be exact, I think.  I will check with my predecessor sys admin and see if he knows of any customizations.

[brianr]

Hi Doug

(_I_ am the previous sys admin).

No customistations that i can recall, however you should check

/etc/e-smith/templates-custom/etc/clamd.conf/

to see if there are any files which would be included when the template is expanded.

[dmacgregor963]

The folder

/etc/e-smith/templates-custom/etc

does not exist on either my v7.1 or v7.3 systems. There is only

/etc/e-smith/templates-custom/var

Does this mean there are no customizations or that we are looking in the wrong place?

Also, the clamd.conf on my v7.1 is the same as the one Ray posted (with the minor exception of ArchiveMaxFileSize 15M instead of ArchiveMaxFileSize 55M)

[CharlieBrady]

I finally got the backup together and did the CD upgrade and encountered the same problem as before.  Being a relative newbie to smeserver I would like to get feedback on what I see before I report a bug.

No, please report the problem via the bug tracker and then you will receive feedback from the people who are best placed to solve the problem, both for you and for others.

[dmacgregor963]

Thanks to Brian I may have a workaround at least.  Deleting LogFileUnlock
from /etc/e-smith/templates/etc/clamd.conf and then doing

expand-template /etc/clamd.conf

causes LogFileUnlock be disappear from clamd.conf.  When I get the right server/network configuration set up again I will test this by trying to send email again.

And yes, I will post to the bug tracker, once I am clear on exactly what to post.

[CharlieBrady]

And yes, I will post to the bug tracker, once I am clear on exactly what to post.

No, please post immediately. You will be given guidance in the bug tracker on what is required to track down the cause of your problem. Backup and restore should "just work". If it doesn't, then please help us to find and fix the problem.

[dmacgregor963]

I posted the bug report.  Bug #3979.  I appreciate everyone's willingness to help.  BTW, backup/restore appears to work OK.  The problem is with updating from v7.1 to v7.3.