?
Solved

linux apache and mysql

Posted on 2014-12-24
3
Medium Priority
?
525 Views
Last Modified: 2016-03-18
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
Comment
Question by:D_wathi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 79

Assisted Solution

by:arnold
arnold earned 2000 total points
ID: 40517256
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
 

Author Comment

by:D_wathi
ID: 40517409
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
 
LVL 79

Accepted Solution

by:
arnold earned 2000 total points
ID: 40517423
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

Featured Post

Stressed Out?

Watch some penguins on the livecam!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question