Has anyone tried copying the production source and database to create their own development server

Moderator: crythias

Locked
OTRSRDNewbie
Znuny newbie
Posts: 69
Joined: 29 Apr 2016, 10:23
Znuny Version: 3.2, 5
Real Name: Dennis Cua
Company: N/A

Has anyone tried copying the production source and database to create their own development server

Post by OTRSRDNewbie »

We have OTRS 3.3.2 on a Red Hat Enterprise Linux Server release 6.3. The security policy is so strict I am yet to have a account on the actual servers. So I asked around to borrow theirs. I also asked someone to copy the whole otrs on the pre-production (testing) server and the database.

So I assembled a virtual machine in VirtualBox, installed Cent OS 7. And tried to install the otrs there. I have able to successfully run the web installer perl, I got the root@local password. But when I run index.pl and asked to login I always get an invalid username or password.

I did change the SecureModule in Config.pm, I have checked the local mariadb there is an otrs database, there is a root and otrs, user the password is encrypted. But I think when I am running index.pl. Its accessing the old mysql server of production.

I have checked the webpage source it looks like its directing the post in the localhost.

Can you suggest where I have missed. I have run installer.pl successfully. Could it be in the encryption?
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Has anyone tried copying the production source and database to create their own development server

Post by RStraub »

Did you also change the path to the db where OTRS is connecting to ? It's in the config.pm as well.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
OTRSRDNewbie
Znuny newbie
Posts: 69
Joined: 29 Apr 2016, 10:23
Znuny Version: 3.2, 5
Real Name: Dennis Cua
Company: N/A

Re: Has anyone tried copying the production source and database to create their own development server

Post by OTRSRDNewbie »

Yes, when I run installer.pl I specifically changed localhost and I used the root password of my virtual machine mariadb. Also after installation I have checked the Config.pm. settings.its accessing 127.0.0.1.

I assembled a new virtual machine so there is no existing otrs on this.

I notice the password in the database is encrypted. Is there a possibility that the installer's encryption and the index.pl's encryption would somehow be different?
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Has anyone tried copying the production source and database to create their own development server

Post by RStraub »

Might be an unlucky error... you can always change the password via the scripts in ~otrs/bin.

In your version it should be ~otrs/bin/otrs.SetPassword.pl
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Locked