Bug#342642: otrs: upgrade failed

2005-12-09 Thread Andreas Tille 

On Fri, 9 Dec 2005, Thomas Wouters wrote:


Are the owner ship promissions set right on all otrs file?

use ~otrs/bin/SetPermissions.sh

i used otrs:www-data (that should work on debian as default) but it didn't 
work until i used  www-data:www-data ;


Well, I think I used www-data:www-data before and now (after the upgrade)
most files are really set to www-data:www-data.  Loocking at it there are
a few exceptions:

  /usr/share/otrs/var :
Most directories are otrs:www-data (/usr/share/otrs/var/sessions
is www-data:www-data)
  --> do you mean I should changes these all to www-data:www-data

  /usr/share/otrs/bin :
/usr/share/otrs/bin/DeleteSessionIDs.pl
/usr/share/otrs/bin/UnlockTickets.pl
/usr/share/otrs/bin/otrs.getConfig
  --> These three files are otrs:root (everything else www-data:www-data)

So the permissions in fact seem to be a little bit funny and I would love
to see a systematic solution to fix the problem inside the package.

Thanks for the hint anyway and kind regards

 Andreas.
--
http://fam-tille.de


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Bug#342642: otrs: upgrade failed

2005-12-09 Thread Thomas Wouters 

hi,

Are the owner ship promissions set right on all otrs file?

use ~otrs/bin/SetPermissions.sh

i used otrs:www-data (that should work on debian as default) but it 
didn't work until i used  www-data:www-data ;



Good luck!


Thomas Wouters
Andreas Tille wrote:


Package: otrs
Version: 2.0.4p01-1
Severity: grave
Justification: renders package unusable

Hello,

after latest upgrade in testing OTRS became unusable:

  http://localhost/cgi-bin/otrs/customer.pl

  Forbidden

  You don't have permission to access /cgi-bin/otrs/customer.pl on this server.

  Additionally, a 403 Forbidden error was encountered while trying to use an 
ErrorDocument to handle the request.
  Apache/2.0.54 (Debian GNU/Linux) PHP/4.4.0-4 Server at 
wr-linux02.rki.ivbb.bund.de Port 80

Moreover the cron jobs fail continuousely:

---
Date: Fri, 09 Dec 2005 08:00:04 +0100
From: Cron Daemon <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Cron <[EMAIL PROTECTED]> test -x $HOME/bin/GenericAgent.pl &&
   $HOME/bin/GenericAgent.pl -c db >> /dev/null

DBD::Pg::st execute failed: FEHLER:  Relation »process_id« existiert nicht
ERROR: OTRS-GenericAgent-10 Perl: 5.8.7 OS: linux Time: Fri Dec  9 08:00:04 2005

Message: FEHLER:  Relation »process_id« existiert nicht
, SQL: 'SELECT process_name, process_id, process_host, process_create  FROM
process_id  WHERE  process_name = 'GenericAgent''

Traceback (14567): 
  Module: Kernel::System::PID::PIDGet (v1.3) Line: 167

  Module: Kernel::System::PID::PIDCreate (v1.3) Line: 100
  Module: /usr/share/otrs/bin/GenericAgent.pl (v1.36) Line: 123

DBD::Pg::db do failed: FEHLER:  Relation »process_id« existiert nicht
ERROR: OTRS-GenericAgent-10 Perl: 5.8.7 OS: linux Time: Fri Dec  9 08:00:04 2005

Message: FEHLER:  Relation »process_id« existiert nicht
, SQL: 'INSERT INTO process_id  (process_name, process_id, process_host,
process_create)  VALUES  ('GenericAgent', '14567', 
'wr-linux02.rki.ivbb.bund.de',
1134111604)'

Traceback (14567): 
  Module: Kernel::System::PID::PIDCreate (v1.3) Line: 129

  Module: /usr/share/otrs/bin/GenericAgent.pl (v1.36) Line: 123

---

Tha database ist stored in PostgreSQL.  The postgresql server was upgraded in
the same apt-get upgrade process.  The database itself looks fine and is
accessible via other clients (psql, pgamdin3).

Feel free to ask me for further information that might be needed to track
down the problem.

Kind regards

 Andreas.

