Hi everyone, I have two instances of osticket 1.7.2 set up on the same server. One in /html, and on in /html/support. MySQL shows both databases have 32 rows of tables. I want to import the DB from one to another. What I have been trying to do it dump the database i want to use with a mysqldump command, lets call this DB2. Then I am manually removing the tables from the database to be imported to, this is DB1. Once all the tables are removed from DB1, I use the source command to import the data from DB2. However, EVERYTIME I refresh the webpage, it kickes me out and does not accept my userid and password. Please help. This should not be this hard. Thanks in advance

First of all are you sure that they are both 1.7.2?(and is there some reason why you haven't upgraded?)It sounds to me like a session issue.  Or maybe one install has a different password for the same "johndoe" account.Whats your actual goal?  Are you trying to merge the two into once keeping the data from both?Are you trying to simply point one installation to the other installations DB?When you exported did your export include drop commands to clear out existing data?

I am sure they are both 1.7.2, as it is reflected in the admin panel. I can upgrade them both to 1.8.1, however I still cannot copy over the DB so I have not done that yet. Here is what I am trying to accomplish. Our production system is 1.6RC5, hosted. We would like to host a new version ourselves. I have built a server and installed 1.7.1 in November, so the tickets are not current. At that time, this process seemed to work. I have not done anything since november. This morning, I did a .sql dump from our hosted production system. Then I stood up another osticket instance v1.6SR. Imported the dump from our prod system and I ran the upgrader. Now I have both instances at 1.7.1. (One has current tickets, but no other mods. I build this only to get the DB format correct. The other system is the one we want to go live with. It has old tickets, but we have changed some logos etc)So as a result I have 2 osticket instances, both v1.7.2. 1 with old tickets. 1 with new ones. Mysql shows equal number of tables in both databasesI did a dump of the database I want to use. Removed all tables from the target DB and ran a source command to import the dump to the now empty DB.Every time I run this source command and go refresh the webpage, I get locked out. I hope this had made some sense. 

Please try doing this. After you have imported the data into db, go to your ost1 directory and edit /include/ost-config.php (not yours may be called settings.php. or ostconfig.php).  around line 32 locate:define('SECRET_SALT',go to your ost2 directory and back up /include/ost-config.php Once its backed up edit it and in place of the salt that is there now put the one from your ost1 dir. Then try to log in.Since you installed at different times chances are you have a different salt specified.

You are correct that the SECRET SALT passwords are different. I have done as you have asked, and I am still experiencing a lock out after I import the data to the DB. Any other suggestions?Thank you. 

I believe I have figured it out. Would you believe it was as simple as clearing out the cache on my browser?haha. I have success. Thanks for your help. 

Actually I would believe it.  :)  Glad that you got it fixed though

Write a Reply...