Hello Elva,

Yes it’s a problem about MySQL user, i search on the web the MySQL command and I can  create otrs user (MySQL) with the good password and good privileges, so it’s work now.

Thank for your response

Regards

Sébastien 

De : otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] De la part de Elva Novoa
Envoyé : lundi 17 janvier 2011 19:43
À : User questions and discussions about OTRS.
Objet : Re: [otrs] Migration Server

Hello Sébastien,

I think your problem lies in the fact that in the part where you granted the privileges to your user, you specified the password "test" and on your Config.pm you wrote "hot". Please try by either executing:

mysql –uroot –e “grant all on otrs.* to
‘otrs@localhost’ identified by ‘hot’” && mysql –uroot –e “flush privileges”

or modifying this line on your Config.pm:

$Self->{DatabasePw} = 'test';

I hope this helps!

Regards,
Elva

On 1/14/2011 4:17 AM, Sebastien Bory wrote:

Hello list,
 
I have a server Windows 2003 r2, with OTRS 3.0.4 and MySQL database, this
server is for test and try some functionality about OTRS.
 
Today I want to install OTRS on another server to production, so I do this
 
1 On Test server
 
-          Save the config.pm on a share folder
 
-          Save MySQL database (mysqldump –uroot otrs > otrs_dump.sql) and
save it on a share folder
 
-          Save sysconfig by administration tools on OTRS, and copy it in
share folder
 
2 on Production server (also windows 2003 r2)
 
-          Install OTRS 3.0.4
 
-          Don’t run the web installer after
 
-          Create the database : mysql> create database otrs character set
utf8;
 
-          Allow privileges: mysql –uroot –e “grant all on otrs.* to
‘otrs@localhost’ identified by ‘test’” && mysql –uroot –e “flush privileges”
 
-          Restore database: mysql –uroot otrs < otrs_dump.sql
 
-          Copy the old config.pm (test server) to the production server
 
-           
 
After I try to run OTRS to import my sysconfig and I have this error: Access
denied for user 'otrs'@'localhost' (using password: YES)
 
 
 
I think it’s mismatch witch credential about MySQL root but I don’t know
where I can see it? And I have a  about the user (otrs@localhost) in the
grant MySQL command, because in the config.pm the user is otrs and password
hot
 
 
 
Best regards
 
 
 
Sébastien  Bory
 
 
 
 
 
 
 
 
---------------------------------------------------------------------
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

-- 
Elva María Novoa del Toro
 
Research & Development
 
 
OTRS Lab, S.A. de C.V.
 
Parque de Software, Módulo A1, Circuito Norte 100
 
Parque Industrial Zapotlan 2000
 
49000 Ciudad Guzmán, Jalisco
 
MEXICO
 
 
 
T: +52 33 4777 3861
 
I:  www.otrs.com/
 
Incremente su eficiencia hasta un 30% - obtenga OTRS Help Desk 3.0: http://www.otrs.com/