Solved

linux apache and mysql

Posted on 2014-12-24
3
498 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 77

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 77

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

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ignore other .htaccess 2 58
mysql date time 14 38
how to access a remote mysql database with xampp 3 23
LINUX Field Separators 7 34
If you've heard about htaccess and it sounds like it does what you want, but you're not sure how it works... well, you're in the right place. Read on. Some Basics #1. It's a file and its filename is .htaccess (yes, with a dot in the front). #…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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.

839 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