Postgresql / Tomcat Mod_JK / Ruby on Suse 9.3

[Ronny Görner]

Hi everyone,

there have been several problems with Plesk 8.0 on Suse 9.3 (32bit) which had to be solved.

Here we go:

If you want to use Tomcat with mod_jk to provide your webapplications in Apache, there is need to create a file called workers.properties in /etc/apache2 with the following content:


ps=/
worker.list=ajp13
worker.ajp13.port=9008
worker.ajp13.host=localhost
worker.ajp13.type=ajp13
worker.default.lbfactor=1

Also, at the end of /etc/apache/httpd.conf, the following modifications have to be done:

JkWorkersFile /etc/apache2/workers.properties
JkLogFile /var/log/apache2/mod_jk.log
JkLogLevel Debug


After a reload, mod_jk works perfect.

Also, if you want to use Ruby with mod_ruby, please install Ruby and mod_ruby and add the following lines after the mod_jk - parameters:

<IfModule mod_ruby.c>
RubyRequire apache/ruby-run

# Execute *.rbx files as Ruby scripts
<Files *.rbx>
SetHandler ruby-object
RubyHandler Apache::RubyRun.instance
</Files>
</IfModule>


In /etc/sysconfig/apache2 , add in the line starting with "APACHE_MODULES" ruby at the end.

After you did all changes, restart your webserver.


If you want to access your Postgresql-databases with PHP, you have to install php4-pgsql first. Simply hack yast - i php4-pgsql. After that, there is also a small modification to be done so that you can authentificate your databases with PHP:

open /var/lib/pgsql/data/pg_hba.conf

and change

# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser

to


# IPv4 local connections:
host all all 127.0.0.1/32 md5 sameuser


If you do not do this way, there will be error on error while connecting with PHP.

Enjoy.

Regards,
Ronny