[kronolith] Alarm
Chris
grooveman at comcast.net
Sat Feb 4 22:56:36 PST 2006
Addendum:
Horde is set to use mini_sendmail (since I am in chroot). I had to make
a link outside of the jail again, but not as you might expect. The
script didn't seem to like the mini_sendmail (I think it hit it with an
invalid flag), so I had to link to regular sendmail outside of the
jail. Then I had to make a warpper for mini_sendmail:
ln -s /usr/sbin/sendmail /bin/mini_sendmail
vi /etc/mailer.conf
(enter this line)
mini_sendmail /usr/libexec/sendmail/sendmail
This seemt to work like a charm. (Of course, you must still set up your
cron like Craig had mentioned earlier...)
Chris wrote:
>That link refers to the same problem, but no solution.
>
>But it is OK.
>
>I got it!
>
>It is a chroot jail issue (as I suspected). I will share my findings
>for posterity.
>
>My horde configruation points to /var/mysql/mysql.sock. Since I have
>horde running in the chroot jail, this is fine -- but the script runs
>from outside the jail, and looks for /var/mysql/mysql.sock and doesn't
>find it, because in reality the socket is in /var/www/var/mysql/mysql.sock.
>
>I created a symbolic link and it solved my problem: ln -s
>/var/www/var/mysql/mysql.sock /var/mysql/mysql.sock.
>
>I do appreciate the help though. Thank you.
>
>Chris.
>
>
>Time flies?
>
>
>
>
>
>
>Craig White wrote:
>
>
>
>>tempis fugit
>>
>>http://lists.horde.org/archives/kronolith/Week-of-Mon-20051114/005722.html
>>
>>Craig
>>
>>On Sat, 2006-02-04 at 21:59 -0700, Craig White wrote:
>>
>>
>>
>>
>>>I vaguely recall having to set up horde vfs for this to work (that's not
>>>on the wiki page though...hmmm)
>>>
>>>You might want to look at the archive of this list for the month of
>>>December or January.
>>>
>>>Also - did you verify that you have a cli version of php (per the link I
>>>sent you to) ? php -v
>>>
>>>The DB Error: connect failed is rather suspicious...did you check
>>>out /tmp/horde.log ? AFAIK, the reminders.php script should use the db
>>>settings in horde/config/conf.php so if the program can connect and
>>>read/write to db, the reminders.php should be able to as well.
>>>
>>>Craig
>>>
>>>(meant to send to list) - must need sleep...big game tomorrow
>>>
>>>On Sat, 2006-02-04 at 23:52 -0500, Chris wrote:
>>>
>>>
>>>
>>>
>>>>Thank you both for the reply, but unfortunately, it is still not working.
>>>>
>>>>I get the same error
>>>>------------------------------------------------------------------------------
>>>># which php
>>>>/usr/local/bin/php
>>>># /usr/local/bin/php -f
>>>>/var/www/htdocs/horde/kronolith/scripts/reminders.php
>>>>
>>>>A fatal error has occurred
>>>>
>>>>DB Error: connect failed
>>>>
>>>>Details have been logged for the administrator.
>>>>------------------------------------------------------------------------------
>>>>
>>>>I still cannot find any error output anywhere, so I am at a total loss here.
>>>>Again, my DB is up and running just fine, so why it states it cannot
>>>>connect is beyond me...
>>>>
>>>>Is there something else we can look at?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>Craig White wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Not easy replying to a top reply but...
>>>>>
>>>>>you need to execute it from php
>>>>>
>>>>>[root at srv1 ~]# which php
>>>>>/usr/bin/php
>>>>>[root at srv1 ~]# /usr/bin/php -f \
>>>>>/var/www/html/horde/kronolith/scripts/reminders.php
>>>>>X-Powered-By: PHP/4.3.9
>>>>>Content-Type: text/html; charset=ISO-8859-1
>>>>>
>>>>>[root at srv1 ~]#
>>>>>
>>>>>set it to a cron with a repeating interval.
>>>>>
>>>>># cat /var/spool/cron/apache
>>>>>0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46,48,50,52,54,56,58 * * * * \
>>>>>/usr/bin/php -f /var/www/html/horde/kronolith/scripts/reminders.php \
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>/dev/null 2>&1
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>HTH
>>>>>
>>>>>Craig
>>>>>
>>>>>On Sat, 2006-02-04 at 20:19 -0500, Chris wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Okay...
>>>>>>
>>>>>>I did find this in the archives. The way it was listed, it looked like
>>>>>>someone's
>>>>>>signature file, so I missed it the first time around.
>>>>>>
>>>>>>http://wiki.horde.org/KronolithReminders?referrer=HowTo
>>>>>><https://brokensolstice.com/horde/services/go.php?url=http%3A%2F%2Fwiki.horde.org%2FKronolithReminders%3Freferrer%3DHowTo>
>>>>>>
>>>>>>I tried to follow this, but it is a no-go.
>>>>>>
>>>>>>I log into my box via ssh, as root, I run: # php
>>>>>>./htdocs/horde/kronolith/scripts/reminders.php
>>>>>>It gives me:
>>>>>> A fatal error has occurred
>>>>>>
>>>>>> DB Error: connect failed
>>>>>>
>>>>>> Details have been logged for the administrator.
>>>>>>
>>>>>>My db is up and running just fine, and I cannot find where it would have
>>>>>>logged the
>>>>>>errors it mentioned. It isn't in /var/www/tmp/horde.log, it isn't in
>>>>>>/var/log/messages
>>>>>>or anywhere else I can find.
>>>>>>
>>>>>>Can someone please help?
>>>>>>
>>>>>>Thanks.
>>>>>>
>>>>>>Chris
>>>>>>
>>>>>>Craig White wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>On Sat, 2006-02-04 at 11:53 -0500, Chris wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>Hello.
>>>>>>>>
>>>>>>>>I have seen similar complaints of this in the archives, but have not
>>>>>>>>seen a solution.
>>>>>>>>
>>>>>>>>I am getting no indication what-so-ever from Kronolith when I have an
>>>>>>>>alarm set on a calendar item. I have tested this over and over. I get
>>>>>>>>no pop-up, I get no indicator on my calendar page or on my portal. I
>>>>>>>>get no email reminder.
>>>>>>>>
>>>>>>>>I have set up an account on my box called "reminder", and I tested it
>>>>>>>>using sendmail and mini_sendmail -- and it works. Yet I get nothing
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>from Kronolith. I have set up kronolith to use this account. Still
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>nothing.
>>>>>>>>
>>>>>>>>Ideally, I would like a pop-up reminder for alarms like outlook or
>>>>>>>>mozilla calendar would do. I do not know if Kronolith supports this
>>>>>>>>however.
>>>>>>>>
>>>>>>>>Failing that, I would like a message on my portal screen and calendar.
>>>>>>>>Failing those, an email reminder.
>>>>>>>>
>>>>>>>>I am running kronolith-h3-2.0.6 with horde-3.0.9. I am using the sql
>>>>>>>>back end (I don't even know what MCAL is...). I am running this on an
>>>>>>>>OpenBSD 3.8 system in a chroot Jail. Everything all my other horde
>>>>>>>>packages are now running great, and so does every other aspect of Kronolith.
>>>>>>>>
>>>>>>>>I see nothing unusual in my log files, Kronolith just seems to ignore
>>>>>>>>the alarm altogether.
>>>>>>>>
>>>>>>>>Can someone please help?
>>>>>>>>
>>>>>>>>Thank you.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>----
>>>>>>>http://wiki.horde.org/KronolithReminders?referrer=HowTo
>>>>>>>
>>>>>>>Craig
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>
>>
>>
>>
More information about the kronolith
mailing list