migrating between two servers Agents

[momken]

Hello,

I followed the procedures

http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=258

http://doc.otrs.org/3.0/en/html/x907.html

Now I cannot login as any agent and the web interface does not show any agents.

but I can see them in system_user

Moving from 2.1.7 ubuntu (Mysql 5.0.45) to 3.0.7 centos (Mysql 5.0.77)



any idea

Thanks.

[crythias]

How did you connect to your original database of agents? MySQL or Active Directory?
Did you check your Config.pm between them?
How did you upgrade? In place and move or move, then upgrade?
how did you back up and restore?

[momken]

Hello

How did you connect to your original database of agents? MySQL or Active Directory?

Its local in the otrs2 database.

Did you check your Config.pm between them?

I checked the config and copied the difference between the old and new system.

How did you upgrade? In place and move or move, then upgrade?

I have two seperate systems, the production one is still intacte and running.

how did you back up and restore?

On a new system Centos I installed OTRS 3, went in the mysql database
imported the sql dump, ran the upgrade scripts, i log in the system
and can login using root@localhost but the cannot use the agents accounts.

when i go in the mysql database I see this table of system_users that contain
the agents from the original system.


Something might have gone wrong along the way, I can retry from scratch,
its a VM and I took multiple snapshots, but if there is an explanation that will be great.

Cheers,
Sami

[crythias]

from 2.1 -> 3.0 you needed to incrementally upgrade 2.2, 2.3, 2.4, 3.0

[momken]

Would you please clarify this phrase ?

My uynderstanding was to import the database in mysql then run the upgrade scripts

2.1 -> 2.2 -> 2.3 -> 2.4 -> 3.0


cat DBUpdate-to-2.2.mysql.sql | mysql -f -u root -p otrs2
cat DBUpdate-to-2.3.mysql.sql | mysql -f -u root -p otrs2
cat DBUpdate-to-2.4.mysql.sql | mysql -f -u root -p otrs2
cat DBUpdate-to-3.0.mysql.sql | mysql -f -u root -p otrs2

that is what i did ... no ?

[momken]

Actually, I think I ll benifit from the situation and use AD to authenticate agents.

now here is my question, we have multiple queues,

how do I map a group from AD to a group in OTRS ?

so a user in group X will have queue X and so forth

Thanks,
Sami

[crythias]

it's more than db updates. You should read the upgrading readme for each increment. You've not necessarily given yourself a stable situation at this point. For your final question, please ask it again in a new topic.