-- System Information:
Debian Release: testing/unstable
 APT prefers testing
 APT policy: (501, 'testing'), (50, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages otrs depends on:
ii  apache2   2.0.54-5   next generation, scalable, extenda
ii  apache2-mpm-prefork [apache2] 2.0.54-5   traditional model for Apache2
ii  libauthen-sasl-perl   2.09-1 Authen::SASL - SASL Authentication
ii  libdate-pcalc-perl1.2-2  Perl module for Gregorian calendar
ii  libdbi-perl   1.48-2 Perl5 database interface by Tim Bu
ii  libemail-valid-perl   0.15-3 Check validity of Internet email a
ii  libio-stringy-perl2.110-1Perl5 modules for IO from scalars 
ii  libmailtools-perl 1.62-1 Manipulate email in perl programs

ii  libmime-perl  5.418-1Perl5 modules for MIME-compliant m
ii  perl  5.8.7-7Larry Wall's Practical Extraction 


Versions of packages otrs recommends:
ii  aspell0.60.3-5   GNU Aspell spell-checker
ii  ispell3.1.20.0-4 International Ispell (an interacti
pn  libapache2-mod-perl2 | libapa  (no description available)
ii  libdbd-mysql-perl 3.0002-1   A Perl5 database interface to the 
ii  libdbd-pg-perl1.43-1 a PostgreSQL interface for Perl 5 
pn  libgd-graph-perl   (no description available)

pn  libgd-text-perl(no description available)
ii  mysql-server  4.1.14-6   mysql database server (transitiona
ii  mysql-server-4.1 [mysql-serve 4.1.14-6   mysql database server binaries
ii  postgresql7.5.13 object-relational SQL database man
ii  procmail  3.22-11Versatile e-mail processor

-- debconf-show failed


 




--
Thomas Wouters
[EMAIL PROTECTED]

SIJN
Veerpoortstraat 28
6981 BN  Doesburg

Tel: 062-33 89 144
Fax: 084-22 02 007
www:  www.sijn.nl

Bug#342642: otrs: upgrade failed

2005-12-09 Thread Andreas Tille 
Package: otrs
Version: 2.0.4p01-1
Severity: grave
Justification: renders package unusable

Hello,

after latest upgrade in testing OTRS became unusable:

   http://localhost/cgi-bin/otrs/customer.pl

   Forbidden

   You don't have permission to access /cgi-bin/otrs/customer.pl on this server.

   Additionally, a 403 Forbidden error was encountered while trying to use an 
ErrorDocument to handle the request.
   Apache/2.0.54 (Debian GNU/Linux) PHP/4.4.0-4 Server at 
wr-linux02.rki.ivbb.bund.de Port 80

Moreover the cron jobs fail continuousely:

---
Date: Fri, 09 Dec 2005 08:00:04 +0100
From: Cron Daemon <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Cron <[EMAIL PROTECTED]> test -x $HOME/bin/GenericAgent.pl &&
$HOME/bin/GenericAgent.pl -c db >> /dev/null

DBD::Pg::st execute failed: FEHLER:  Relation »process_id« existiert nicht
ERROR: OTRS-GenericAgent-10 Perl: 5.8.7 OS: linux Time: Fri Dec  9 08:00:04 2005

 Message: FEHLER:  Relation »process_id« existiert nicht
, SQL: 'SELECT process_name, process_id, process_host, process_create  FROM
process_id  WHERE  process_name = 'GenericAgent''

 Traceback (14567): 
   Module: Kernel::System::PID::PIDGet (v1.3) Line: 167
   Module: Kernel::System::PID::PIDCreate (v1.3) Line: 100
   Module: /usr/share/otrs/bin/GenericAgent.pl (v1.36) Line: 123

DBD::Pg::db do failed: FEHLER:  Relation »process_id« existiert nicht
ERROR: OTRS-GenericAgent-10 Perl: 5.8.7 OS: linux Time: Fri Dec  9 08:00:04 2005

 Message: FEHLER:  Relation »process_id« existiert nicht
, SQL: 'INSERT INTO process_id  (process_name, process_id, process_host,
process_create)  VALUES  ('GenericAgent', '14567', 
'wr-linux02.rki.ivbb.bund.de',
1134111604)'

 Traceback (14567): 
   Module: Kernel::System::PID::PIDCreate (v1.3) Line: 129
   Module: /usr/share/otrs/bin/GenericAgent.pl (v1.36) Line: 123

---

Tha database ist stored in PostgreSQL.  The postgresql server was upgraded in
the same apt-get upgrade process.  The database itself looks fine and is
accessible via other clients (psql, pgamdin3).

Feel free to ask me for further information that might be needed to track
down the problem.

Kind regards

  Andreas.

-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (501, 'testing'), (50, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages otrs depends on:
ii  apache2   2.0.54-5   next generation, scalable, extenda
ii  apache2-mpm-prefork [apache2] 2.0.54-5   traditional model for Apache2
ii  libauthen-sasl-perl   2.09-1 Authen::SASL - SASL Authentication
ii  libdate-pcalc-perl1.2-2  Perl module for Gregorian calendar
ii  libdbi-perl   1.48-2 Perl5 database interface by Tim Bu
ii  libemail-valid-perl   0.15-3 Check validity of Internet email a
ii  libio-stringy-perl2.110-1Perl5 modules for IO from scalars 
ii  libmailtools-perl 1.62-1 Manipulate email in perl programs
ii  libmime-perl  5.418-1Perl5 modules for MIME-compliant m
ii  perl  5.8.7-7Larry Wall's Practical Extraction 

Versions of packages otrs recommends:
ii  aspell0.60.3-5   GNU Aspell spell-checker
ii  ispell3.1.20.0-4 International Ispell (an interacti
pn  libapache2-mod-perl2 | libapa  (no description available)
ii  libdbd-mysql-perl 3.0002-1   A Perl5 database interface to the 
ii  libdbd-pg-perl1.43-1 a PostgreSQL interface for Perl 5 
pn  libgd-graph-perl   (no description available)
pn  libgd-text-perl(no description available)
ii  mysql-server  4.1.14-6   mysql database server (transitiona
ii  mysql-server-4.1 [mysql-serve 4.1.14-6   mysql database server binaries
ii  postgresql7.5.13 object-relational SQL database man
ii  procmail  3.22-11Versatile e-mail processor

-- debconf-show failed