Topic: backup error in 7.4 and not working

[k_graham]

I just realized one can back up to workstation in 7.4 by changing from backup to desktop in administration - I thought I had to install DAR2 first.

In any event it doesn't appear to be working - probably my fault I tried a year or 2 back to install a pdf printer which involved installing cups - I don't think a previous SME version had cups.

I've tried

yum remove cups

and yum install cups

including update and reboot commands

also have done a

 yum info installed smeserver-dar2

it is showing as installed.

Log follows, I have made the error lines bold and in color

Anyway I am getting a cups error and a sql error

I deleted the IBAY concerned with the Ibay database some time ago but I guess I need to somehow also delete the SQL database.

Any suggestions appreciated.

Jul 19 18:58:02 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: OLD 1248055081=(undefined)
Jul 19 18:58:02 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: NEW 1248055081=backup_record
Jul 19 18:58:02 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: OLD 1248055081=backup_record
Jul 19 18:58:02 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: NEW 1248055081=backup_record|StartEpochTime|1248055081
Jul 19 18:58:02 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: OLD 1248055081=backup_record|StartEpochTime|1248055081
Jul 19 18:58:02 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: NEW 1248055081=backup_record|BackupType|workstation|StartEpochTime|1248055081
Jul 19 18:58:02 s2 esmith::event[5358]: Processing event: pre-backup 
Jul 19 18:58:02 s2 esmith::event[5358]: Running event handler: /etc/e-smith/events/actions/generic_template_expand
Jul 19 18:58:02 s2 esmith::event[5358]: expanding /etc/dar/DailyBackup.dcf 
Jul 19 18:58:02 s2 esmith::event[5358]: generic_template_expand=action|Event|pre-backup|Action|generic_template_expand|Start|1248055082 214888|End|1248055082 503033|Elapsed|0.288145
Jul 19 18:58:02 s2 esmith::event[5358]: Running event handler: /etc/e-smith/events/pre-backup/S10mysql-delete-dumped-tables
Jul 19 18:58:02 s2 esmith::event[5358]: S10mysql-delete-dumped-tables=action|Event|pre-backup|Action|S10mysql-delete-dumped-tables|Start|1248055082 503485|End|1248055082 576370|Elapsed|0.072885
Jul 19 18:58:02 s2 esmith::event[5358]: Running event handler: /etc/e-smith/events/pre-backup/S20mysql-dump-tables
Jul 19 18:58:04 s2 esmith::event[5358]: mysqldump: Got error: 1194: Table 'procolor1_bb_topics' is marked as crashed and should be repaired when using LOCK TABLES 
Jul 19 18:58:04 s2 esmith::event[5358]: S20mysql-dump-tables=action|Event|pre-backup|Action|S20mysql-dump-tables|Start|1248055082 576966|End|1248055084 241575|Elapsed|1.664609|Status|256
Jul 19 18:58:04 s2 esmith::event[5358]: Running event handler: /etc/e-smith/events/pre-backup/S50rewind-tape
Jul 19 18:58:04 s2 esmith::event[5358]: S50rewind-tape=action|Event|pre-backup|Action|S50rewind-tape|Start|1248055084 241851|End|1248055084 385249|Elapsed|0.143398
Jul 19 18:58:04 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: OLD 1248055081=backup_record|BackupType|workstation|StartEpochTime|1248055081
Jul 19 18:58:04 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: NEW 1248055081=backup_record|BackupType|workstation|EndEpochTime|1248055084|StartEpochTime|1248055081
Jul 19 18:58:04 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: OLD 1248055081=backup_record|BackupType|workstation|EndEpochTime|1248055084|StartEpochTime|1248055081
Jul 19 18:58:04 s2 /sbin/e-smith/do_backupwk[5357]: /home/e-smith/db/backups: NEW 1248055081=backup_record|BackupType|workstation|EndEpochTime|1248055084|Result|pre-backup:256|StartEpochTime|1248055081
Jul 19 19:00:26 s2 smbd[3825]: [2009/07/19 19:00:26, 0] printing/print_cups.c:cups_connect(69)
Jul 19 19:00:26 s2 smbd[3825]:   Unable to connect to CUPS server localhost:631 - Connection refused
Jul 19 19:00:26 s2 smbd[3825]: [2009/07/19 19:00:26, 0] printing/print_cups.c:cups_connect(69)
Jul 19 19:00:26 s2 smbd[3825]:   Unable to connect to CUPS server localhost:631 - Connection refused

