Re: [ServOO-users] servooserver installation

[Ghislain <ghi...@lo...>]

Hi Felipe,

I have been quite busy too and didn't catch you were still trying to=
=20
install servoo. We don't know if servoo works on Windows but it shoul=
d.=20
At least, the problems you have currently seems not caused by windows=
.=20
The DB is not configured in the config.php, there is no way it works.=
 I=20
suggest you do again step by step the install procedure. If you have=
=20
never used mysql before, you may first read about it.
I need to know more about you experience in Un*x before helping you f=
urther.

Regars,

Ghislain




felipe _ wrote:
> =20
>=20
> Hi,
>=20
> I had a lot of work to do so i let in stand by the installation of=
=20
> servooserver.
>=20
> Now i'm trying to install it, but i have a problem. I can't log on =
the=20
> administration of servoo.
>=20
> I tried to create an account via the DB, but i can't log on with th=
is=20
> account to.
>=20
> Here is what i do and the configuration i have. something might be =
wrong=20
> in the config.php file?
>=20
> Thanks for give me a hand.
>=20
>=20
>=20
>   Requirements
>=20
>     *
>=20
>       PHP 4.3.x or higher. Not tested with PHP 5.
>=20
>     *
>=20
>       MySQL 3.23, 4.x or higher.
>=20
>       I have xampp installed with php4.3 and MySQL 4.
>=20
>     *
>=20
>       Java run-time machine. Tested with J2SE=A9 Sun and JRE for Li=
nux
>       (blackdown.org)
>=20
>       *j2sdk1.4.1_08*
>=20
>     *
>=20
>       OpenOffice.org 1.1.1 or higher.
>=20
>       Oo 1.1.4
>=20
>     *
>=20
>       PEAR package: SOAP and its dependencies.
>=20
>       Ok, the package is in servooserver\servoo\include
>=20
>     *
>=20
>       Web server. Tested with Apache.
>=20
>       Apache (with xampp)
>=20
>=20
>   Installation
>=20
>=20
>     Download
>=20
> The ServOO archive is named servooserver-x.x.tar.gz and is availabl=
e=20
> from Servoo project page=20
> <http://sourceforge.net/project/showfiles.php?group_id=3D113878> on=
=20
> SourceForge.net. Download the latest version.
>=20
> Ok
>=20
>=20
>     Extract the sources
>=20
> Decompress and detar the archive in a temporary directory. Move or =
copy=20
> the servooserver/servoo directory into your web document root (with=
=20
> Mandrake distro it is /var/www/html).
>=20
> tar zxf servooserver-0.0.1.tar.gz
>=20
> cp -r servooserver/servoo /var/www/html
>=20
> Ok, i have copied all the rpertory servooserver on my web document =
root
>=20
>=20
>     Install java, OpenOffice.org and PEAR/SOAP
>=20
> Download and install a java machine, OpenOffice.org and PEAR/SOAP o=
n the=20
> web server.
>=20
> Suggested url for downloading these packages:
>=20
> http://java.sun.com/j2se/1.4.2/download.html
>=20
> http://blackdown.org <http://blackdown.org/>
>=20
> http://www.openoffice.org/
>=20
> http://pear.php.net/package/SOAP
>=20
>=20
> Start the OpenOffice.org program and go to Tools/Options. Look for =
the=20
> Openoffice/Security entry. Select =93Run macro: Never=94 and disabl=
e=20
> =93pluggins=94 and =93applets=94. Note that these settings may be i=
nsufficient=20
> to ensure security. The PEAR packages must be installed in a direct=
ory=20
> listed in the PHP include_path or installed =93locally=94 in the=
=20
> servoo/include directory.
>=20
> ok
>=20
>=20
>     Initialise the database
>=20
> Create a new MySQL database named servoodb for instance. As root or=
 as=20
