Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Manuel Fernández Panzuela
How are you trying upgrade, are you following any reference? Un saludo Manuel Fernández Panzuela www.mfernandez.es 2010/7/10 Isaac Gonzalez igonza...@autoreturn.com Upgrading from 2.2.x to 2.4.x(cent os 5, mysql 4.1.18) I ran into some errors during the db upgrade for mysql for 2.2 to

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Isaac Gonzalez
I'm following the upgrade guide from the source tar.I get the errors running the first DB 2.3 MySQL script Manuel Fernández Panzuela manuelfernandezpanzu...@gmail.com wrote: How are you trying upgrade, are you following any reference? Un saludo Manuel Fernández Panzuela

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Manuel Fernández Panzuela
Which is your inicial version before upgrade process ? If you are working with 2.2.7 version before upgrade to 2.3.1 version you need upgrade to 2.2.8, 2.2.9 and finally version 2.3.1 Are you doing it ? Un saludo Manuel Fernández Panzuela www.mfernandez.es

[otrs] Unify Joomla and OTRS customer users

2010-07-10 Thread emigo...@gmail.com
I'm working to integrate OTRS in Joomla and my first problem was unify the user. OTRS use a very ugly method with crypt and Joomla use pass in the form md5_hex(pass+salt):salt where salt is a 32 bytes random number in hex (a md5hex of a rand) This patch convert de passwd of customer users in

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Isaac Gonzalez
Initial version is 2.2.4 Manuel Fernández Panzuela manuelfernandezpanzu...@gmail.com wrote: Which is your inicial version before upgrade process ? If you are working with 2.2.7 version before upgrade to 2.3.1 version you need upgrade to 2.2.8, 2.2.9 and finally version 2.3.1 Are you doing it ?

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Manuel Fernández Panzuela
Then you must upgrade your Revision, and after that you can upgrade your version. did you tried it ? Un saludo Manuel Fernández Panzuela www.mfernandez.es 2010/7/10 Isaac Gonzalez igonza...@autoreturn.com Initial version is 2.2.4 Manuel Fernández Panzuela manuelfernandezpanzu...@gmail.com

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Isaac Gonzalez
Then you must upgrade your Revision, and after that you can upgrade your version. did you tried it ? I don't think you are understanding the issue i am running into.i'm not running into an issue with the rpm per se, I am running into an issue running the db update script for 2.3 for

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Manuel Fernández Panzuela
Answering your first question about: And then every alter statement below that tried to add a constraint also gave back an error cannot create table \dbname\#sql – 2500_b.frm….can I just safely ignore this?...i have rolled everything back to how it was with 2.2, but would love to complete the

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Isaac Gonzalez
And then every alter statement below that tried to add a constraint also gave back an error cannot create table \dbname\#sql - 2500_b.frmcan I just safely ignore this?...i have rolled everything back to how it was with 2.2, but would love to complete the upgrade process You must not

Re: [otrs] Unify Joomla and OTRS customer users

2010-07-10 Thread emigo...@gmail.com
These patches convert also users in Joomla password form: - diff -c /opt/otrs/Kernel/System/User.pm.orig /opt/otrs/Kernel/System/User.pm ***

Re: [otrs] upgrade issues from 2.2.x to 2.4.x

2010-07-10 Thread Isaac Gonzalez
Could this be an issue with mysql 4.1? I tried upgrading mysql from 4.1.18 to 4.1.22 and tried the dbupgrade to 2.3 for otrs and it fails with the same errors at the exact same lines...either a limitation in mysql 4.1 or a setting that I don't have enabled. I looked at the software reqs for otrs