Koozali.org: home of the SME Server
Obsolete Releases => SME Server 7.x => Topic started by: k_graham on July 20, 2009, 04:23:05 AM
-
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
-
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
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
-
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
-
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.
-
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
-
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.
-
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
-
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.