Solved

linux apache and mysql

Posted on 2014-12-24
3
482 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
  • 2
3 Comments
 
LVL 76

Assisted Solution

by:arnold
arnold earned 500 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 76

Accepted Solution

by:
arnold earned 500 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now