Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 565
  • Last Modified:

linux apache and mysql

Dear Experts:

I having sugarcrm which works on lamp in one box here the version is 6.5 and now as sugarcrm have released 7.5 did setup another box and installed sugarcrm 7.5 this also works on lamp stack,  

both are working now the requirement is to disconnect the database of 7.5 and connect to the database of 6.5, for this created mysql user in 6.5 and granted full privileges and imported the database 7.5 to this 6.5 user and also did changes in the 7.5 in the config.php but not able to connect to the 7.5 when try database faillure from the browser , looks some where iam going wrong can you please suggest on which all files the database pointing to be changed in 7.5
0
D_wathi
Asked:
D_wathi
  • 2
2 Solutions
 
arnoldCommented:
One is to check whether there is a db change needed to make the old db into a newer format, you should do backup, and work on the restored copy on another machine.

Back to your question:
First you should check whether mysql on the 6.5 system is accepting connections from outside, iptables -L INPUT --line-numbers
Telnet from 7.5 version to ip of 6.5 version port 3306, do you see the mysql version in the greeting? Is the 6.5 version bound to port 3306 lsof -i:3306
Answers to the above will answer the question of connectivity.

Then on the 6.5 list the mysql.user table to see whether the user you are setting up for access from the 7.5 is allowed based on the host field and whether the user is password protected.

Check the documentation for 7.5 and see the transitions from 6.5. It could be that you would need to apply 6.8 and then 7.1 before getting the DB into the correct Schema to interoperate with 7.5.

A direct connection without a good backup could have an unexpected situation where the data is no longer accessible by eighter.
0
 
D_wathiAuthor Commented:
thank you very much for the reply. yes I had taken measures of iptables as both 6.5 sugar and 7.5 are on same esxi host as a vm's hence firewall( iptables) and selinux all are disabled and connectivity there found to be no issues.  root login validation found to be successful but data base does not get created also it is set with complete privileges,   the error while pointing the 7.5 to 6.5 mysql server was access denied I have allowed mysql root users login from remote on 6.5 think should also execute the below commands in 6.5 mysql server
6.5 server ip is 192.168.1.251 , please suggest should I have to execute the below on 6.5 where 192.168.1.235 is sugar 7.5
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'192.168.1.235' IDENTIFIED BY 'some_password';
FLUSH PRIVILEGES;

Please suggest is the above correct ones as this is production server

thanks in advance
0
 
arnoldCommented:
Yes, you would need to run the grant query to allow username to login from 192.168.1.235 but the database must exist because it is part of the authentication, username from host using password connecting to database_name.

Try initially grant all on all.* to username@192.168.1.235
And change it after the database is created, or you can backup/restore the database from 7.5 to 6.5 system.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now