Topic: Kronolith

[Bob Todd]

Been through all the stuff on here I can find and still cant get past the white screen when I click on the calendar button. From the log file I found this error

Aug 29 17:59:14 portal httpd: PHP Fatal error:  Call to undefined function:  iswarning() in /home/httpd/html/horde/kronolith/lib/Driver/sql.php on line 64

Looking at the file in question it seems to suggest its failing at the point where it tries to connect to the database but thats as far as my knowledge of Pear / SQL /PHP will take me.

Btw I have upgraded PHP and installed both the Pear Log and Date libraries.

[Craig Jensen]

Two things...

1. #pear install Date

and,

2. Configure Kronolith.  When it is installed as an addition to the upgrade, it must be configured... i.e. the .sql tables injected into the mysql database.

from the 'post-install' notes of the kronolith rpm:

# post-install instructions:
cat <<_EOF_
You must manually configure Kronolith and create any required database tables!
See "CONFIGURING Kronolith" in %{contentdir}/html/horde/kronolith/docs/INSTALL
You must also restart Apache with "service httpd restart"!
_EOF_

So, you must inject the table .sql into mysql...

mysqladmin > /home/httpd/html/horde/kronolith/scripts/drivers/kronolith.sql

This 'should' have your kronolith viewable... but, I found that I had consistent results if I also expanded all templates assoc with the php upgrade 'extras'... i.e. nag, kronolith, mnemo

So, to expand them:

/sbin/e-smith/expand-template /home/httpd/html/horde/kronolith/config/*

/sbin/e-smith/expand-template /home/httpd/html/horde/mnemo/config/*

/sbin/e-smith/expand-template /home/httpd/html/horde/nag/config/*

/sbin/e-smith/expand-template /home/httpd/html/horde/config/*

then, restart apache as mentioned above.

Now, in my /var/log/messages, kronolith was the only package specifically mentioned in error, so the other templates 'may' not need to be expanded.  But, it won't hurt to do so.

You can confirm that your .sql was inserted in the database by viewing them in phpmyadmin.

This 'seemed' (It has only been since yesterday... ) to have fixed my 'blank page' issue.

Hope this helps.

Craig Jensen

[Dan Brown]

The "signal-event horde-update" from my howto should expand all the necessary templates, and installing the e-smith-kronolith RPM _should_ create the mysql table as well.  If not, then it would seem I have a bug in my packages.

[Craig Jensen]

Dan Brown wrote:
>
> The "signal-event horde-update" from my howto should expand
> all the necessary templates, and installing the
> e-smith-kronolith RPM _should_ create the mysql table as
> well.  If not, then it would seem I have a bug in my packages.

I don't know if this is the case Dan, but, here's my experience:

SME5.6 U4

I upgraded to

php-4.3.2-2db -> all other packages installed corresponding to this version.  I also installed Kronolith, Mnemo, and Nag.

Installed the Pear Logs and Pear Date (as suggested for Kronolith).  At this point all seemed fine... except Kronolith.  I was getting blank pages.

So, as I viewed the source and noted the instructions to 'configure' Kronilith by injecting the Mysql table .sql file and re-expanding the templates, I did just that.  It was then, after having re-expanded the templates, installed the .sql, and re-started Apache, that I had a working (every time) Kronolith interface.

Since I did the two things together I cannot tell you in my case if only 'one' of the above (installing the .sql and expanding the templates) produced a working Kronolith... but it now works fine and I do not get Kronolith errors in my logs.


Craig Jensen

[Craig Jensen]

BTW, Dan I did notice that you have another fresh version... 4.3.3-1db  

Have you installed this version on any SME 5.6 boxes?  Just looking at the changelog... quite a number of bugfixes, etc.

I'll check it out later

Thanks for your continued developement of these packages!

Craig Jensen

[Dan Brown]

I have installed the 4.3.3 packages on my server, and so far they seem to be working--haven't had a lot of opportunity to test them, though.  I'm hoping they squash the open_basedir bug that's bitten me a few times.  So far, they seem to be better than 4.3.2 in that regard, but it's a little soon to say for sure.

[Bob Todd]

ok I injected the .sql file in case there was a problem with Dans rpm. I have expanded all the templates and restarted Apache. So far still get the same error message and a blank kronolith screen. Arghhhh

Thanks for the suggestions Craig

[Bob Todd]

These are the lines from 62 - 65 that seem to be the cause of the error in my log. Does this help track whats still causing me a problem?


/* Connect to the SQL server using the supplied parameters. */
            $this->db = &DB::connect($this->params, true);
            if (DB::isError($this->db) || DB::isWarning($this->db)) {
                Horde::fatal($this->db, __FILE__, __LINE

[Guck Puppy]

http://www.horde.org/faq/admin/trouble/index.php#t53

"After the release of Horde 2.1, the isWarning() function was removed from PEAR, resulting in this error when using a PHP/PEAR released after Horde 2.1 was released."

and then it lists solutions :
- Upgrade to a newer Horde (e.g. 2.2 or newer)

But I've already done that... as per

http://www.leiinc.com/repository/Linux/Mitel_SME_Server/HowToGuides/sme56_imp-horde-php_upgrade.htm

I'm running horde-2.2.1-1es

Does this move us forward? Hmm.

G

[Guck Puppy]

I decided to prune it.

file : /home/httpd/html/horde/kronolith/lib/Driver/sql.php

line 65 was :
if (DB::isError($this->db) || DB::isWarning($this->db)) {

becomes :
if (DB::isError($this->db)) {

Kronolith works again.

G

[Guck Puppy]

By the way, there are additional PEAR modules missing from my setup that Kronolith wants :

pear install HTML_Common
pear install HTML_Select

(those commands, as root, fixed me up)

G

[matt]

> e-smith-kronolith RPM _should_ create the mysql table as
> well. If not, then it would seem I have a bug in my packages.

I recieved an error:
You must also restart Apache with "service httpd restart"!
   8:e-smith-kronolith      ########################################### [
66%]
Loading 20kronolith.sql into mysql ERROR 1046 at line 3: No Database
Selected
[ FAILED ]


I had to :
mysql horde < /etc/e-smith/sql/init/20kronolith.sql
/sbin/e-smith/signal-event horde-update
/etc/rc.d/init.d/httpd restart

Don't know if that helps anyone.

Matt Bennett

[Bradster]

That helped me, Matt.  THANKS!