Re: [otrs] Migration Server

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/