Thread: [ServOO-users] servooserver installation

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

<html><div style='background-color:'><DIV class=RTE>&nbsp;
Hi,
I had a lot of work to do so i let in stand by the installation of servooserver.
Now i'm trying to install it, but i have a problem. I can't log on the administration of servoo.
I tried to create an account via the DB, but i can't log on with this account to.
Here is what i do and the configuration i have. something might be wrong in the config.php file?
Thanks for give me a hand.
 
<H1 class=western lang=en-GB>Requirements</H1>
<UL>
<LI>
PHP 4.3.x or higher. Not tested with PHP 5.
<LI>
MySQL 3.23, 4.x or higher.
I have xampp installed with php4.3 and MySQL 4.
<LI>
Java run-time machine. Tested with J2SE© Sun and JRE for Linux (blackdown.org)
j2sdk1.4.1_08
<LI>
OpenOffice.org 1.1.1 or higher.
Oo 1.1.4
<LI>
PEAR package: SOAP and its dependencies.
Ok, the package is in servooserver\servoo\include
<LI>
Web server. Tested with Apache.
Apache (with xampp)</LI></UL>
<H1 class=western lang=en-GB>Installation</H1>
<H2 class=western lang=en-GB>Download</H2>
The ServOO archive is named servooserver-x.x.tar.gz and is available from <A href="http://sourceforge.net/project/showfiles.php?group_id=113878">Servoo project page</A> on SourceForge.net. Download the latest version.
Ok
<H2 class=western lang=en-GB>Extract the sources</H2>
Decompress and detar the archive in a temporary directory. Move or copy the servooserver/servoo directory into your web document root (with Mandrake distro it is /var/www/html).
tar zxf servooserver-0.0.1.tar.gz
cp -r servooserver/servoo /var/www/html
Ok, i have copied all the rpertory servooserver on my web document root
<H2 class=western>Install java, OpenOffice.org and PEAR/SOAP</H2>
Download and install a java machine, OpenOffice.org and PEAR/SOAP on the web server.
Suggested url for downloading these packages:
<A href="http://java.sun.com/j2se/1.4.2/download.html">http://java.sun.com/j2se/1.4.2/download.html</A>
<A href="http://blackdown.org/">http://blackdown.org</A>
<A href="http://www.openoffice.org/">http://www.openoffice.org/</A>
<A href="http://pear.php.net/package/SOAP">http://pear.php.net/package/SOAP</A>
 
Start the OpenOffice.org program and go to Tools/Options. Look for the Openoffice/Security entry. Select Run macro: Never and disable pluggins and applets. Note that these settings may be insufficient to ensure security. The PEAR packages must be installed in a directory listed in the PHP include_path or installed locally in the servoo/include directory.
ok
<H2 class=western lang=en-GB>Initialise the database</H2>
Create a new MySQL database named servoodb for instance. As root or as another authorized user:
mysqladmin create servoodb
Create the tables
mysql servoodb &lt;servoo/include/init.sql
Create MySQL user for the servoodb database and grant some privileges:
GRANT usage ON *.* TO servoouser@localhost IDENTIFIED BY 'chooseapasswd'
GRANT all ON servoodb.* TO servoouser@localhost
<H2 class=western>UI created a DB servoodb wich contains 4 table admins, log, session, user&nbsp;»</H2>
<H2 class=western lang=en-GB>Configure ServOO</H2>
Copy the servoo/config-dist.php file into servoo/config.php and edit it:
cd /var/www/html/servoo/
cp config-dist.php config.php
vi config.php
Fill the variables DATABASE, DBUSERNAME, DBPASSWD, DBHOST , JAVACMD, OOCLASSESPATH, OOFILEMASK and OOTMPDIR accordingly to your settings. 
My config.php file
 
# perturbate the password encoding.
define ("PASSWDSEED","");
 
# Database name
define("DATABASE","");
 
# Database username
define("DBUSERNAME","");
# Database user's password
define("DBPASSWD","");
# Database server hostname or ip
define("DBHOST","localhost");
 
# Table prefix
define("TP","");
 
# Webmaster email address to receive subscription information
define("WEBMASTER","");
 
# JAVA command
define("JAVACMD","/usr/java/j2sdk1.4.1_02/bin/java");
 
# working directory for OpenOffice.org
define("OOTMPDIR","/tmp");
# mask mode for file exchange between the web server and OOo.
define("OOFILEMASK",0777);
 
# directory to the OpenOffice JAVA classes.
define("OOCLASSESPATH","/usr/local/OpenOffice.org1.1.0/program/classes");
 
# timeout for the OO converter.
define("EXEC_TIMEOUT",30);
 
# log file when the documentconverter fail
define("EXEC_LOGFILE","/var/servoo/log");
 
# version d'OpenOffice
define("OPENOFFICEVERSION","1.1");
 
# message renvoie
define ("MESSAGEVERSION","Visit http://www.servoo.net");
 
# host surlequel est le serveur OpenOffice
define("OOHOST","localhost");
 
# port du serveur OpenOffice sur le host
define("OOPORT","9303");
 
# chemin relatif pour le repertoire d'include
define("TOINCLUDE","include/");
 
# URL contenant les fichiers communs partagés
# par exemple $shareurl="http://lodel.revues.org/share";
# la version sera ajoutee sur le dernier repertoire, donc la chaine ne doit pas se terminer par /
$shareurl="/share";
 
 
# Nom de la session (cookie)
define("SESSIONNAME","sessionservoo");
 
# Timeout pour les sessions
# en seconde
define("LOGINTIMEOUT",120*60);
 
 
ini_set("log_errors","1");
ini_set("display_errors","0");
ini_set("error_log","/tmp/servoo.err");
 
 
?&gt;
 
 
 
 
 
Give write access for the web server user (nobody, apache, or...) to servoo/CACHE and servoo/admin/CACHE directories:
chmod 770 servoo/CACHE servoo/admin/CACHE
or
chmod 777 servoo/CACHE servoo/admin/CACHE
Under windows, i allow write access
 
Opening write access may be a security issue. It is recommended to use sudo module for Apache or PHP as a CGI with correct group/users settings. For testing purpose, restrict web server access and use a firewall.
???
<H2 class=western>Testing</H2>
Test the configuration by creating a proper administrator.
A temporary administrator has been automatically created during the MySQL tables creation. Log on http://localhost/servoo/admin/ with username: admintmp and password: admintmp. Enter ServOO Administrator, create your administrator account and delete the admintmp administrator. Create also a first ServOO user, remember the login/password for setting in your web apps.
Problem, i can't log on the administration 
 
To use Servoo, launch OpenOffice.org in server mode:
soffice -accept="socket,host=localhost,port=9303;urp;StarOffice.ServiceManager"
Or use the servooserver/tools/startoo script.
When i run this script i have:
 <PRE lang=en-GB># Script for lauching OpenOffice.org in a development context only.
# See the servoo script for use in operational context.

<FONT color=#800000>soffice -accept="socket,host=localhost,port=9303;urp;StarOffice.ServiceManager"</FONT></PRE>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<H1 class=western><BR><BR></H1>
<P style="MARGIN-BOTTOM: 0cm" align=center><BR></P>
<H2 class=western lang=en-GB><BR><BR></H2>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P>
<P lang=en-GB style="MARGIN-BOTTOM: 0cm"><BR></P></DIV></div><br clear=all><hr>250 Mo de stockage  <a href="http://g.msn.com/8HMAFRFR/2740??PS=47575" target="_top">avec MSN Hotmail !</a> </html>

Thread: [ServOO-users] servooserver installation

servoo-users