Topic: [SOLVED]After upgrade to 8.0.b6: dspam_stats throws error about libldap-2.2.so.7

[Michail Pappas]

Had a nice installation of 7.5 running. Company owner smartly decided to call in a web site creator, try to throw in joomla, failed because of PHP5 dependencies (or so I was told), totally screwed up SME and then upgraded to 8.0.b6 (!!!)

Strangling the company owner (friend of mine) is one thing I'll definitely have to take care off. Atm though, I have a couple of issues:

1) Been receiving hourly logs of the following format:

Code: [Select]

/etc/cron.hourly/dspam_check_training:

/usr/bin/dspam_stats: error while loading shared libraries: libldap-2.2.so.7: cannot open shared object file: No such file or directory
/etc/cron.hourly/dspam_check_training: line 6: [: -eq: unary operator expected
More info:

Code: [Select]

# ldd /usr/bin/dspam_stats
        linux-gate.so.1 =>  (0xb7f07000)
        libdspam.so.7 => /usr/lib/libdspam.so.7 (0xb7eea000)
        libm.so.6 => /lib/libm.so.6 (0x005eb000)
        libdl.so.2 => /lib/libdl.so.2 (0x00616000)
        libldap-2.2.so.7 => not found
        liblber-2.2.so.7 => not found
        libpthread.so.0 => /lib/libpthread.so.0 (0x006a7000)
        libc.so.6 => /lib/libc.so.6 (0x00490000)
        /lib/ld-linux.so.2 (0x00471000)
        libldap-2.2.so.7 => not found
        liblber-2.2.so.7 => not found
It also seems liblber is missing as well. Should I install some packages? Should I kick the renegade web admin hard in the face? Both?

2) Previously, I had the internal (LAN) clients access email via IMAP and SMTP (non-secure), whereas access from the internet was made using Secure IMAP and Secure SMTP. IIRC, no used authentication was performed in the LAN side (2-3 accounts all in all). Now this does not work, I receive 550 relaying errors when trying to send. Any ideas?

3) Which are the correct repositories for this (8.0.b6) SME release and how can I check them?

[Michail Pappas]

1) Been receiving hourly logs of the following format:
[...]

It also seems liblber is missing as well. Should I install some packages? Should I kick the renegade web admin hard in the face? Both?

Run a yum update compat_openldap and system installed compat-openldap-2.3.43_2.2.29-12.el5_7.9.i386.rpm. Is that correct? Now ldd does not show anything missing in /usr/bin/dspam_stats:

Code: [Select]

# ldd /usr/bin/dspam_stats
        linux-gate.so.1 =>  (0xb7f24000)
        libdspam.so.7 => /usr/lib/libdspam.so.7 (0xb7f07000)
        libm.so.6 => /lib/libm.so.6 (0x005eb000)
        libdl.so.2 => /lib/libdl.so.2 (0x00616000)
        libldap-2.2.so.7 => /usr/lib/libldap-2.2.so.7 (0xb7ed1000)
        liblber-2.2.so.7 => /usr/lib/liblber-2.2.so.7 (0xb7ec3000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x006a7000)
        libc.so.6 => /lib/libc.so.6 (0x00490000)
        /lib/ld-linux.so.2 (0x00471000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x00839000)
        libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x009c4000)
        libssl.so.6 => /lib/libssl.so.6 (0x0097a000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x006c2000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x00805000)
        libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00875000)
        libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x008d3000)
        libcom_err.so.2 => /lib/libcom_err.so.2 (0x00642000)
        libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x008aa000)
        libz.so.1 => /lib/libz.so.1 (0x0064a000)
        libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x0086a000)
        libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x008a5000)
        libselinux.so.1 => /lib/libselinux.so.1 (0x0061d000)
        libsepol.so.1 => /lib/libsepol.so.1 (0x0065f000)

However, running  /etc/cron.hourly/dspam_check_training still throws an error:

Code: [Select]

