Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: jader on February 15, 2004, 02:43:26 PM

Title: installing new module: Kronolith/nag = just a blank screen
Post by: jader on February 15, 2004, 02:43:26 PM
I have followed http://www.leiinc.com/repository/Linux/Mitel_SME_Server/HowToGuides/sme56_imp-horde-php_upgrade.htm to upgrade everything.
Have to change from:
pear install Log
to
pear download Log-1.6.7.tgz
pear install Log-1.6.7.tgz

everything else worked!

But I'm getting a blank screen when clicking on Calend (kronolith) icon!
I went to /var/log/messages and saw:
Feb 15 10:37:41 aguia httpd: PHP Warning:  main(Date/Calc.php): failed to open stream: No such file or directory in /home/http
d/html/horde/kronolith/lib/base.php on line 55
Feb 15 10:37:41 aguia httpd: PHP Fatal error:  main(): Failed opening required 'Date/Calc.php' (include_path='.:/usr/share/pea
r') in /home/httpd/html/horde/kronolith/lib/base.php on line 55
[root@aguia log]#

but I can find anywhere Date/Calc.php and /lib/base.php appears to be there!


Any tips?

Thanks!
Title: installing new module: Kronolith/nag = just a blank screen
Post by: ergozd on February 15, 2004, 02:51:04 PM
I think you will have to install Date.

type
# pear install Date
Title: what version of Date
Post by: jader on February 15, 2004, 04:55:57 PM
What version of Date?

As above I have to install version 1.6.7 or Log because others fail on dependency check!

Could you please verify what version of Date do you have installed?

Thanks!

Jáder
Title: Tested: Installed Date
Post by: jader on February 15, 2004, 05:06:06 PM
I have installed Date with: pear install Date
See below:

[root@aguia root]# pear install Date
downloading Date-1.4.tgz ...
...done: 39,002 bytes
install ok: Date 1.4
[root@aguia root]#  /sbin/e-smith/signal-event horde-update
[root@aguia root]# service httpd restart
Stopping httpd:                                            [   OK   ]

Starting httpd:                                            [   OK   ]

[root@aguia root]# tail -f /var/log/messages
Feb 15 12:57:11 aguia e-smith[1775]: S70conf-turba=action|Event|horde-update|Action|S70conf-turba|Start|1076860630 879012|End|1076860631 436197|Elapsed|0.557185
Feb 15 12:57:12 aguia httpd-e-smith: httpd startup succeeded
Feb 15 12:57:12 aguia e-smith-bg: Starting httpd: [   OK   ]^M
Feb 15 12:57:37 aguia httpd: PHP Fatal error:  Call to undefined function:  iswarning() in /home/httpd/html/horde/kronolith/lib/Driver/sql.php on line 64

Now I have a different error message... it was a step forward! Thanks!
Any other tips?
Title: installing new module: Kronolith/nag = just a blank screen
Post by: ergozd on February 15, 2004, 06:57:10 PM
I am not really sure if that's the case BUT I think it is a PEAR related issue.

Are you sure you have the right php.ini settings...

Your /etc/php.ini has
include_path = ".:/usr/share/pear"
Title: installing new module: Kronolith/nag = just a blank screen
Post by: ergozd on February 15, 2004, 07:01:07 PM
Don't forget to check you mysql preferences... If I don't remember wrong user "horde" 's password was changed on v6.
Title: problem: ...Driver/sql.php
Post by: jader on February 15, 2004, 08:30:18 PM
I have php.ini changed to point to pear instead of php...And as I'm using SME 5.6 upd 6 horde password has no changed! (I hope).

Seems like Horde cannot access kronolith_events database. But I used mysql command line to access it and everything worked.

I don't know where to start from here... I did a search in Google for error message and do not got any usefull links!
Title: DB connection error
Post by: jader on February 15, 2004, 09:07:33 PM
I went to Driver/sql.php file to search on line 64!
line 62: /* Connect to the SQL server using the supplied parameters. */
line 63: $this->db = &DB::connect($this->params, true);
line 64: if (DB::isError($this->db) || DB::isWarning($this->db)) {
line 65: Horde::fatal($this->db, __FILE__, __LINE__);
 

Seems like a DB connection problem...
Title: installing new module: Kronolith/nag = just a blank screen
Post by: ergozd on February 16, 2004, 10:29:21 AM
Check you

# /home/httpd/html/horde/kronolith/config/conf.php file toi make sure that your mysql settings are ok.

You can also upgrade your pear by

# pear upgrade-all
Title: check mysql settings
Post by: jader on February 16, 2004, 11:44:57 AM
I could check mysql setting...but I think if I had a problem with it, nothing will work at all.Not just Kronolith.

And I´m afraid of do a pear upgrade all.
If I try to install last version of Log (pear install Log) as per instructions page I get an sqlite dependencies failure!

Do you have kronolith working? If yes, could you please send me your conf.php file of kronolith?
I think Kronolith database access is the key!
Thanks!

Jáder
Title: installing new module: Kronolith/nag = just a blank screen
Post by: ergozd on February 17, 2004, 09:48:20 AM
I run
- SME 6.0 final
- Horde 2.2.3
- IMP 3.2.1
- Kronolith

and yes, it works.  :-)

Here comes my conf.php for kronolith

------------------------------------------------------
<?php
/**
 * Kronolith Configuration File
 *
 * This file contains global configuration settings for Kronolith. Values
 * may be safely edited by hand. Use conf.php.dist as a reference.
 *
 * Strings should be enclosed in 'quotes'.
 * Integers should be given literally (without quotes).
 * Boolean values may be true or false (no quotes).
 *
 * $Horde: kronolith/config/conf.php.dist,v 1.29.2.3 2003/04/04 19:23:54 chuck Exp $
 */


/**
 ** Calendar Driver Settings
 **/

// What calendar backend is being used? Right now, the only options are
// 'mcal' and 'sql', but others may appear at some point in the future.
$conf['calendar']['driver'] = 'sql';

// What MCAL driver is being used? 'mstore' is the local file driver,
// and is the only one with extensive testing. There is also an ICAP
// driver, and theoretically an ICAP server, but Kronolith has not
// been tested with them.
$conf['calendar']['params']['driver'] = 'mstore';

// The mstore driver requires a username and a password that is in
// /etc/mpasswd in order to access local calendars.
$conf['calendar']['params']['username'] = '';
$conf['calendar']['params']['password'] = '';

// This is an example configuration for an sql driver, in this case MySQL.
$conf['calendar']['params']['phptype'] = 'mysql';
$conf['calendar']['params']['hostspec'] = 'localhost';
$conf['calendar']['params']['username'] = '*******';
$conf['calendar']['params']['password'] = '*******';
$conf['calendar']['params']['database'] = 'horde';
$conf['calendar']['params']['table'] = 'kronolith_events';


/**
 ** Metadata Settings
 **/

// If this is true, then an array of keywords will be read from
// config/keywords.php and you will be able to assign any or all of
// them to events.
$conf['metadata']['keywords'] = false;


/**
 ** Menu settings
 **/

// Should we display a Import/Export link in the Horde application
// menus?
$conf['menu']['import_export'] = true;

// This is an array of applications (using the names defined in
// horde/config/registry.php) to include links to in the menubar. An
// example providing a link to Turba (an addressbook program) would
// be: $conf['menu']['apps'] = array('turba');
$conf['menu']['apps'] = array('imp','turba','mnemo','nag');

-----------------------------------------------------
Another issue is your registry.php in
#/home/httpd/html/horde/config
Make sure that you've got the setting for kronolith
-----------------------------------------------------
$this->applications['kronolith'] = array(
    'fileroot' => dirname(__FILE__) . '/../kronolith',
    'webroot' => $this->applications['horde']['webroot'] . '/kronolith',
    'icon' => $this->applications['horde']['webroot'] . '/kronolith/graphics/kronolith.gif',
    'name' => _("Calendar"),
    'allow_guests' => false,
    'status' => 'active'
);
-----------------------------------------------------
I hope this helps. good luck.
Title: installing new module: Kronolith/nag = just a blank screen
Post by: Jáder on February 17, 2004, 10:56:52 AM
Everything seems ok... just do not work :)

The only difference it that I don´t have a **** as horde password. :)
In  v5.6 horde user/password is horde.Right ?
I can see the same (horde as user/pwd) on nag conf.php file!

Maybe a permission issue? Maybe my files on directory are with wrong user/group?
I saw a message from someone who issue chmod 777 for everything on kronolith!!

Thanks!
Title: installing new module: Kronolith/nag = just a blank screen
Post by: ergozd on February 17, 2004, 11:02:30 AM
MySQL user horde has oassword horde in 5.6 so you're correct.

I am not sure (dont' think) it's the permissions...

Well, that's all the help I can offer. Maybe you can contact Dan Brown himself, it's his contribs.

PS : Have to ask one thing to be on the safe side  ;-) ... You know that you have to restart you httpd service after modifying php.ini.
Title: installing new module: Kronolith/nag = just a blank screen
Post by: Jáder on February 17, 2004, 11:07:19 AM
>Well, that's all the help I can offer.
Thanks a lot for you continued support!

>Maybe you can contact Dan Brown himself, it's his contribs.
I already have done it. I answered once... I point it to this thread... and I´m waiting for more help!


>PS : Have to ask one thing to be on the safe side  ... You know that you have to restart you httpd service after modifying php.ini.
YES! And this is a test server. I can shutdown it any time!
I have done several reboots since I started with problems! But thanks by remember me! :)
Title: iswarning()
Post by: DanB35 on February 17, 2004, 05:16:00 PM
Jader, is this still the error you're getting?
Quote

Feb 15 12:57:37 aguia httpd: PHP Fatal error: Call to undefined function: iswarning() in /home/httpd/html/horde/kronolith/lib/Driver/sql.php on line 64

If so, I'm not sure where it's coming from, but it isn't related to an SQL username/password.  Try grepping for iswarning in your horde installation--where else does it appear?
Title: grepping for isWarning
Post by: Jáder on February 18, 2004, 12:00:11 AM
Hi

Because I was unable to find isWarning in other places than this 2 below:

./docs/CHANGES:[jan] Remove deprecated DB::isWarning() calls.
./kronolith/lib/Driver/sql.php:            if (DB::isError($this->db) || DB::isWarning($this->db)) {

AND one of them say deprecated...

I take a decision: comment out that line!
So I did as below:


            /* Connect to the SQL server using the supplied parameters. */
            $this->db = &DB::connect($this->params, true);
/* Jader comment... will this fix it??
            if (DB::isError($this->db) || DB::isWarning($this->db)) {
                Horde::fatal($this->db, __FILE__, __LINE__);
            }
end of Jáder comment */

            /* Enable the "portability" option. */
            $this->db->setOption('optimize', 'portability');

            $this->connected = true;
        }

        return true;
    }


Voilá! Now I can enter in Kronolith... BUT
I cannot register anything...
See my /var/log/messages:

Feb 17 19:39:24 aguia sshd[1853]: Accepted password for root from 192.168.13.50 port 4302
Feb 17 19:39:24 aguia sshd(pam_unix)[1855]: session opened for user root by (uid=0)
Fev 17 19:55:08 aguia httpd: PHP Warning:  html(HTML/Select.php): failed to open stream: Arquivo ou di
retório não encontrado in /home/httpd/html/horde/kronolith/lib/Event.php on line 452
Fev 17 19:55:08 aguia httpd: PHP Warning:  html(): Failed opening 'HTML/Select.php' for inclusion (inc
lude_path='.:/usr/share/pear') in /home/httpd/html/horde/kronolith/lib/Event.php on line 452
Fev 17 19:55:08 aguia httpd: PHP Fatal error:  Cannot instantiate non-existent class:  html_select in
/home/httpd/html/horde/kronolith/lib/Event.php on line 453
Fev 17 19:55:33 aguia httpd: PHP Warning:  html(HTML/Select.php): failed to open stream: Arquivo ou di
retório não encontrado in /home/httpd/html/horde/kronolith/lib/Event.php on line 452
Fev 17 19:55:33 aguia httpd: PHP Warning:  html(): Failed opening 'HTML/Select.php' for inclusion (inc
lude_path='.:/usr/share/pear') in /home/httpd/html/horde/kronolith/lib/Event.php on line 452
Fev 17 19:55:33 aguia httpd: PHP Fatal error:  Cannot instantiate non-existent class:  html_select in
/home/httpd/html/horde/kronolith/lib/Event.php on line 453
Feb 17 19:57:21 aguia sshd[1919]: Accepted password for root from 192.168.13.50 port 4339


I´m still getting errors... this Event.php file on line 452 has a include to a  Select.php file that I was unable to find!



Can I have a broken Kronolith rpm ?
Where I can get one updated?
I have installed:

[root@aguia root]# rpm -qa|grep kronolith
kronolith-1.0-1es
e-smith-kronolith-0.8.1-01db
[root@aguia root]#

Thanks by all help!
Title: installing new module: Kronolith/nag = just a blank screen
Post by: DanB35 on February 25, 2004, 11:45:06 PM
I don't think you have a "broken" kronolith RPM, but what you're seeing looks pretty strange to me.  Are you sure that the sql.php file you modified came with the RPM?

I'd say it looks like the Select.php file that it's looking for is part of another PEAR class called HTML.  Do you have that installed?  If not, try installing it.

I've used this RPM under SME 5.6, but not under any later version.
Title: reformat??
Post by: Jáder on February 26, 2004, 01:50:25 AM
Dan

I think I´ll reformat and start over...

I have a SME 5.6 with patch 6 and PHP upgrade from the above link... I don´t know WHAT is going wrong... or why!

I know that I cannot do anymore:pear install Log
It don´t work (read above to see message!)
So I do pear download Log-1.6.7.tgz (as above!)
and pear install Log-1.6.7.tgz ...
and my problems started to happen!

Could you please verify that the howto (and update it if this is the case)still is valid for you (I don´t know if you have a spare machine like me...)

Or just say what Is should to do and I´ll reformat my HDD and start from scratch again! :D

Thanks by your patience...

Jáder
Title: installing new module: Kronolith/nag = just a blank screen
Post by: DanB35 on February 27, 2004, 09:40:09 PM
Just noticed something--you're using Kronolith 1.0?  I have an RPM out (since July) of 1.1.  I think that may be the problem--sorry that hadn't clicked for me earlier.
Title: now with Kronolith 1.1
Post by: Jáder on March 01, 2004, 12:13:49 PM
Dan,

I have reformated and reinstalled from scratch...
NOTHING!

I´m still using pear download Log-1.6.7.tgz and pear install Log-1.6.7.tgz.

Anda after install Kronolith (1.1) and nag rpms I get NAG working but kronolith not!

Here is my /var/log/messages:

Mar  1 05:11:54 aguia HORDE[1218]: [imp] Login success for admin@abandonemicrosoft.com [192.168.13.50] to {localhost:143} [on line 83 of "/home/httpd/html/horde/imp/redirect.php"]
Mar  1 05:12:11 aguia httpd: PHP Warning:  main(Date/Calc.php): failed to open stream: Arquivo ou diretório não encontrado in /home/httpd/html/horde/kronolith/lib/base.php on line 63
Mar  1 05:12:11 aguia httpd: PHP Fatal error:  main(): Failed opening required 'Date/Calc.php' (include_path='.:/usr/share/pear') in /home/httpd/html/horde/kronolith/lib/base.php on line 63

:( I´ll try fix it tonight (now it´s time to go to work!) :)

Thanks
Jáder
Title: new reinstall
Post by: Jáder on March 09, 2004, 01:18:26 AM
I reinstalled everything:
SME 5.6 updt 6
PHP upgrade
Kronolith 1.1 this time...

pear download log-1.6.7
pear install log-1.6.7
pear install Date
/sbin/e-smith/signal-event horde-update

login on webmail=ok
click on calendar=ok (show screen)
create new event :(     don´t work!

I don´t get any error...that I can find at least!
But nothing changes!

Anyone can help me?
An new howto would be fine...
Or just tell me what version of each file you have if you have a SME5.6u6...

I can reinstall this server each time to test... no problem...

Thanks

Jáder
Title: Solved!!!! Kronolith was not saving events
Post by: Jáder on March 12, 2004, 01:52:03 AM
Hello everyone!

After a long research using google I found other people with same problem as me: Kronolith was not working!

One person suggested running the script to create kronolith database again, I do it using:
"
mysql horde < /home/httpd/html/horde/kronolith/scripts/drivers/kronolith.sql
"

and everything appears to work.
I was able to create events and update/modify them!

I´m thinking about to update the HowTo about this... if his owner don´t mind!

Thanks for everyone who try to help!

Jáder
Title: installing new module: Kronolith/nag = just a blank screen
Post by: brad on March 12, 2004, 02:18:21 AM
Have you tried upgrading the Horde Framework.  I had this problem on a different linux server and it solved the problem of getting other apps working.
Title: installing new module: Kronolith/nag = just a blank screen
Post by: Jáder on March 14, 2004, 10:58:08 PM
I'm a complete newbie. So I just do as described above. No GREAT NEW ideas... too risky to me :)

But now it's working... almost perfect!
I'm getting an warning about allow_resume_all in navbar.inc line 19 !!!