[horde] Sweating Bullets!! Help!
Chris
I am in trouble here. I have had horde up and running beautifully for
about 3 months now. Now, all-of-a-sudden, it has become extremely
slow. Every time a page needs to load, it takes like 6 or 7 minutes!
This is bad news!
I am running Openbsd 3.8. I am using horde 3.0.9 with Imp 4.0.4, Ingo
1.0.2, Gollem 1.0.1(sql backend), Kronolith2.0.6, Turba 2.0.5 and Nag 2.0.4.
The machine is a Pentum IV 3.0ghz machine with 2 gigs of ram. I have
been watching Top for hours now, and the CPU never spikes above 5%. The
processes at the top are httpd and perl, and they are at 0%.
The hard drive is running great. fsck comes back with no errors, and
throughput is smokin'.
I have ruled-out imap, as I have configured a few mail clients, and it
works very smoothly and quickly. SMTP is likewise functioning normally.
The problem only occurs when hitting it from the web interface. I have
tried this on a machine directly next to this one, plugged into the same
switch and machines across the Internet -- no difference in
performance. All other servers on the same segment are performing as
normal. Not a network issue.
I had a small db error in my horde.log, but I restored my db, the error
is gone, but the problems persist.
This all started today without warning. No one has touched this box in
over a month. All log files I can think of look nominal. No
significant errors. I cannot find anything that could account for this!
I have rebooted, restarted apache a million times, restarted the db,
deleted and recreated the unix socket, cleared the tmp directory and
restored the database. Nothing seems to make a difference.
If I restart apache, I get about 20 seconds of normal behaviour on the
web client, after that, it suddenly degrades to 6-7 minutes lag per page.
HELP! I'm totally at a loss!
Thank you in advance.
Chris
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-un...@lists.horde.org
Craig White
big log files...they can really slow things down.
check the syslogs, apache logs, horde.log...
serving other web pages or db's out of that server? Check the speed on
them.
Craig
Chris
Craig White wrote:
I have scrapped all the log files in /var/www/tmp, /var/log and
/var/www/logs. I have run mysqlcheck with the --auto-repair switch as
well. No improvement.
There are no other databases on this server other than the horde
database. No other websites than the horde interface.
Anything else you can think of here?
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
Chris
---------------------------------------------------------------
Mar 28 20:03:21 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
Mar 28 20:03:39 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
Mar 28 20:03:39 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
Mar 28 20:03:40 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
Mar 28 20:03:40 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
Mar 28 20:03:40 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
Mar 28 20:03:51 HORDE [emergency] [horde] DB Error: connect failed:
[nativecode=Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
"/htdocs/horde/lib/Horde/DataTree/sql.php"]
--------------------------------------------------------------------------------
This error was present, then when I restored the db it disappeared. Now
it is back again. The restore was from 2 days ago... there were no
problems two days ago, so I am confused. Why am I seeing this again?
Any ideas?
Thanks.
Chris
Chris wrote:
>Thank you in advance.
>
>Chris
>
>
>
--
Bill Graham
--=_76qau18tg3gg
Content-Type: text/plain;
charset=ISO-8859-1;
format="flowed"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
How about /tmp/ ?
Like horde log
Bill
Quoting Chris <groo...@comcast.net>:
>
>
> Craig White wrote:
>> ----
>> big log files...they can really slow things down.
>>
>> check the syslogs, apache logs, horde.log...
>>
>> serving other web pages or db's out of that server? Check the speed on
>> them.
>>
>> Craig
>>
>>
>>
> I have scrapped all the log files in /var/www/tmp, /var/log and
> /var/www/logs. I have run mysqlcheck with the --auto-repair switch as
> well. No improvement.
>
> There are no other databases on this server other than the horde
> database. No other websites than the horde interface.
>
> Anything else you can think of here?
>
>
> --
> This address is soon to be defunct.
> If you are anyone at all important to me, please
> contact me, and I will get you my new email address.
> Thanks,
>
> Chris
>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-un...@lists.horde.org
>
--
Bill Graham
Systems Administrator
Hurley Public Schools
Hurley,SD 57036
USA
grah...@hurleybulldogs.com
----------------------------------------------------------------
This electronic mail sent from Hurley Public Schools - Hurley, South Dakota
http://www.hurleybulldogs.com
NOTICE: This E-mail (including attachments) is covered by the
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged. If you are not the intended
recipient, you are hereby notified that any retention, dissemination,
distribution, or copying of this communication is strictly prohibited.
Please reply to the sender that you have received the message in error,
then delete it. Thank you.
--=_76qau18tg3gg
Content-Type: application/pgp-keys
Content-Description: PGP Public Key
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
/QEjmQGiBEHULVIRBADwOvcUcfdgboeQPmglxZhMKz7YF5l2JR0bBu+hb8LI05Dj
NWsQrXiT/OP9d9vXmQfmQxr47S8ZQ50y8M4KasiuA6GcAOMTWLhxBkwV0gPYdh7z
wDnbzmVjVKvkxYQR2zMYnEoP5S92X6vyg9AooC7HXZ9tfflsXgFH/83kWFJ80wCg
2aUBjZiQ/yOhidKFiuRcan0HUiUEAOHg1gvAwJxl8J72u9zAVM7buNSSuAiPcDbY
5ME8QxpgwgDM7vie7IUdmSsEy0FG+2NhUcq1xmrISbQF2SsFwimSWhg3EIvPzSMI
1h/Boye2HfFPF3WksqMG0d4yPcoLyyM4KaueIw4tud34S2Ze4wQNDND060WOOFsg
WZOp315AA/4g16rrUbG4D2sZrbSoCktoZGIcKtwhNnI2JmrCnbH05qSWxUuELuOE
9+kGbB/XbeVH64XC8y0VRv65EbMkclcvbGwc8SFLE9ewzgV4xKE1WCTD9LQZtYyC
Ua2Dz8GYi5nWCbSeiJy+2dGgAGq/n0tGAnpy4fz+XyWMY3Rr/dIAIbQpQmlsbCBH
cmFoYW0gPGdyYWhhbWN3QGh1cmxleWJ1bGxkb2dzLmNvbT6IVwQTEQIAFwUCQdQt
UgULBwoDBAMVAwIDFgIBAheAAAoJEAIww5/l9sOOq+IAoNAU3yiRNMTtBq7Di6wD
zyEZYWEmAJ41lfVrPORjqJv8EpTCF7PwdhrrZbkBDQRB1C1TEAQAkMRgdyV/9JdI
DXapE/AyYNzafKAKNFs+guJbx8UwRsIgJgRPPZGUTmMH9PJMlQIT4IyZO5kvkSBX
uDgRo0dU9HWwHdk4Y+2tD8kHppOyp2nsRRFsgUEpp2JwOCttGcnT7mcFXA4zSk+M
cVFcUJBlD9LKM+G0bLu+4ruGISC8i3sAAwYD/35urfnOY2rBEb0g1HkNYAX/zKGI
XETREofpjMmiP6AHV1Ge6QuoWk8c4stI+TmQxRan7aaYhcXmqtH6J5zx8tj6Glcy
dh28RlzIxxHNU9N821y2DCITMSfXCdDeabAU4evyalu7OISXRSHzZQSO7jRCHnLg
vCjcG/ZE5Nii7jeziEYEGBECAAYFAkHULVMACgkQAjDDn+X2w46J2QCfWCgJb4z/
cb4aRPgZ8V/39KN19ZwAoJezABjaD19C/52TC4n9Kr1JDMwU
=qrYr
-----END PGP PUBLIC KEY BLOCK-----
--=_76qau18tg3gg
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-un...@lists.horde.org
--=_76qau18tg3gg--
ec...@encontacto.net
Why don't you run top in a term window and watch it while you are
waiting your 6 or 7 minutes and see what is eating your cpu cicles.
Apache will do this on ocasion.
ed
Chris
spikes more than 5%. It is not an issue of resources, that is for
sure... I have gobs of ram and CPU, the thing never breaks a sweat.
Any other ideas?
ec...@encontacto.net wrote:
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
--
Chris
I posted this already... but here it is again (so it shows in this
branch of the thread):
Any ideas?
Thanks.
Chris
Bill Graham wrote:
> How about /tmp/ ?
>
> Like horde log
>
> Bill
>
>
Gary W. Smith
I typically get error in my apps when MySQL is not running, but appears
to be. You said you restored the data back to MySQL and it fixed it.
But you say it breaks now. Are you saying that the old data becomes bad
or are you putting the bad data back in place?
If it's the later, how are you doing it? Are the tables recovered (or
in place) all owned by mysql?
What mysql processes do you see when you run ps?
Gary Wayne Smith
> ---------------------------------------------------------------
> Mar 28 20:03:21 HORDE [emergency] [horde] DB Error: connect failed:
> [nativecode=Can't connect to local MySQL server through socket
> '/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
> "/htdocs/horde/lib/Horde/DataTree/sql.php"]
> Mar 28 20:03:39 HORDE [emergency] [horde] DB Error: connect failed:
> [nativecode=Can't connect to local MySQL server through socket
> '/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
> "/htdocs/horde/lib/Horde/DataTree/sql.php"]
> Mar 28 20:03:39 HORDE [emergency] [horde] DB Error: connect failed:
> [nativecode=Can't connect to local MySQL server through socket
> '/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
> "/htdocs/horde/lib/Horde/DataTree/sql.php"]
>
Eric Jon Rostetter
> Okay -- My horde.log is now filling up with:
>
> ---------------------------------------------------------------
> Mar 28 20:03:21 HORDE [emergency] [horde] DB Error: connect failed:
> [nativecode=Can't connect to local MySQL server through socket
> '/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
> "/htdocs/horde/lib/Horde/DataTree/sql.php"]
Okay, you have some choices here...
1) You have fewer mysql connections allowed than you have apache
children allowed. Apache/php is using persistent connections (one
permanent connection to the DB for each apache child) and you are
running out of available processes.
Solution: Configure Horde not to use persistent connections (not
recommended) or configure mysql to allow at least as many connections
as apache can spawn children.
2) Your mysql server is getting hosed and hung. Can you query it via
another means when this is happening?
Solution: unknown.
3) Something else on your system is hosing the mysql socket.
Solution: fix whatever is broken.
4) Your horde history table has hit critical mass and needs to be trimed.
Solution: Update, trim, or empty your horde history table.
> This error was present, then when I restored the db it disappeared. Now
> it is back again. The restore was from 2 days ago... there were no
> problems two days ago, so I am confused. Why am I seeing this again?
You say it runs great for a few minutes after restarting apache. That would
be before apache spawns off a lot of children. Once apache gets enough
children, you could run out of mysql connections...
> Any ideas?
I'd bet you need more mysql connections, but then again, I don't
even run mysql, so what do I know.
>> The machine is a Pentum IV 3.0ghz machine with 2 gigs of ram. I have
>> been watching Top for hours now, and the CPU never spikes above 5%. The
>> processes at the top are httpd and perl, and they are at 0%.
There is absolutely no perl in Horde, so I'm not sure why you see perl
at all, since you said the machine runs nothing else.
--
Eric Rostetter
The Department of Physics
The University of Texas at Austin
Go Longhorns!
Chris
I wouldn't say it fixed it. It just made the errors go away. They
symptoms persist. Maybe the rrors had nothing to do with the
symptoms... I don't know.
I restored the db from a system backup. I untarred everything in
/var/mysql. I have done this from data 2 and 3 days old. Well before
any issues had arisen (this afternoon).
When I run ps -ax |grep mysql:
2956 C0- I 94:13.02 /usr/local/libexec/mysqld --socket
/var/www/var/run/mysql/mysql.sock -u _mysql
Here is everything from a "top":
Memory: Real: 101M/158M act/tot Free: 333M Swap: 0K/1024M used/tot
PID USERNAME PRI NICE SIZE RES STATE WAIT TIME CPU COMMAND
2956 _mysql 2 0 40M 17M sleep poll 94:17 0.00% mysqld
15988 root 2 0 1264K 1908K sleep select 1:06 0.00% sendmail
9282 www 2 0 2216K 5356K sleep select 0:54 0.00% httpd
30441 _vilter 2 0 984K 940K sleep poll 0:33 0.00%
smtp-vilter
13120 root 2 0 592K 676K sleep select 0:19 0.00% cron
12159 _vilter 2 0 13M 14M sleep poll 0:16 0.00% clamd
5357 root 2 0 19M 16M idle netcon 0:09 0.00% perl
4365 root 2 0 19M 16M idle netcon 0:09 0.00% perl
28320 _ntp 2 0 452K 624K idle poll 0:09 0.00% ntpd
20830 root 2 0 19M 16M idle netcon 0:08 0.00% perl
15333 root 2 0 19M 16M idle netcon 0:08 0.00% perl
17354 root 2 0 19M 16M idle netcon 0:07 0.00% perl
11681 _syslogd 2 0 416K 548K sleep poll 0:06 0.00% syslogd
20329 root 18 0 18M 17M idle pause 0:03 0.00% perl
20231 root 2 0 544K 1120K idle select 0:01 0.00% sshd
9989 root 2 0 3152K 2160K idle netio 0:00 0.00% sshd
31492 chris 2 0 3124K 1428K sleep select 0:00 0.00% sshd
7538 root 2 0 244K 784K idle netcon 0:00 0.00% saslauthd
30043 root 2 0 388K 524K idle netio 0:00 0.00% syslogd
16992 root 2 0 504K 620K idle poll 0:00 0.00% ntpd
1 root 10 0 292K 320K idle wait 0:00 0.00% init
16794 root 2 0 416K 560K idle select 0:00 0.00% inetd
7346 root 18 0 492K 516K idle pause 0:00 0.00% ksh
32721 root 28 0 400K 1060K onproc - 0:00 0.00% top
9561 root 3 0 556K 496K idle ttyin 0:00 0.00% ksh
11022 root 18 0 244K 364K idle lockf 0:00 0.00% saslauthd
26713 root 18 0 244K 364K idle lockf 0:00 0.00% saslauthd
23500 root 18 0 244K 364K idle lockf 0:00 0.00% saslauthd
29341 www 2 0 2320K 2176K idle netcon 0:00 0.00% httpd
12603 www 2 0 2320K 2036K idle netcon 0:00 0.00% httpd
25813 www 2 0 2324K 2040K idle netcon 0:00 0.00% httpd
4036 chris 18 0 592K 468K idle pause 0:00 0.00% ksh
21072 www 2 0 2216K 888K idle netcon 0:00 0.00% httpd
11977 root 3 0 372K 532K idle ttyin 0:00 0.00% getty
8635 root 3 0 256K 532K idle ttyin 0:00 0.00% getty
16707 root 3 0 204K 536K idle ttyin 0:00 0.00% getty
19082 root 3 0 180K 520K idle ttyin 0:00 0.00% getty
20946 root 2 0 736K 632K idle poll 0:00 0.00%
smtp-vilter
14499 www 2 0 2216K 888K idle netcon 0:00 0.00% httpd
26216 www 2 0 2216K 904K idle netcon 0:00 0.00% httpd
25290 root 18 0 244K 364K idle lockf 0:00 0.00% saslauthd
Thanks for your help.
Chris
Gary W. Smith wrote:
>Chris,
>
>I typically get error in my apps when MySQL is not running, but appears
>to be. You said you restored the data back to MySQL and it fixed it.
>But you say it breaks now. Are you saying that the old data becomes bad
>or are you putting the bad data back in place?
>
>If it's the later, how are you doing it? Are the tables recovered (or
>in place) all owned by mysql?
>
>What mysql processes do you see when you run ps?
>
>Gary Wayne Smith
>
>
>
>>---------------------------------------------------------------
>>Mar 28 20:03:21 HORDE [emergency] [horde] DB Error: connect failed:
>>[nativecode=Can't connect to local MySQL server through socket
>>'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
>>"/htdocs/horde/lib/Horde/DataTree/sql.php"]
>>Mar 28 20:03:39 HORDE [emergency] [horde] DB Error: connect failed:
>>[nativecode=Can't connect to local MySQL server through socket
>>'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
>>"/htdocs/horde/lib/Horde/DataTree/sql.php"]
>>Mar 28 20:03:39 HORDE [emergency] [horde] DB Error: connect failed:
>>[nativecode=Can't connect to local MySQL server through socket
>>'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
>>"/htdocs/horde/lib/Horde/DataTree/sql.php"]
>>
>>
>>
>
>
>
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
--
Chris
Pardon the in-line response... but it is just clearer this way...
Eric Jon Rostetter wrote:
>Quoting Chris <groo...@comcast.net>:
>
>
>
>>Okay -- My horde.log is now filling up with:
>>
>>---------------------------------------------------------------
>>Mar 28 20:03:21 HORDE [emergency] [horde] DB Error: connect failed:
>>[nativecode=Can't connect to local MySQL server through socket
>>'/var/run/mysql/mysql.sock' (2)] ** Array [on line 1329 of
>>"/htdocs/horde/lib/Horde/DataTree/sql.php"]
>>
>>
>
>Okay, you have some choices here...
>
>1) You have fewer mysql connections allowed than you have apache
>children allowed. Apache/php is using persistent connections (one
>permanent connection to the DB for each apache child) and you are
>running out of available processes.
>
>Solution: Configure Horde not to use persistent connections (not
>recommended) or configure mysql to allow at least as many connections
>as apache can spawn children.
>
>
>
I have increased max_connections to 250... wayyyyy more than httpd children.
>2) Your mysql server is getting hosed and hung. Can you query it via
>another means when this is happening?
>
>Solution: unknown.
>
>
>
Yes, I can query it just fine using mysql.
>3) Something else on your system is hosing the mysql socket.
>
>Solution: fix whatever is broken.
>
>
The socket looks fine, I have destroyed and recreated it a dozen times
now.. the perms are appropriate as well..
>4) Your horde history table has hit critical mass and needs to be trimed.
>
>
I have cleared out everything in horde_datatree where
group_id=horde.history (717 items).
>Solution: Update, trim, or empty your horde history table.
>
>
>
>>This error was present, then when I restored the db it disappeared. Now
>>it is back again. The restore was from 2 days ago... there were no
>>problems two days ago, so I am confused. Why am I seeing this again?
>>
>>
>
>You say it runs great for a few minutes after restarting apache. That would
>be before apache spawns off a lot of children. Once apache gets enough
>children, you could run out of mysql connections...
>
>
I don't think so, and certainly not with the max_connections=250
variable set. I am the only on on right now, and that is only one
connection....
>
>
>>Any ideas?
>>
>>
>
>I'd bet you need more mysql connections, but then again, I don't
>even run mysql, so what do I know.
>
>
>
>>>The machine is a Pentum IV 3.0ghz machine with 2 gigs of ram. I have
>>>been watching Top for hours now, and the CPU never spikes above 5%. The
>>>processes at the top are httpd and perl, and they are at 0%.
>>>
>>>
>
>There is absolutely no perl in Horde, so I'm not sure why you see perl
>at all, since you said the machine runs nothing else.
>
>
Yes, that much is probably true, but I do have smtp-vilter and clamd
running. They may.
So, unfortunately, I have done all you mention here, and the problem
persists...
I don't know what else I can do... am I screwed here?
Gary W. Smith
> -----Original Message-----
> >
> Yes, I can query it just fine using mysql.
>
Gary W. Smith
Jan Schneider
> Hi Gary,
>
> I wouldn't say it fixed it. It just made the errors go away. They
> symptoms persist. Maybe the rrors had nothing to do with the
> symptoms... I don't know.
>
> I restored the db from a system backup. I untarred everything in
> /var/mysql. I have done this from data 2 and 3 days old. Well before
> any issues had arisen (this afternoon).
>
> When I run ps -ax |grep mysql:
>
> 2956 C0- I 94:13.02 /usr/local/libexec/mysqld --socket
> /var/www/var/run/mysql/mysql.sock -u _mysql
Either the path to the socket is wrong (the error message said that
horde was trying to connect to var/run/mysql/mysql.sock), or you are
running Apache chrooted, which you should have mentioned. It might be
the default setup of OpenBSD, but it's still worth mentioning because
not everybody knows that.
Jan.
--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
Chris
Jan Schneider wrote:
>Zitat von Chris <groo...@comcast.net>:
>
>
>
>>Hi Gary,
>>
>>I wouldn't say it fixed it. It just made the errors go away. They
>>symptoms persist. Maybe the rrors had nothing to do with the
>>symptoms... I don't know.
>>
>>I restored the db from a system backup. I untarred everything in
>>/var/mysql. I have done this from data 2 and 3 days old. Well before
>>any issues had arisen (this afternoon).
>>
>>When I run ps -ax |grep mysql:
>>
>>2956 C0- I 94:13.02 /usr/local/libexec/mysqld --socket
>>/var/www/var/run/mysql/mysql.sock -u _mysql
>>
>>
>
>Either the path to the socket is wrong (the error message said that
>horde was trying to connect to var/run/mysql/mysql.sock), or you are
>running Apache chrooted, which you should have mentioned. It might be
>the default setup of OpenBSD, but it's still worth mentioning because
>not everybody knows that.
>
>Jan.
>
>
>
Yes, OBSD 3.8 runs chrooted by default, sorry I didn't mention, but I
didn't think it was significant here... but I gaurantee you, the path is
not wrong. I have been down that road at the time of setup (over 3
months ago). Remember, horde was running great until yesterday. The
socket hasn't changed, and the path has not changed. The socket is
there. If the path were wrong, the perms were bad or the socket were
deleted, horde wouldn't work at all. It works, it just takes 10 minutes
to load a page.
That is the frustrating thing, Nothing changed! It was running like a
top up until yesterday. I am the only one with admin access, and I
haven't touched configuration in a month. I am thinking something is
wrong with my datatree table... I have already trimmed out the history
from it... Is there something I can do to rebuild this table to test
this hypothesis?
Thanks.
Chris.
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
--
Chris
"mysql -u username -p horde". It picks up the socked from my.cnf and
the connection is good. You can specify the socket with the -S flag if
you want to be explicit. The results are the same.
Gary W. Smith wrote:
>Are you specifying localhost and the port in the config or the host ip?
>
>
>
>>-----Original Message-----
>>
>>
>>Yes, I can query it just fine using mysql.
>>
>>
>
>
>
>
--
Chris
machine in a month...
Gary W. Smith wrote:
>Out of curiosity, did you upgrade Apache or PHP recently?
>
>
>
>>-----Original Message-----
>>From: horde-...@lists.horde.org
>>
>>
>[mailto:horde-...@lists.horde.org]
>
>
>>On Behalf Of Gary W. Smith
>>Sent: Tuesday, March 28, 2006 8:18 PM
>>To: Chris; Eric Jon Rostetter
>>Cc: ho...@lists.horde.org
>>Subject: Re: [horde] Sweating Bullets!! Help!
>>
>>Are you specifying localhost and the port in the config or the host
>>
>>
>ip?
>
>
>>>-----Original Message-----
>>>
>>>
>>>Yes, I can query it just fine using mysql.
>>>
>>>
>>>
>>--
Barry Flanagan
>>
> Yes, OBSD 3.8 runs chrooted by default, sorry I didn't mention, but I
> didn't think it was significant here... but I gaurantee you, the path is
> not wrong. I have been down that road at the time of setup (over 3
> months ago). Remember, horde was running great until yesterday. The
> socket hasn't changed, and the path has not changed. The socket is
> there. If the path were wrong, the perms were bad or the socket were
> deleted, horde wouldn't work at all. It works, it just takes 10 minutes
> to load a page.
>
> That is the frustrating thing, Nothing changed! It was running like a
> top up until yesterday. I am the only one with admin access, and I
> haven't touched configuration in a month. I am thinking something is
> wrong with my datatree table... I have already trimmed out the history
> from it... Is there something I can do to rebuild this table to test
> this hypothesis?
>
Do you by any chance have external LDAP directories set up? I suffered
from slowness once which I tracked down to the fact that it was trying
to contact bigfoot but I had access to external LDAP ports blocked.
Nothing would happen until the request timed out.
Might be worth running a netstat on the box and see if there are any
connections trying to be established.
Hope this helps.
--
-Barry Flanagan
Andrew Morgan
serving your slow connection? strace is an excellent tool for debugging
processes that seems to be slow or hung.
Andy
Chris
I have done this. There are no unusual connections, and I do not use
LDAP....
Thanks though...
Barry Flanagan wrote:
>Chris wrote:
>
>
>
>>Yes, OBSD 3.8 runs chrooted by default, sorry I didn't mention, but I
>>didn't think it was significant here... but I gaurantee you, the path is
>>not wrong. I have been down that road at the time of setup (over 3
>>months ago). Remember, horde was running great until yesterday. The
>>socket hasn't changed, and the path has not changed. The socket is
>>there. If the path were wrong, the perms were bad or the socket were
>>deleted, horde wouldn't work at all. It works, it just takes 10 minutes
>>to load a page.
>>
>>That is the frustrating thing, Nothing changed! It was running like a
>>top up until yesterday. I am the only one with admin access, and I
>>haven't touched configuration in a month. I am thinking something is
>>wrong with my datatree table... I have already trimmed out the history
>>from it... Is there something I can do to rebuild this table to test
>>this hypothesis?
>>
>>
>>
>
>
>Do you by any chance have external LDAP directories set up? I suffered
>from slowness once which I tracked down to the fact that it was trying
>to contact bigfoot but I had access to external LDAP ports blocked.
>Nothing would happen until the request timed out.
>
>Might be worth running a netstat on the box and see if there are any
>connections trying to be established.
>
>Hope this helps.
>
>
>
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
--
Bo Daley
What are you using as your auth backend?
bo.
On Thu, 30 Mar 2006, Chris wrote:
> Hi Barry,
>
> I have done this. There are no unusual connections, and I do not use
> LDAP....
>
> Thanks though...
...
Chris
After three days of hair-loss and frustration, finally some progress.
To make a long story short, in desperation, I started tearing apart my
horde. I found that everything worked great, horde, nag, kronolith,
turba, ingo... until I added imp.
Imp is the culprit. I don't know why it suddenly decided to get
grumpy... but it is what is dragging my system down. I unpacked imp,
edited my servers.php, then logged in to change my configurations via
the gui, and bam -- instant slow-down. I restarted apache a few times
-- no help. Then, I removed imp, and bam -- it is running great... Very
strange. Of course, imp is the most critical application to have working!
I can access my Imap and smtp through my thick mail client and they are
nice and peppy. So no problems there...
I am hoping that I misconfigured something, although I cannot see what
(my brain is mush now). Here are my config files for imp:
Thank you all for your help... just a little more please.
servers.php
---------------------------------------------------------------
$servers['imap'] = array(
'name' => 'myserver.com',
'server' => 'localhost',
'hordeauth' => false,
'protocol' => 'imap/ssl/novalidate-cert',
'port' => 993,
'folders' => 'mail/',
'namespace' => '',
'maildomain' => 'myserver.com',
'smtphost' => 'localhost',
'smtpport' => 25,
'realm' => '',
'preferred' => '',
'dotfiles' => false,
'hierarchies' => array()
);
if ($GLOBALS['conf']['kolab']['enabled']) {
$servers['kolab'] = array(
'name' => 'Kolab Cyrus IMAP Server',
'server' => $GLOBALS['conf']['kolab']['imap']['server'],
'hordeauth' => 'full',
'protocol' => 'imap/notls/novalidate-cert',
'port' => $GLOBALS['conf']['kolab']['imap']['port'],
'folders' => '',
'namespace' => 'INBOX/',
'maildomain' => $GLOBALS['conf']['kolab']['imap']['maildomain'],
'realm' => '',
'preferred' => '',
'quota' => array(
'driver' => 'cyrus',
'params' => array(
'login' => $GLOBALS['conf']['kolab']['imap']['adminuser'],
'password' => $GLOBALS['conf']['kolab']['imap']['adminpw'],
'userhierarchy' => 'user.',
// Although these defaults are normally all that is
required,
// you can modify the following parameters from their
default
// values.
'protocol' => 'imap/notls/novalidate-cert',
'hostspec' => 'localhost',
'port' => 143
)
),
'acl' => array(
'driver' => 'rfc2086',
),
'dotfiles' => false,
'hierarchies' => array()
);
}
--------------------------------------------------------------------------------
conf.php (for imp)
-------------------------------------------------------------------------------
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: imp/config/conf.xml,v 1.53 2004/12/09 15:33:27 slusarz Exp $
$conf['utils']['spellchecker'] = '/usr/local/bin/aspell';
$conf['utils']['gnupg_keyserver'] = array('wwwkeys.pgp.net');
$conf['utils']['gnupg_timeout'] = '10';
$conf['utils']['openssl_cafile'] = '/somewhere/ca-bundle.crt';
$conf['utils']['openssl_binary'] = '/usr/bin/openssl';
$conf['menu']['apps'] = array('horde', 'imp', 'ingo', 'nag', 'turba');
$conf['user']['allow_folders'] = true;
$conf['user']['allow_view_source'] = true;
$conf['user']['allow_resume_all'] = false;
$conf['user']['allow_resume_all_in_drafts'] = false;
$conf['user']['alternate_login'] = false;
$conf['user']['redirect_on_logout'] = false;
$conf['user']['select_sentmail_folder'] = false;
$conf['server']['server_list'] = 'hidden';
$conf['server']['change_server'] = false;
$conf['server']['change_port'] = false;
$conf['server']['change_protocol'] = false;
$conf['server']['change_folders'] = false;
$conf['server']['sort_limit'] = '0';
$conf['server']['cache_folders'] = true;
$conf['mailbox']['show_attachments'] = true;
$conf['mailbox']['show_preview'] = true;
$conf['mailbox']['show_xpriority'] = false;
$conf['fetchmail']['show_account_colors'] = false;
$conf['fetchmail']['size_limit'] = '4000000';
$conf['msgsettings']['filtering']['words'] = './config/filter.txt';
$conf['msgsettings']['filtering']['replacement'] = '****';
$conf['spam']['reporting'] = false;
$conf['notspam']['reporting'] = false;
$conf['msg']['prepend_header'] = true;
$conf['msg']['append_trailer'] = false;
$conf['compose']['use_vfs'] = true;
$conf['compose']['allow_cc'] = true;
$conf['compose']['allow_bcc'] = true;
$conf['compose']['allow_receipts'] = true;
$conf['compose']['special_characters'] = false;
$conf['compose']['link_attachments'] = false;
$conf['compose']['add_maildomain_to_unexpandable'] = true;
$conf['compose']['attach_size_limit'] = '10485760';
$conf['compose']['attach_count_limit'] = '5';
$conf['hooks']['vinfo'] = false;
$conf['hooks']['signature'] = false;
$conf['hooks']['trailer'] = false;
$conf['hooks']['fetchmail_filter'] = false;
$conf['hooks']['mbox_redirect'] = false;
$conf['hooks']['mbox_icon'] = false;
$conf['hooks']['spam_bounce'] = false;
$conf['maillog']['use_maillog'] = true;
$conf['tasklist']['use_tasklist'] = true;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
-------------------------------------------------------------------
conf.php (for horde)
-------------------------------------------------------------------
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.14 2005/08/23 17:14:42
mrubinsk Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['tmpdir'] = '/tmp';
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['persistent'] = false;
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'XXXXX';
$conf['sql']['password'] = 'YYYYYY';
$conf['sql']['socket'] = '/var/run/mysql/mysql.sock';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('admin', 'joe');
$conf['auth']['checkip'] = true;
$conf['auth']['params']['driverconfig'] = 'horde';
$conf['auth']['params']['encryption'] = 'md5-hex';
$conf['auth']['params']['show_encryption'] = false;
$conf['auth']['driver'] = 'sql';
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_DEBUG;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = '/tmp/horde.log';
$conf['log']['params']['append'] = true;
$conf['log']['params']['mode'] = 01200;
$conf['log']['type'] = 'file';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['phptype'] = 'mysql';
$conf['datatree']['params']['persistent'] = false;
$conf['datatree']['params']['socket'] = '/var/run/mysql/mysql.sock';
$conf['datatree']['params']['protocol'] = 'unix';
$conf['datatree']['params']['hostspec'] = 'mx1.brokensolstice.com';
$conf['datatree']['params']['username'] = 'horde';
$conf['datatree']['params']['password'] = 'horde';
$conf['datatree']['params']['database'] = 'horde';
$conf['datatree']['params']['charset'] = 'iso-8859-1';
$conf['datatree']['params']['driverconfig'] = 'custom';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/bin/mini_sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';
$conf['sessionhandler']['type'] = 'none';
$conf['problems']['email'] = 'ad...@myserver.com';
$conf['menu']['always'] = true;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'all';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['weatherdotcom']['partner_id'] = 'xxxxx';
$conf['weatherdotcom']['license_key'] = 'yyyyy1';
$conf['fortune']['exec_path'] = '/usr/games/fortune';
$conf['kolab']['enabled'] = false;
$conf['imsp']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
------------------------------------------------------------
Note, I was using imp for authentication, but obviously I had to change
that to get rid of imp. When all is working again, I intend to return
to using imp for auth.
Thank you all again.
System Summary:
horde 3.0.9
nag 2.0.4
ingo 1.0.2
kronolith 2.0.6
turba 2.0.5
imp 4.0.4
php 4.4.0
apache 1.3.29 (chroot)
OpenBSD 3.8
Pentium IV 3.0 ghz
2GB ram
This box does nothing but mail... (sendmail, imap-uw, clamav,
smtpvilter, spamassassin).
Bo Daley wrote:
>What are you using as your auth backend?
>
>bo.
>
>On Thu, 30 Mar 2006, Chris wrote:
>
>
>
>>Hi Barry,
>>
>>I have done this. There are no unusual connections, and I do not use
>>LDAP....
>>
>>Thanks though...
>>
>>
>
>...
>
>
>
>
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
--
Patrice Levesque
--===============0345795218==
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="ikeVEW9yuYc//A+q"
Content-Disposition: inline
--ikeVEW9yuYc//A+q
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
> I can access my Imap and smtp through my thick mail client and they are
> nice and peppy. So no problems there...
I should investigate more before posting this, but I just experienced
unbearable slowness on my Horde setup when opening messages with IMP; seems=
the
culprit was the flag() function that took forever to return (in my case, it
took around 30 seconds to open a message); I commented out lines 591-594 in
imp/lib/Message.php and everything is snappy now (flags don't work anymore
though). Maybe (just maybe) this is related, worth trying.
Readers, don't count this as a bug report, I'll post a more complete
description if I find out if the culprit is really Horde/IMP.
The real tip here is that I found the problem in less than an hour using dbg
[ dd.cron.ru/dbg/ ], stepping the Horde/IMP http process. Maybe that after=
all
the guesswork in the last few days, time has come to get your hands in the =
real
dirt :(
--=20
--=3D=3D=3D=3D|=3D=3D=3D=3D--
--------=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D--------
Patrice Levesque
http://ptaff.ca/
horde...@ptaff.ca
--------=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D--------
--=3D=3D=3D=3D|=3D=3D=3D=3D--
--
--ikeVEW9yuYc//A+q
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
iD8DBQFELKmnGV7PdpISpDIRAuaQAKCoxwNPNBE9HZjFMirP2OdKt+t35ACeN77t
OkP7aNxh3SFaycGiP8H6SOw=
=O0Xl
-----END PGP SIGNATURE-----
--ikeVEW9yuYc//A+q--
--===============0345795218==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-un...@lists.horde.org
--===============0345795218==--
Jan Schneider
> conf.php (for imp)
> -------------------------------------------------------------------------------
> /* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
> // $Horde: imp/config/conf.xml,v 1.53 2004/12/09 15:33:27 slusarz Exp $
This is not a configuration file from IMP 4.0.4.
Jan.
--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
--
Chris
Are you referring to the date? That is what was generated by the setup
GUI.... I certainly didn't put that in myself. It was generated and
dumped to ~/horde/imp/config/conf.php...
Jan Schneider wrote:
> Zitat von Chris <groo...@comcast.net>:
>
>> conf.php (for imp)
>> -------------------------------------------------------------------------------
>>
>> /* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
>> // $Horde: imp/config/conf.xml,v 1.53 2004/12/09 15:33:27 slusarz Exp $
>
>
> This is not a configuration file from IMP 4.0.4.
>
> Jan.
>
--
This address is soon to be defunct.
If you are anyone at all important to me, please
contact me, and I will get you my new email address.
Thanks,
Chris
--
Han Spruyt
Quoting Chris <groo...@comcast.net>:
> What do you mean, Jan?
>
> Are you referring to the date? That is what was generated by the setup
> GUI.... I certainly didn't put that in myself. It was generated and
> dumped to ~/horde/imp/config/conf.php...
>
>
The base for conf.php is conf.xml. When conf.xml is for an old version
you will not create an up to date conf.php in the GUI.
Han.
groo...@comcast.net
What do you suggest I do? Last night, I downloaded 4.1, and gave that a shot. The same problem occurred. As soon as it was configured, it dragged all of horde down. 10 minutes a page load. This is unbearable... 3 days of downtime! The conf file was dated 2006/01/14, but the problem persisted. I don't particularly want to upgrade to 4.1, but I wanted to at least see if it gave me the same kind of trouble. It did.
Any help is appreciated.
Thank you.
Chris
The conf.php for the test 4.1 was:
--------------------------------
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: imp/config/conf.xml,v 1.53.2.9 2006/01/14 16:52:34 ericr Exp $
$conf['utils']['spellchecker'] = '/usr/local/bin/aspell';
$conf['utils']['gnupg_keyserver'] = array('wwwkeys.pgp.net');
$conf['utils']['gnupg_timeout'] = '10';
$conf['menu']['apps'] = array();
$conf['user']['allow_view_source'] = true;
$conf['user']['allow_resume_all'] = false;
$conf['user']['allow_resume_all_in_drafts'] = false;
$conf['user']['select_sentmail_folder'] = false;
$conf['user']['allow_folders'] = true;
$conf['user']['alternate_login'] = false;
$conf['user']['redirect_on_logout'] = false;
$conf['server']['server_list'] = 'shown';
$conf['server']['sort_limit'] = '0';
$conf['server']['cache_folders'] = false;
$conf['server']['cache_msgbody'] = false;
$conf['mailbox']['show_attachments'] = false;
$conf['mailbox']['show_preview'] = false;
$conf['mailbox']['show_xpriority'] = false;
$conf['fetchmail']['show_account_colors'] = false;
$conf['fetchmail']['size_limit'] = '4000000';
$conf['msgsettings']['filtering']['words'] = './config/filter.txt';
$conf['msgsettings']['filtering']['replacement'] = '****';
$conf['spam']['reporting'] = false;
$conf['notspam']['reporting'] = false;
$conf['msg']['prepend_header'] = true;
$conf['msg']['append_trailer'] = true;
$conf['compose']['allow_cc'] = true;
$conf['compose']['allow_bcc'] = true;
$conf['compose']['allow_receipts'] = true;
$conf['compose']['special_characters'] = true;
$conf['compose']['use_vfs'] = false;
$conf['compose']['link_attachments'] = false;
$conf['compose']['add_maildomain_to_unexpandable'] = true;
$conf['compose']['attach_size_limit'] = '10485760';
$conf['compose']['attach_count_limit'] = '5';
$conf['hooks']['vinfo'] = false;
$conf['hooks']['signature'] = false;
$conf['hooks']['trailer'] = false;
$conf['hooks']['fetchmail_filter'] = false;
$conf['hooks']['mbox_redirect'] = false;
$conf['hooks']['mbox_icon'] = false;
$conf['hooks']['spam_bounce'] = false;
$conf['maillog']['use_maillog'] = true;
$conf['tasklist']['use_tasklist'] = true;
$conf['notepad']['use_notepad'] = true;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
---------------------------------------------------
Jan Schneider
> But whatever version of conf.xml I have came from the 4.0.4 tarball.
> It had to. That was the version of imp I started with. I never
> performed an upgrade. Should I post my conf.xml? Would that be
> helpful?
No, it was my fault, I looked at the wrong IMP version.
Jan.
--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
--