# /etc/cron.hourly/dspam_check_training
/etc/cron.hourly/dspam_check_training: line 6: [: -eq: unary operator expected


[Stefano]

what's the output of

Code: [Select]

rpm -qf /etc/cron.hourly/dspam_check_training
?

[Michail Pappas]

Code: [Select]

sme-dspam-1.0.2-5
Seems like the lad that destroyed everything, also installed PHP 5.3.3 (ARGHHHHHHHHHHHHHHHH).

[Michail Pappas]

For the record I just disabled repository smeupdates-testing.

[gregswallow]

Do:

rpm -qa | grep el4

and:

yum --enablerepo=sme* list extras

to see what you have left over from SME7 on your system.  You may want to remove some contribs designed for SME7 or update them.

[Michail Pappas]

Code: [Select]

sme-dspam-1.0.2-5
Seems like the lad that destroyed everything, also installed PHP 5.3.3 (ARGHHHHHHHHHHHHHHHH).

Ok, digging a bit into /etc/cron.hourly/dspam_check_training :

Code: [Select]

cat /etc/cron.hourly/dspam_check_training
#!/bin/bash

LEFT=`/usr/bin/dspam_stats -H | /bin/grep TL | /bin/awk -F " " '{print $4}'`
ACTION=`/sbin/e-smith/config getprop dspam action`

if [ $LEFT -eq 0 ] && [ $ACTION == "train" ]; then
echo "DSPAM Training complete - switching to tagging mode.."
/sbin/e-smith/config setprop dspam action tag
/sbin/e-smith/signal-event email-update
fi
$LEFT above is empty. Running /usr/bin/dspam_stats -H from the command line, coredumps. Definitely something wrong here with the dependencies. Can you please compare your ldd for dspam_stats to mine?

[Michail Pappas]

Just saw your reply my friend. I have re-activated smeupdates-testing, as per your instructions in the php thread.

rpm -qa | grep el4

Code: [Select]

# rpm -qa | grep el4
perl-rrdtool-1.2.30-1.el4.rf
smeserver-sysmon-6.1-2.el4.sme
ocrad-0.17-1.el4.rf
perl-enum-1.016-1.2.el4.rf
perl-Tie-Cache-LRU-20081023.2116-1.el4.rf
perl-Geo-IP-1.38-1.el4.rf
perl-Net-Daemon-0.44-7.el4
gocr-0.44-1.el4.rf
perl-MLDBM-2.01-5.el4.1
perl-Tie-Cache-0.17-1.2.el4.rf
gifsicle-1.48-1.el4.rf
awstats-7.0-2.el4.rf
smeserver-phpmyadmin-2.11.1.2-3.el4.sme
perl-FreezeThaw-0.45-1.el4.rf
perl-MLDBM-Sync-0.30-1.2.el4.rf
perl-Log-Agent-0.307-1.el4.rf
smeserver-awstats-1.2-7.el4.sme
smeserver-mailstats-0.0.3-14.el4.sme
smeserver-php5-cgi-1.0-2.el4.sme
perl-PlRPC-0.2020-1.el4.rf
perl-Carp-Assert-0.20-1.el4.rf
perl-String-Approx-3.26-1.el4.rf
rrdtool-1.2.30-1.el4.rf
mysqlclient14-4.1.22-1.el4s1.1
phpmyadmin-2.11.11.3-2.el4.rf
fping-2.4-1.b2.3.el4.rf

Also:

Code: [Select]

# yum --enablerepo=sme* list extras
Loaded plugins: fastestmirror, protect-packages, smeserver
Loading mirror speeds from cached hostfile
 * base: ftp.otenet.gr
 * smeaddons: mirror.chiropratique.org
 * smecontribs: mirror.chiropratique.org
 * smedev: mirror.chiropratique.org
 * smeextras: mirror.chiropratique.org
 * smeos: mirror.chiropratique.org
 * smetest: mirror.chiropratique.org
 * smeupdates: mirror.chiropratique.org
 * smeupdates-testing: mirror.chiropratique.org
 * updates: ftp.otenet.gr
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Extra Packages
awstats.noarch                                                                   7.0-2.el4.rf                                                       installed
dspam.i386                                                                       3.9.0-sme7                                                         installed
fping.i386                                                                       2.4-1.b2.3.el4.rf                                                  installed
gifsicle.i386                                                                    1.48-1.el4.rf                                                      installed
gocr.i386                                                                        0.44-1.el4.rf                                                      installed
libdspam.i386                                                                    3.9.0-sme7                                                         installed
libdspam-mysql.i386                                                              3.9.0-sme7                                                         installed
mysqlclient14.i386                                                               4.1.22-1.el4s1.1                                                   installed
ocrad.i386                                                                       0.17-1.el4.rf                                                      installed
perl-Carp-Assert.noarch                                                          0.20-1.el4.rf                                                      installed
perl-FreezeThaw.noarch                                                           0.45-1.el4.rf                                                      installed
perl-Geo-IP.i386                                                                 1.38-1.el4.rf                                                      installed
perl-Log-Agent.noarch                                                            0.307-1.el4.rf                                                     installed
perl-MLDBM.noarch                                                                2.01-5.el4.1                                                       installed
perl-MLDBM-Sync.noarch                                                           0.30-1.2.el4.rf                                                    installed
perl-Net-Daemon.noarch                                                           0.44-7.el4                                                         installed
perl-PlRPC.noarch                                                                0.2020-1.el4.rf                                                    installed
perl-String-Approx.i386                                                          3.26-1.el4.rf                                                      installed
perl-Tie-Cache.noarch                                                            0.17-1.2.el4.rf                                                    installed
perl-Tie-Cache-LRU.noarch                                                        20081023.2116-1.el4.rf                                             installed
perl-enum.noarch                                                                 1.016-1.2.el4.rf                                                   installed
perl-rrdtool.i386                                                                1.2.30-1.el4.rf                                                    installed
phpmyadmin.noarch                                                                2.11.11.3-2.el4.rf                                                 installed
rrdtool.i386                                                                     1.2.30-1.el4.rf                                                    installed
sme-crontab_manager.noarch                                                       1.2-4                                                              installed
sme-dspam.noarch                                                                 1.0.2-5                                                            installed
sme-unjunkmgr.noarch                                                             1.1.3-1                                                            installed
smeserver-awstats.noarch                                                         1.2-7.el4.sme                                                      installed
smeserver-mailstats.noarch                                                       0.0.3-14.el4.sme                                                   installed
smeserver-php5-cgi.noarch                                                        1.0-2.el4.sme                                                      installed
smeserver-phpmyadmin.noarch                                                      2.11.1.2-3.el4.sme                                                 installed
smeserver-phpmyadmin-multiuser.noarch                                            2.11.9.2-1                                                         installed
smeserver-sysmon.noarch                                                          6.1-2.el4.sme                                                      installed

Being a newbie here, what could be safer-yet-more-elaborate-instructions on what to do next? Again, please apologize my ignorance. Been studying like crazy here, but I'm stepping into unknown territory here.

[Michail Pappas]

Went ahead and just deleted all these packages... There was no need for them in the first place, from what I can tell. Thank you for your help.

If possible, have a look at the original post of mine: any idea with regard to the SMTP issue?

[gregswallow]

Went ahead and just deleted all these packages... There was no need for them in the first place, from what I can tell. Thank you for your help.

If possible, have a look at the original post of mine: any idea with regard to the SMTP issue?

There was a change in the default settings for email.  Someone wrote up a wiki page about it - http://wiki.contribs.org/Email_-_Setting_up_E-mail_clients_for_SME_8.0

All those rpms you deleted look safe to delete (by doing 'yum remove ocrad gocr etc').  A bunch are from the FuzzyOcr spamassassin plugin that was in SME7 but not in SME8 and the rest are contribs and their dependencies. 

One other thing you can run to check if the other person with access added any custom templates is:

/sbin/e-smith/audittools/templates

[Michail Pappas]

There was a change in the default settings for email.  Someone wrote up a wiki page about it - http://wiki.contribs.org/Email_-_Setting_up_E-mail_clients_for_SME_8.0

That did the trick, thanks! Appreciated especially the info about permanently accepting the server certificate.

All those rpms you deleted look safe to delete (by doing 'yum remove ocrad gocr etc').

IIRC, uninstallation was performed with rpm -e <package> and not yum uninstall. Does this mean there are leftovers?

A bunch are from the FuzzyOcr spamassassin plugin that was in SME7 but not in SME8 and the rest are contribs and their dependencies. 

Yes, from what I can understand there was sysmon, awstats and some other stuff installed, whose elimination I do not really care about. I'm a bit worried about antispam though: in the things I uninstalled there were also dspam-related etc. Is there any chance I've damaged SME's antispam mechanism? Just asking since messages received from yesterday do indicated in headers that spam processing has been performed, however no spam has been catched so far...

One other thing you can run to check if the other person with access added any custom templates is:

/sbin/e-smith/audittools/templates

A modification to httpd.conf came up!

Thanks a zillion for all your valuable help!