Hi Christian ,
Ran the DBUpdate script , as well as the SetPermissons script , is as
follows:
Setting file permissions...
chown -R apache:nogroup /opt/otrs/
chown: `apache:nogroup': invalid group
chown: `apache:nogroup': invalid group
chmod -R og+rw /opt/otrs/
chown otrs:nogroup /opt/otrs/
chown: `otrs:nogroup': invalid group
chown otrs:nogroup /opt/otrs//.fetchmailrc
chown: `otrs:nogroup': invalid group
chmod 0710 /opt/otrs//.fetchmailrc
chown otrs:nogroup /opt/otrs//.procmailrc
chown: `otrs:nogroup': invalid group
chmod 0644 /opt/otrs//.procmailrc
chown otrs:nogroup /opt/otrs//.mailfilter
chown: `otrs:nogroup': invalid group
chmod 0600 /opt/otrs//.mailfilter
chown -R otrs:nogroup /opt/otrs//var/
chown: `otrs:nogroup': invalid group
chown -R apache:nogroup /opt/otrs//var/sessions/
chown: `apache:nogroup': invalid group
touch && chown otrs:nogroup /opt/otrs//var/log/TicketCounter.log
chown: `otrs:nogroup': invalid group
chmod -R 775 /opt/otrs//bin/
(chown && chmod 700) otrs:0 /opt/otrs//bin/DeleteSessionIDs.pl
(chown && chmod 700) otrs:0 /opt/otrs//bin/UnlockTickets.pl
(chown && chmod 700) otrs:0 /opt/otrs//bin/otrs.getConfig
You have new mail in /var/spool/mail/root
Not sure what the "nogroup" should be...
I get a few of these errors when running the DBupdate script... can this
maybe have an effect
ERROR 1194 (HY000) at line 27: Table 'ticket' is marked as crashed and
should be repaired
ERROR 1194 (HY000) at line 28: Table 'ticket' is marked as crashed and
should be repaired
ERROR 1194 (HY000) at line 29: Table 'ticket' is marked as crashed and
should be repaired
ERROR 1194 (HY000) at line 30: Table 'ticket' is marked as crashed and
should be repaired
ERROR 1194 (HY000) at line 31: Table 'ticket' is marked as crashed and
should be repaired
Also when i do a ls i get :
[EMAIL PROTECTED] ~]# ls -lht /opt/otrs/var/article/2007/
total 48K
drwxrwsr-x 33 apache apache 4.0K Mar 23 17:01 03
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 01
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 02
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 04
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 05
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 06
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 07
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 08
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 09
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 10
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 11
drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 12
I actually edited the Article.pm script to see what is on line 1363 and
it seems it has something to do with the ArticleID and "Content"
variables... which leads me to believe the reference in the MySQL DB
does not correspond to the article directory? This might be a shot in
the dark , but I'm really baffled by this.
Christian Schoepplein wrote:
On Thu, Mar 29, 2007 at 10:36:12AM +0200, Danie wrote:
Ok so we decided to build a secondary OTRS system , sort of as a
reference archive to our production system. I basically did a clean
install of 2.1.6 on FC5 , copied over the 2.0.4 database and article
data , followed the instructions of the UPGRADE.txt document to upgrade
the database. All went fine , could log in but as soon as I click on a
queue to view the tickets I get an error message :
Can't use an undefined value as a HASH reference at
/opt/otrs//Kernel/System/Ticket/Article.pm line 1363.
I searched the otrs archives but to no avail , I think the ticket data in
the database can't find the actual article reference?
Also I did run the Setpermissions.sh script as well..
Please check the permissions of the articles stored in your file system.
You can find them in
/opt/otrs/var/article
and its subdirs.
Daniel
-- Christian
((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg
Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18
http://www.otrs.com/ :: Communication with success!
Geschäftsführer: André Mindermann, Martin Edenhofer
Handelsregister: HRB 9452 Bad Homburg
Steuernummer: 003/240/97521
------------------------------------------------------------------------
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