Refresh this logfile

Thanks,

Ken

[janet]

k_graham

After you have done all the following, report back if you still have problems, or none.

To check if dar2 is installed
rpm -q smeserver-dar2

To uninstall
rpm -e smeserver-dar2

To check if cups is installed
rpm -q cups
rpm -q cups-printanalyzer

To uninstall these packages
rpm -e cups-printanalyzer
rpm -e cups
(you may need to swap the order around if one is dependant on the other)

You will/may also need to reinstall the e-smith-LPRng rpm which was removed during a standard cups install (if not reinstalled at some other time)

To check if installed
rpm -q e-smith-LPRng

To reinstall
yum install e-smith-LPRng
signal-event post-upgrade
signal-event reboot


Please make sure you ONLY have the standard respositories enabled (see below), or you will update a lot of other rpms that you probably do not want to update.
Check the FAQ re these, here is the link.
http://wiki.contribs.org/SME_Server:Documentation:FAQ#Which_repositories_should_be_enabled

Then do a general update of your server to make sure the standard rpms are all installed
yum update
signal-event post-upgrade
signal-event reboot

To check which repos are enabled, do the following

db yum_repositories show

Here is the output from my sme7.4 server

addons=repository
    BaseURL=http://mirror.centos.org/centos/4/addons/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=addons
    Name=CentOS - addons
    Visible=no
    status=disabled
base=repository
    BaseURL=http://mirror.centos.org/centos/4/os/$basearch
    EnableGroups=no
    Exclude=kernel,kernel-smp,mkinitrd,mdadm,initscripts
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
    Name=CentOS - os
    Visible=yes
    status=enabled
centosplus=repository
    BaseURL=http://mirror.centos.org/centos/4/centosplus/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
    Name=CentOS - centosplus
    Visible=no
    status=disabled
contrib=repository
    BaseURL=http://mirror.centos.org/centos/4/contrib/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=contrib
    Name=CentOS - contrib
    Visible=no
    status=disabled
dag=repository
    BaseURL=http://apt.sw.be/redhat/el4/en/$basearch/dag
    EnableGroups=no
    Exclude=freetype,htop,iptraf,rsync,syslinux
    GPGCheck=yes
    GPGKey=http://dag.wieers.com/packages/RPM-GPG-KEY.dag.txt
    Name=Dag - EL4
    Visible=no
    status=disabled
extras=repository
    BaseURL=http://mirror.centos.org/centos/4/extras/$basearch
    EnableGroups=no
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
    Name=CentOS - extras
    Visible=no
    status=disabled
smeaddons=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smeaddons/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smeaddons-7
    Name=SME Server - addons
    Visible=yes
    status=enabled
smecontribs=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smecontribs/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smecontribs-7
    Name=SME Server - contribs
    Visible=no
    status=disabled
smedev=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smedev/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smedev-7
    Name=SME Server - dev
    Visible=no
    status=disabled
smeextras=repository
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smeextras-7
    Name=SME Server - extras
    Visible=yes
    status=enabled
smeos=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smeos/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smeos-7
    Name=SME Server - os
    Visible=yes
    status=enabled
smetest=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smetest/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smetest-7
    Name=SME Server - test
    Visible=no
    status=disabled
smeupdates=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smeupdates/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smeupdates-7
    Name=SME Server - updates
    Visible=yes
    status=enabled
smeupdates-testing=repository
    BaseURL=http://mirror.contribs.org/pub/smeserver/releases/7/smeupdates-testing/$basearch
    EnableGroups=yes
    GPGCheck=yes
    MirrorList=http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/smeupdates-testing-7
    Name=SME Server - updates testing
    Visible=yes
    status=disabled
testing=repository
    BaseURL=http://mirror.centos.org/centos/4/testing/$basearch
    EnableGroups=no
    GPGCheck=yes
    Name=CentOS - testing
    Visible=no
    status=disabled
