Solved

linux apache and mysql

Posted on 2014-12-24
3
520 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 78

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 78

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

717 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