Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: Bob Todd on August 29, 2003, 11:01:27 PM
-
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.
-
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
-
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.
-
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
-
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
-
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.
-
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
-
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
-
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
-
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
-
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
-
> 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
-
That helped me, Matt. THANKS!