[squid-users] FYI… Squid as MySql?

Hello!

I just wanted to share something interesting that just happened on my squid server.

I had rebooted my squid server and walked away for a bit. After returning, I noticed that squid wasn't working. I found out because I was not able to browse using the proxy. After looking through the cache.log, it seemed like squid should have been running. The cache.log file said "2012/02/08 00:18:58| Squid is already running! Process ID 1288". I did a "ps -ef | grep squid" and was not able to find anything. I also did a ps -ef | grep 1288 and no process with the number 1288 showed. Next I did a netstat -ntlp and did not see the server listening on port 3128. I wasn't sure where to look to see where this so called process ID 1288 was running.

After doing a bit of searching online, I ran into the tool called htop. I ran htop and I was able to see the process 1288. It said that it was mysql. I went ahead and killed that process and attempted to start squid again and it started up fine. Unfortunately I didn't save the info that htop provided to me. I found it kind of weird that this happened.

Anyways... I am using the following version of Squid on Ubuntu Server 11.10:

Squid Cache: Version 3.2.0.14-20120202-r11500
configure options: '--enable-ssl' '--enable-ssl-crtd'

Cache.log in case anyone wanted to see it.

2012/02/07 23:34:25 kid1| Starting Squid Cache version 3.2.0.14-20120202-r11500 for i686-pc-linux-gnu...
2012/02/07 23:34:25 kid1| Process ID 1288
2012/02/07 23:34:25 kid1| Process Roles: worker
2012/02/07 23:34:25 kid1| With 1024 file descriptors available
2012/02/07 23:34:25 kid1| Initializing IP Cache...
2012/02/07 23:34:25 kid1| DNS Socket created at [::], FD 7
2012/02/07 23:34:25 kid1| DNS Socket created at 0.0.0.0, FD 8
2012/02/07 23:34:25 kid1| Adding domain cfl.rr.com from /etc/resolv.conf
2012/02/07 23:34:25 kid1| Adding domain cfl.rr.com from /etc/resolv.conf
2012/02/07 23:34:25 kid1| Adding nameserver 192.168.2.1 from /etc/resolv.conf
2012/02/07 23:34:25 kid1| Adding nameserver 192.168.2.3 from /etc/resolv.conf
2012/02/07 23:34:25 kid1| helperOpenServers: Starting 5/32 'ssl_crtd' processes
2012/02/07 23:34:25 kid1| errorpage.cc(350) loadFromFile: '/usr/local/squid/share/errors/templates/MGR_INDEX': (2) No such file or directory
2012/02/07 23:34:25 kid1| WARNING: failed to find or read error text file MGR_INDEX
2012/02/07 23:34:25 kid1| Logfile: opening log /usr/local/squid/var/logs/access.log
2012/02/07 23:34:25 kid1| WARNING: log parameters now start with a module name. Use 'stdio:/usr/local/squid/var/logs/access.log'
2012/02/07 23:34:25 kid1| Store logging disabled
2012/02/07 23:34:25 kid1| Swap maxSize 0 + 262144 KB, estimated 20164 objects
2012/02/07 23:34:25 kid1| Target number of buckets: 1008
2012/02/07 23:34:25 kid1| Using 8192 Store buckets
2012/02/07 23:34:25 kid1| Max Mem size: 262144 KB
2012/02/07 23:34:25 kid1| Max Swap size: 0 KB
2012/02/07 23:34:25 kid1| Using Least Load store dir selection
2012/02/07 23:34:25 kid1| Set Current Directory to /usr/local/squid/var/cache/squid
2012/02/07 23:34:25 kid1| Loaded Icons.
2012/02/07 23:34:25 kid1| HTCP Disabled.
2012/02/07 23:34:25 kid1| Squid plugin modules loaded: 0
2012/02/07 23:34:25 kid1| Accepting SSL bumped HTTP Socket connections at local=192.168.2.1:3128 remote=[::] FD 20 flags=9
2012/02/07 23:34:26 kid1| storeLateRelease: released 0 objects
2012/02/08 00:18:58| Squid is already running! Process ID 1288
2012/02/08 02:30:43| Squid is already running! Process ID 1288
2012/02/08 02:32:44| Squid is already running! Process ID 1288
2012/02/08 02:34:55| Squid is already running! Process ID 1288
2012/02/08 03:08:45| Squid is already running! Process ID 1288
2012/02/08 03:09:42| Squid is already running! Process ID 1288
Received on Wed Feb 08 2012 - 08:37:38 MST