Re: [ServOO-users] servooserver installation

[Luc S. <luc...@lo...>]

Hi,

felipe _ a écrit :
>  
> 
> 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.
> 
> 
> 
>   Requirements
> 
>     *
> 
>       PHP 4.3.x or higher. Not tested with PHP 5.
> 
>     *
> 
>       MySQL 3.23, 4.x or higher.
> 
>       I have xampp installed with php4.3 and MySQL 4.

I'm not sure the servooserver works with xampp... we haven't made any test with this platform.


> 
>     *
> 
>       Java run-time machine. Tested with J2SE© Sun and JRE for Linux
>       (blackdown.org)
> 
>       *j2sdk1.4.1_08*

we're using j2sdk1.4.1_02..

> 
>     *
> 
>       OpenOffice.org 1.1.1 or higher.
> 
>       Oo 1.1.4
> 
>     *
> 
>       PEAR package: SOAP and its dependencies.
> 
>       Ok, the package is in servooserver\servoo\include
> 
>     *
> 
>       Web server. Tested with Apache.
> 
>       Apache (with xampp)
> 
> 
>   Installation
> 
> 
>     Download
> 
> The ServOO archive is named servooserver-x.x.tar.gz and is available
> from Servoo project page
> <http://sourceforge.net/project/showfiles.php?group_id=113878> on
> SourceForge.net. Download the latest version.
> 
> Ok
> 
> 
>     Extract the sources
> 
> 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
> 
> 
>     Install java, OpenOffice.org and PEAR/SOAP
> 
> Download and install a java machine, OpenOffice.org and PEAR/SOAP on the
> web server.
> 
> Suggested url for downloading these packages:
> 
> http://java.sun.com/j2se/1.4.2/download.html
> 
> http://blackdown.org <http://blackdown.org/>
> 
> http://www.openoffice.org/
> 
> http://pear.php.net/package/SOAP
> 
> 
> 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
> 
> 
>     Initialise the database
> 
> Create a new MySQL database named servoodb for instance. As root or as
> another authorized user:
> 
> mysqladmin create servoodb
> 
> Create the tables
> 
> mysql servoodb <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
> 
> 
>     UI created a DB servoodb wich contains 4 table “admins, log,
>     session, user »
> 
> 
>     Configure ServOO
> 
> 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");
> 
> 
> 
> ?>
> 
> 
> 
> 
> 
> 
> 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.
> 
> ???
> 
> 
>     Testing
> 
> 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

can you check in your database (tables "users") that you have a user defined

what you can do, just for test purpose, is modify the code to accept anybody connecting to
the admin interface

> 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:
> 
> 
> # Script for lauching OpenOffice.org in a development context only.
> # See the servoo script for use in operational context.
> 
> soffice -accept="socket,host=localhost,port=9303;urp;StarOffice.ServiceManager"

maybe your only problem, is the use of servooserver on a Windows system.
ok, it is not written on the requirements, but, we should add this info.

Luc