[kronolith] Alarm
Craig White
craigwhite at azapple.com
Sat Feb 4 21:41:30 PST 2006
probably should change vfs type to sql - that seems to matter.
adding /var/www to paths seems to be unlikely solution and likely to
cause you a lot more issues elsewhere - no reason to just start
wholesale changes because you don't know what you're doing.
again...I ask...
does php -v work?
what does /tmp/horde.log tell you?
Kevin suggested aligning things inside reminders.php with your actual
setup (IIRC, include path, log file location...) - hint...make a copy of
this file before you start hacking it just in case.
Craig
ps...we don't need/want to see your data. If you say that data is there,
I will believe you.
On Sun, 2006-02-05 at 00:37 -0500, Chris wrote:
> I see the same problem there, but no answers.
>
> I have a vfs configured:
> vfs
> I have my Kronolith tables:
> mysql> use horde ;
> mysql> show tables;
> +---------------------------+
> | Tables_in_horde |
> +---------------------------+
> | datatable_seq |
> | datatree_data_seq |
> | horde_datatree |
> | horde_datatree_attributes |
> | horde_datatree_seq |
> | horde_prefs |
> | horde_tokens |
> | horde_users |
> | horde_vfs |
> | kronolith_events |
> | kronolith_storage |
> | nag_tasks |
> | nag_tasks_seq |
> | turba_objects |
> +---------------------------+
> 16 rows in set (0.00 sec)
>
> My tables are very full of user data that would be too long and too
> personal to include.
> So, you see that both the vfs and the table structure are there, and
> perfoming nicely in all other respects.
>
> Could this have anything to do with the chroot environment? I'm
> wondering if a path configured in some conf file is set for my chroot
> environment, and the script is being called from outside the chroot
> environment. I have looked and tinkered, but I cannot find the
> problem... I have tried adding "/var/www" in front of any important
> looking paths in my conf files... but it doesn't seem to help.
>
>
>
>
> 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
> > > > > > MailScanner has detected a possible fraud attempt from "brokensolstice.com" claiming to be <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