Shared object "libldap-2.4.so.2" not found

firstzerg · Apr 17, 2015, 10:15 AM

Has anyone solved the problem?
Found one solution for me.
After entering the command in pfsense console

/usr/local/bin/squidGuard -v

Squid starts until reboot

trahajopro86 · Apr 21, 2015, 1:02 PM

@firstzerg:

Has anyone solved the problem?
Found one solution for me.
After entering the command in pfsense console
/usr/local/bin/squidGuard -v
Squid starts until reboot

Thanks for that info. This has been driving me crazy. I'm a BSD noob. Is there somewhere I can put this command to run at startup?

Does everyone with 2.2.2 see this problem? It doesn't seem like 'everyone' is seeing it. Is it the way I installed?

thanks

-Tracy

firstzerg · Apr 21, 2015, 2:01 PM

@trahajopro86:

Is there somewhere I can put this command to run at startup?

I tried put this script:```
#!/bin/sh

rc_start() {
/usr/local/bin/squidGuard -v
}

rc_stop() {
/usr/bin/killall squidGuard
}

case $1 in
start)
rc_start
;;
stop)
rc_stop
;;
restart)
rc_stop
rc_start
;;
esac

in **/usr/local/etc/rc.d/squidguard.sh**
this worked before pfSense 2.2.2

firstzerg · Apr 23, 2015, 6:00 PM

Found temporary solution:

upload to pfsense squidguard.sh and setup.sh files
and exec command```
chmod +x setup.sh && ./setup.sh && reboot


**squidguard.sh**

#!/bin/sh

rc_start() {
/usr/local/bin/squidGuard -v
}

rc_stop() {
/usr/bin/killall squidGuard
}

case $1 in
start)
rc_start
;;
stop)
rc_stop
;;
restart)
rc_stop
rc_start
;;
esac


**setup.sh**

#!/bin/sh
arch=$(uname -p)
chmod 0755 squidguard.sh
mv squidguard.sh /usr/local/etc/rc.d/squidguard.sh
sed 's/^.*squidGuard</executable>/<rcfile>squidguard.sh</rcfile>
&/' /cf/conf/config.xml > /cf/conf/config.xml.new
mv /cf/conf/config.xml /cf/conf/config.xml.old
mv /cf/conf/config.xml.new /cf/conf/config.xml</rcfile>


this will start squidguard.sh on boot

trahajopro86 · Apr 23, 2015, 5:17 PM

I tried this and now I can't connect to my box. I am remote so I can't see what is on the screen and I can't connect via ssh or webui. I will check it and report back when I get home.

Here are my steps.

1. created squidguard.sh and setup.sh in /usr/local/etc/rc.d/ (I'm guessing I shouldn't have done this)
2. executed chmod +x setup.sh && ./setup.sh && reboot
3. Tried connecting to webui and got error "RCFILE at line 1242 cannot occur more than once"
4. Connected via ssh and moved squidguard.sh and setup.sh from /usr/local/etc/rc.d/ to /tmp
5. executed chmod +x setup.sh && ./setup.sh && reboot
6. cant connect via web or ssh. … assuming my config got squished?

-Tracy

firstzerg · Apr 23, 2015, 6:19 PM

@trahajopro86:

I tried this and now I can't connect to my box. I am remote so I can't see what is on the screen and I can't connect via ssh or webui. I will check it and report back when I get home.

Here are my steps.

1. created squidguard.sh and setup.sh in /usr/local/etc/rc.d/ (I'm guessing I shouldn't have done this)
2. executed chmod +x setup.sh && ./setup.sh && reboot
3. Tried connecting to webui and got error "RCFILE at line 1242 cannot occur more than once"
4. Connected via ssh and moved squidguard.sh and setup.sh from /usr/local/etc/rc.d/ to /tmp
5. executed chmod +x setup.sh && ./setup.sh && reboot
6. cant connect via web or ssh. … assuming my config got squished?

-Tracy

setup.sh and squidguard.sh must be not in /usr/local/etc/rc.d/
setup.sh make changes in pfsense config and must be launched only one time

instead setup.sh you may do manualy next steps:
1. create /usr/local/etc/rc.d/squidguard.sh
2. chmod +x /usr/local/etc/rc.d/squidguard.sh
3. find this text in /cf/conf/config.xml

                <service><name>squidGuard</name>

                        <executable>squidGuard</executable></service>

and add line <rcfile>squidguard.sh</rcfile> like this

                <service><name>squidGuard</name>

                        <rcfile>squidguard.sh</rcfile>
                        <executable>squidGuard</executable></service>

4. reboot

@trahajopro86:

6. cant connect via web or ssh. … assuming my config got squished?

multiple execution of setup.sh duplicated line <rcfile>squidguard.sh</rcfile> in you config.xml file

P.S.
some backups of you config.xml you can find in /cf/conf/backup

