Avatar of Goutham
GouthamFlag for India

asked on 

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
LinuxApache Web ServerMySQL ServerSugarCRM

Avatar of undefined
Last Comment
arnold
SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Goutham
Goutham
Flag of India image

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Linux
Linux

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

71K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo