[ansel] Setting up Horde3 on Debian GNU/Linux Squeeze

Thu Jan 19 20:11:41 UTC 2012

Hi,

I'm trying to setup horde3 on my home server, that running Debian
GNU/Linux Squeeze. On this server was installed the so called
bubba-horde package that is from the
http://update.excito.org/pool/main/b/bubba-horde/ repository. 

The bubba-horde package was purged and after that was installed the
horde3 debian package from the Debian official repository.

I'm following instructions from
/usr/share/doc/horde3/README.Debian.gz

I have so far setup the followings:
 1. Configuring the web server
 sudo nano /etc/apache2/sites-enabled/000-default

The lines bellow was in this file already, probably after I installed horde3:

   Alias /horde3 /usr/share/horde3
   <Directory /usr/share/horde3>
       Options FollowSymLinks
       AllowOverride Limit
       deny from all
       allow from 192.168.10.90
   </Directory>
   <Files ~ "\.(inc|bak)$">
       deny from all
   </Files>

I must only to changed the line:
allow from My IP address
to
allow from 192.168.10.90

This IP address is that that my desktop machine get from the server's
dhcp-server. It's always the same IP address, because on my home LAN my
desktop machine is the only system so far.

 sudo nano /etc/apache2/httpd.conf
AddType application/x-httpd-php .php
DirectoryIndex index.php
php_flag session.auto_start Off

 sudo nano /etc/php5/apache2/php.ini
memory_limit 128 MB
upload_max_filesize 15 MB

 sudo /etc/init.d/apache2 restart
 sudo /etc/init.d/apache2 restart

 2. Creating databases
 Creating the preferences storage container
 ls /usr/share/doc/horde3-base/examples/scripts/sql
Is in the
/usr/share/doc/horde3-base/examples/scripts/sql directory there a
create script for my database that is actually  mysql?

ls /usr/share/doc/horde3-base/examples/scripts/sql
Yes, there is the
create.mysql.sql.gz

in which one can read
-- If you are installing Horde for the first time, you can simply
-- direct this file to mysql as STDIN:
--
-- $ mysql --user=root --password=<MySQL-root-password> < create.mysql.sql

 mysql --user=root --password=<MySQL-root-password> < create.mysql.sql

cd /usr/share/doc/horde3-base/examples/scripts/sql
sudo gzip -d create.mysql.sql.gz

sudo nano /usr/share/doc/horde3-base/examples/scripts/sql/create.mysql.sql
USE mysql;

REPLACE INTO user (host, user, password)
    VALUES (
        'localhost',
        'horde',
-- IMPORTANT: Change this password.
        PASSWORD('password')
);

I edited here the password only.

mysql --user=root --password=<MySQL-root-password> < create.mysql.sql

 I verified the existence of horde database
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| horde              |
| mysql              |
+--------------------+

 3. Configuring Horde
 sudo nano /etc/horde/horde3/conf.php
Here I should delete lines
exit (0)
and the echo line above it
but can't find these.

Only for the time being installing horde
sudo chown -R www-data.www-data /etc/horde/horde3

 http://192.168.10.1/horde3
Now when I trying to open this webpage from my desktop machine on the
LAN behind the server on which have installed and setup horde3, I get
error message:

Not Found

The requested URL /login.php was not found on this server.
Apache/2.2.16 (Debian) Server at 192.168.10.1 Port 80

It seems as if apache looks for login.php in the web root, not in
the horde directory (should be /horde3/login.php). 

I edited the file so:
$this->applications['horde'] = array(
    'fileroot' => '/usr/share/horde3/lib' . '/..',
//    'webroot' => _detect_webroot(),
    'webroot' => '/horde3',
    'initial_page' => 'login.php',
    'name' => _("Horde"),
    'status' => 'active',
    'templates' => '/usr/share/horde3/lib' . '/../templates',
    'provides' => 'horde',
);

I did run
sudo /etc/init.d/apache2 restart

to restart my Apache2 server and try to open the webpage
http://192.168.10.1/horde3/ 
but never get it opened. Iceweasel webbrowser says in the status line
something like: Waiting for 192.168.10.1...

In the address field of the Iceweasel browser there is:
http://192.168.10.1/horde3/login.php?Horde=8qrg5u0qi8tq5s5nkequ0uk3c5

In the apache2 access.log I find:
192.168.10.90 - - [18/Jan/2012:19:36:25 +0100] "GET
/horde3/login.php?url=%2Fhorde3%2Fservices%2Fportal%2Fsidebar.php\
%3FHorde%3Dp1ith4ilo11q1mspackfiput02&nosidebar=1&\
horde_logout_token=xhl4L4_QEJL-KH5PtnetwNbxyD4&app=horde&\
Horde=p1ith4ilo11q1mspackfiput02HTTP/1.1" 200 1047\
"http://192.168.10.1/horde3/login.php?Horde=c7ouu58j3q6iuaa53ts1q9emr6"
"Mozilla/5.0 (X11; Linux x86_64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1\
Iceweasel/9.0.1" 

In the apache2 error.log there is an error:
[Wed Jan 18 19:34:10 2012] [error] [client 192.168.10.90] PHP
Deprecated:  Assigning the return value of new by reference is
deprecated in /usr/share/horde3/lib/Horde/Prefs.php on line 847,
referer:
http://192.168.10.1/horde3/login.php?url=%2Fhorde3%2Fservices%\
2Fportal%2Fsidebar.php%3FHorde%3Dn6tvksp8qqoe16vteck3muotg6&\
nosidebar=1&horde_logout_token=U6VumRHQBtPLv5Zmjc6QB3vVUlM&\
app=horde&Horde=n6tvksp8qqoe16vteck3muotg6

How can I solve this problem to get a functional Horde application?

I don't want to install horde4 on my Debian GNU/Linux Squeeze, I want
to solve the problem with horde3 on this system.

Any advices will be appreciated!

-- 
Regards from Pal
<http://cspl.me>