> another authorized user:
>=20
> mysqladmin create servoodb
>=20
> Create the tables
>=20
> mysql servoodb <servoo/include/init.sql
>=20
> Create MySQL user for the servoodb database and grant some privileg=
es:
>=20
> GRANT usage ON *.* TO servoouser@localhost IDENTIFIED BY 'chooseapa=
sswd'
>=20
> GRANT all ON servoodb.* TO servoouser@localhost
>=20
>=20
>     UI created a DB servoodb wich contains 4 table =93admins, log,
>     session, user =BB
>=20
>=20
>     Configure ServOO
>=20
> Copy the servoo/config-dist.php file into servoo/config.php and edi=
t it:
>=20
> cd /var/www/html/servoo/
>=20
> cp config-dist.php config.php
>=20
> vi config.php
>=20
> Fill the variables DATABASE, DBUSERNAME, DBPASSWD, DBHOST , JAVACMD=
,=20
> OOCLASSESPATH, OOFILEMASK and OOTMPDIR accordingly to your settings=
.
>=20
> My config.php file
>=20
>=20
> # perturbate the password encoding.
>=20
> define ("PASSWDSEED","");
>=20
>=20
> # Database name
>=20
> define("DATABASE","");
>=20
>=20
> # Database username
>=20
> define("DBUSERNAME","");
>=20
> # Database user's password
>=20
> define("DBPASSWD","");
>=20
> # Database server hostname or ip
>=20
> define("DBHOST","localhost");
>=20
>=20
> # Table prefix
>=20
> define("TP","");
>=20
>=20
> # Webmaster email address to receive subscription information
>=20
> define("WEBMASTER","");
>=20
>=20
> # JAVA command
>=20
> define("JAVACMD","/usr/java/j2sdk1.4.1_02/bin/java");
>=20
>=20
> # working directory for OpenOffice.org
>=20
> define("OOTMPDIR","/tmp");
>=20
> # mask mode for file exchange between the web server and OOo.
>=20
> define("OOFILEMASK",0777);
>=20
>=20
> # directory to the OpenOffice JAVA classes.
>=20
> define("OOCLASSESPATH","/usr/local/OpenOffice.org1.1.0/program/clas=
ses");
>=20
>=20
> # timeout for the OO converter.
>=20
> define("EXEC_TIMEOUT",30);
>=20
>=20
> # log file when the documentconverter fail
>=20
> define("EXEC_LOGFILE","/var/servoo/log");
>=20
>=20
> # version d'OpenOffice
>=20
> define("OPENOFFICEVERSION","1.1");
>=20
>=20
> # message renvoie
>=20
> define ("MESSAGEVERSION","Visit http://www.servoo.net");
>=20
>=20
> # host surlequel est le serveur OpenOffice
>=20
> define("OOHOST","localhost");
>=20
>=20
> # port du serveur OpenOffice sur le host
>=20
> define("OOPORT","9303");
>=20
>=20
> # chemin relatif pour le repertoire d'include
>=20
> define("TOINCLUDE","include/");
>=20
>=20
> # URL contenant les fichiers communs partag=E9s
>=20
> # par exemple $shareurl=3D"http://lodel.revues.org/share";
>=20
> # la version sera ajoutee sur le dernier repertoire, donc la chaine=
 ne=20
> doit pas se terminer par /
>=20
> $shareurl=3D"/share";
>=20
>=20
>=20
> # Nom de la session (cookie)
>=20
> define("SESSIONNAME","sessionservoo");
>=20
>=20
> # Timeout pour les sessions
>=20
> # en seconde
>=20
> define("LOGINTIMEOUT",120*60);
>=20
>=20
>=20
> ini_set("log_errors","1");
>=20
> ini_set("display_errors","0");
>=20
> ini_set("error_log","/tmp/servoo.err");
>=20
>=20
>=20
> ?>
>=20
>=20
>=20
>=20
>=20
>=20
> Give write access for the web server user (nobody, apache, or...) t=
o=20
> servoo/CACHE and servoo/admin/CACHE directories:
>=20
> chmod 770 servoo/CACHE servoo/admin/CACHE
>=20
> or
>=20
> chmod 777 servoo/CACHE servoo/admin/CACHE
>=20
> Under windows, i allow write access
>=20
>=20
> Opening write access may be a security issue. It is recommended to =
use=20
> sudo module for Apache or PHP as a CGI with correct group/users=
=20
> settings. For testing purpose, restrict web server access and use a=
=20
> firewall.
>=20
> ???
>=20
>=20
>     Testing
>=20
> Test the configuration by creating a proper administrator.
>=20
> A temporary administrator has been automatically created during the=
=20
> MySQL tables creation. Log on http://localhost/servoo/admin/ with=
=20
> username: /admintmp/ and password: /admintmp/. Enter =93ServOO=20
> Administrator=94, create your administrator account and _delete the=
=20
> admintmp administrator_. Create also a first ServOO user, remember =
the=20
> login/password for setting in your web apps.
>=20
> Problem, i can't log on the administration
>=20
>=20
> To use Servoo, launch OpenOffice.org in server mode:
>=20
> soffice=20
> -accept=3D"socket,host=3Dlocalhost,port=3D9303;urp;StarOffice.Servi=
ceManager"
>=20
> Or use the servooserver/tools/startoo script.
>=20
> When i run this script i have:
>=20
>=20
> # Script for lauching OpenOffice.org in a development context only.
> # See the servoo script for use in operational context.
>=20
> soffice -accept=3D"socket,host=3Dlocalhost,port=3D9303;urp;StarOffi=
ce.ServiceManager"
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------------------=
-----
> 250 Mo de stockage avec MSN Hotmail !=20
> <http://g.msn.com/8HMAFRFR/2740??PS=3D47575>=20
> ------------------------------------------------------- SF.Net emai=
l is=20
> sponsored by: Discover Easy Linux Migration Strategies from IBM. Fi=
nd=20
> simple to follow Roadmaps, straightforward articles, informative=
=20
> Webcasts and more! Get everything you need to get up to speed, fast=
.=20
> http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclick=20
> _______________________________________________ servoo-users mailin=
g=20
> list ser...@li...=20
> https://lists.sourceforge.net/lists/listinfo/servoo-users