trahajopro86 · Apr 24, 2015, 2:41 PM

I was able to get back to a good state by restoring a backup config.xml from /cf/conf/backup.

After that I created setup.sh and squidguard.sh in /temp and executed setup. It looks like it worked like a champ this time. I rebooted and squiq/squidguard started up as expected.

Thanks for all your help firstzerg!

-Tracy

gaborozzo · Apr 26, 2015, 1:48 PM

@alxbob:

Try rebuilding blacklist db apply save and reboot!

Hello,

I had the same problem (missing libldap-2.4.so.2) after upgrading squidGuard to 1.4.7 (1.9.14). For me rebuilding the blacklist database solved the problem.

Thank you!
Gabor

tong · Apr 27, 2015, 8:45 PM

@gaborozzo:

@alxbob:

Try rebuilding blacklist db apply save and reboot!

Hello,

I had the same problem (missing libldap-2.4.so.2) after upgrading squidGuard to 1.4.7 (1.9.14). For me rebuilding the blacklist database solved the problem.

Thank you!
Gabor

Rebuilding the DB worked for me too, don;t know if it will survive a reboot but it got back up to running.

digifant · Apr 30, 2015, 6:41 PM

Not working here; I can rebuild the DB and squid/squidguard start. After a reboot they don't .

stephenw10 · May 2, 2015, 7:43 PM

This can be worked around by creating and enabling at least one custom target category. For some reason if you're using downloaded blacklists only the required file/folder isn't created and at boot Squidguard fails to start filling the squid logs in cache.log with this error.
We had to do some testing on this during the week for a customer and I was seeing this exact symptom. Jim found this workaround.
This happens on both Squid 2.7 and 3.

Steve

firstzerg · May 4, 2015, 7:16 AM

@stephenw10:

This can be worked around by creating and enabling at least one custom target category.

Really working (after reboot too) after creating at custom target category!
Thanks.

alper · May 8, 2015, 1:50 PM

@stephenw10:

This can be worked around by creating and enabling at least one custom target category. …

Yes, it fixed same error for me, thanks.

jaapb · May 8, 2015, 3:12 PM

First post and using pfsense now for a year but at a dead end trying to find a solution for not getting squidguard to work on my Pfsense box (2.2.2 64bit).
The following shows up in cache.log:

2015/05/07 20:57:40 kid1| Starting Squid Cache version 3.4.10 for amd64-portbld-freebsd10.1…Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
Shared object "libdb41.so.1" not found, required by "squidGuard"
2015/05/07 20:57:40 kid1| WARNING: redirector #Hlpr0 exited
FATAL: The redirector helpers are crashing too rapidly, need help!
Squid Cache (Version 3.4.10): Terminated abnormally.

CPU Usage: 0.305 seconds = 0.196 user + 0.110 sys
Maximum Resident Size: 154768 KB
Page faults with physical i/o: 0

I already tried to create a custom target category it still doesn’t work. Also reinstalling Squidguard with and without prior de-installing it is not helping.
Not trying to hijack this thread but my cache.log looks very similar to OP’s observation. Thank you all for helping.

Jaap

stephenw10 · May 8, 2015, 3:16 PM

You have added the category to the common ACLs and set it to allow/deny?
The system log is full of the squid 'help respawing too fast' errors?

Steve

jaapb · May 8, 2015, 5:05 PM

Hi Steve,

Thanks for answering. I added a whitelist category set to whitelist and a blacklist category set to deny showing on top of the list according to this article .

Jaap

stephenw10 · May 8, 2015, 8:01 PM

That should do it.
What Squid and Squidguard versions are you running?

Steve

jaapb · May 9, 2015, 3:03 PM

@stephenw10:

What Squid and Squidguard versions are you running?

Hi, Steve

Running Squid 3.4.10 pkg 0.2.8 and squidguard 1.4.7. pkg 1.9.14 on 2.2.2 64 bit. Didn't use squidguard devel because pkg manager mentions it is working with squid 2.x only.

Jaap

stephenw10 · May 9, 2015, 5:07 PM

Hmm, I installed that same combination on Thursday to a fresh 2.2.2 install and it's running fine. It was 32bit but if anything that's the less well tested branch.
I just booted it now and it all comes up fine. Even ClamAV. What hardware are you running it on? Ram? Disk size?

Steve

jaapb · May 10, 2015, 4:43 PM

@stephenw10:

What hardware are you running it on? Ram? Disk size?

Steve,

Squid by itself runs fine (AV included) as soon as squidguard is installed the drama happens, no internet connection with squid in transparant mode. Squid tries to restart but fails filling the log as posted earlier.
My hardware:
2 CPUs: 1 package(s) x 2 core(s), Intel(R) Atom(TM) CPU D2500 @ 1.86GHz . 4Gig RAM, 250 Gig HDD.
Dual Intel NIC.
Thanks,

Jaap