1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Postgresql / Tomcat Mod_JK / Ruby on Suse 9.3

Discussion in 'Plesk for Linux - 8.x and Older' started by Ronny Görner, May 17, 2006.

  1. Ronny Görner

    Ronny Görner Guest

    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:


    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

    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 ident sameuser


    # IPv4 local connections:
    host all all md5 sameuser

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