updates=repository
    BaseURL=http://mirror.centos.org/centos/4/updates/$basearch
    EnableGroups=no
    Exclude=kernel,kernel-smp,mkinitrd,mdadm,initscripts
    GPGCheck=yes
    MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
    Name=CentOS - updates
    Visible=yes
    status=enabled

[k_graham]

k_graham


To check if cups is installed
rpm -q cups
rpm -q cups-printanalyzer

To uninstall these packages
rpm -e cups-printanalyzer
rpm -e cups
(you may need to swap the order around if one is dependant on the other)

Hi Mary;

Thanks for instructions

Initially it did not help but did clear the CUPs error.

After I dropped the database that was causing a problem it appeared to work. I made a complete backup and it has done a partial the next night. Over 100 files initially - about 80 GIGs of data and was done before next day so was quick.

The cups-printanalyzer does not install - doesn't seem to exist in the repositories. Not sure  what it does or if is the source of difficulties by not having it.

Also I tried to re-install dar2 befoe dropping the database and it stil fails, before and after.

The downside is I tried to do a selective restore from workstation and it simply times out. I don't at the moment have a spare system or I would try a complete install to see if that works. Now I think of it I may bring the USB drive home and try to see the data on a computer I have been experimenting with Ubuntu on.

When previously using Winrar for backup I had a setting where by up to 1% of file could be missing or corrupted and it would still work - especially useful if sending by email where even 1 bit causes a file to fail - I'm wondering if theres a setting like that in DAR?

Thanks
Ken

[cactus]

After I dropped the database that was causing a problem it appeared to work.

Why did you do that? The error in one of your first posts clearly stated what action you should have taken (you even highlighted it):

Jul 19 18:58:02 s2 esmith::event[5358]: Running event handler: /etc/e-smith/events/pre-backup/S20mysql-dump-tables
Jul 19 18:58:04 s2 esmith::event[5358]: mysqldump: Got error: 1194: Table 'procolor1_bb_topics' is marked as crashed and should be repaired when using LOCK TABLES 
Jul 19 18:58:04 s2 esmith::event[5358]: S20mysql-dump-tables=action|Event|pre-backup|Action|S20mysql-dump-tables|Start|1248055082 576966|End|1248055084 241575|Elapsed|1.664609|Status|256

You should have tried to repair the table first. For the next time: http://dev.mysql.com/doc/refman/4.1/en/mysqlcheck.html

[CharlieBrady]

In any event it doesn't appear to be working - probably my fault I tried a year or 2 back to install a pdf printer which involved installing cups - I don't think a previous SME version had cups.

No SME version includes cups. This thread is therefore off-topic for this particular forum. Your problems all appear to be related to add-on software.

[k_graham]

Why did you do that? The error in one of your first posts clearly stated what action you should have taken (you even highlighted it):
You should have tried to repair the table first. For the next time: http://dev.mysql.com/doc/refman/4.1/en/mysqlcheck.html

[k_graham]

Why did you do that? The error in one of your first posts clearly stated what action you should have taken (you even highlighted it):
You should have tried to repair the table first. For the next time: http://dev.mysql.com/doc/refman/4.1/en/mysqlcheck.html

I did it because your very good post arrived after I already did it. The database was for an experimental forum I set up but it had been spammed - I see why Contribs uses the verification.  Anyway now I know for something important.

[k_graham]

No SME version includes cups. This thread is therefore off-topic for this particular forum. Your problems all appear to be related to add-on software.

So as Cups didn't work for my purpose to create pdf'S I will try removing it again along with DAR2 and use suggestions made to try and bring my system back to original.

As mentioned my system seems to be backing up now using built in DAR to workstation and also if used as to USB device. However the function to restore a selected files times out. Backup without selective restore is of limited use but hopefully it will resolve as I try to bring system back to original without add ons.

Thanks,

Ken

[cactus]

As mentioned my system seems to be backing up now using built in DAR to workstation and also if used as to USB device. However the function to restore a selected files times out. Backup without selective restore is of limited use but hopefully it will resolve as I try to bring system back to original without add ons.

Problems like that should eb reported in the bugtracker with as much relevant detail as possible. If you do so please post a reference to the bug here for future readers.