In the following, I refer to an OTRS installation located in
/home/myuser. You may safely replace an occurence of /home/myuser/otrs
with /opt/otrs, it works the same way.
On Friday, January 16, 2004 8:38 PM
MEGA Hospedagem wrote:
# mysql -u myuser -pXXX -h localhost -e "GRANT ALL PRIVILEGES ON \
myuser_otrs.* TO myuser_otrs@localhost IDENTIFIED BY 'YYY' WITH GRANT
\
OPTION"
Try issuing the command from the command line, substituting XXX with the
real database password of the user 'myuser' and YYY with the password
for the database 'myuser_otrs'. Your naming scheme is ok.
Edit /home/myuser/otrs/Kernel/Config.pm and adapt the settings for the
database connection - they are somewhat self-explanatory and documented
in the file. Esp. set 'myuser_otrs' there and the accompagning password.
Finally, run some maintenance scripts and checks:
a) Set proper permissions on all directories:
First go and see if SetPermissions.sh is there and up-to-date, which
were Revision 1.19:
# bin/SetPermissions.sh --help
SetPermissions.sh <$Revision: 1.19 $> - set OTRS file permissions
Copyright (c) 2002 Martin Edenhofer
Usage: SetPermissions.sh
[OTRS_GROUP] [WEB_GROUP]
Try: SetPermissions.sh /opt/otrs otrs wwwrun
Looks ok - so, in your case, I'd suggest you issue:
# bin/SetPermissions.sh /home/myuser myuser apache
Change 'apache' to the user your webserver runs under. This should give
you a clue about it:
# ps -ef|grep -v grep|grep httpd
b) All needed Perl modules onboard?
# perl -cw /home/myuser/otrs/bin/cgi-bin/index.pl
# perl -cw /home/myuser/otrs/bin/cgi-bin/installer.pl
The output should be something with "Ok." in it.
c) Check the database (and therefore the connection to it, too):
# perl /home/myuser/otrs/bin/CheckDB.pl
Again, a positive answer means success.
If you already completed every of the four steps of the installer, go to
http://localhost/otrs/index.pl and get to know your OTRS now.
Remember to have a look in
/home/myuser/otrs/Kernel/Config/Defaults.pm
for available settings, but do not actually set them there, but in
/home/myuser/otrs/Kernel/Config.pm
Esp., you may want to set
$Self->{SecureMode} = 1;
prior to putting your OTRS installation in the public to avoid the use
of installer.pl.
hth,
Robert Kehl
--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
