Having troubles connectiong Magento to external Windows Database Server using Windows Azure
- by Kevin H
"I tried to make this easy to read through"
I am using Ubuntu 12.04 LTS for Magento and installed these commands onto the system:
sudo apt-get install apache2
sudo apt-get install php5 libapache2-mod-php5
sudo apt-get install php5-mysql
sudo apt-get install php5-curl php5-mcrypt php5-gd php5-common
sudo apt-get install php5-gd
I used Windows Server 2008 R2 August 2012 for Mysql Server
For a reference, I used http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-mysql/
When the server was setup, I added an empty disk to it
Then, I added endpoints 3306
Next I accessed the server remotely
After that, I formatted the empty disk and was inserted as F:
Next I downloaded Mysql from http://*.mysql.com version Windows (x86, 64-bit), MSI Installer 5.5.28
In the installation process, I used these settings:
Typical Setup - Clicked Next, install, next
Chose Detailed Configuration - Clicked next
Chose Dedicated MySQL Server Machine - Clicked Next
Chose Transactional Database Only - Clicked Next
Chose the "F:" Drive - Clicked Next
Chose Online Transactional Processing (OLTP) - Clicked Next
For Networking Options, I checkmarked 'Enable TCP/IP Networking" 'Add firewall exception for this port' 'Enable Strict Mode' - Clicked Next
Chose Standard Character Set - Clicked Next
For Windows Options, I checkedmarked 'Install as Window Service" 'Launch the MySQL Server automatically' 'Include Bin Directory in Windows PATH - Clicked Next
For Security Options, I checkmarked 'Modify Security Settings' and set root password - Clicked Next
Finally clicked Execute and Finish
These are the Firewall Setting that I set
I clicked inbound rules
Properties
Scope
Allow IP Address and used the internal Address for Magento Server
Clicked Apply and exited
Next, I opened up MySQL 5.x Command Line Client
Entered Root Password
Then entered these commands
mysql create database magento;
mysql Create user magentouser identified by 'password';
mysql Grant select, insert, create, alter, update, delete, lock tables on magento.* to magentouser
mysql exit
Finally, I opened up the Magento Downloader
Magento validation has approved all
PHP version is right. Your version is 5.3.10-1ubuntu3.4.
PHP Extension curl is loaded
PHP Extension dom is loaded
PHP Extension gd is loaded
PHP Extension hash is loaded
PHP Extension iconv is loaded
PHP Extension mcrypt is loaded
PHP Extension pcre is loaded
PHP Extension pdo is loaded
PHP Extension pdo_mysql is loaded
PHP Extension simplexml is loaded
These are all installed on Magento Server
For the Database Connection, I used:
The Database server only has MySQL 5.5 Server installed on it
Host - Internal IP address
User Name - The User I created when setting up database
Password - The Password I created when setting up database
For the password, I did some research and found out that Magento only accepts alphanumeric, so I went and set it up again and used only alphanumeric for the User password
Now, I am still getting Accessed denied for database Connection.
Also, I have tryed to setup mysql on independant Linux Server but kept getting errors. When, I found the solution. Wouldn't work, so I decided to try Windows.
These is the questions, I have been asking and researching to debug this issue
Is it because I am using Linux for magento and Windows for Database. I have had no luck in finding a reason why this wouldn't work
There must be something, I am missing
I also researched the difference between linux sql databases and windows sql databases but have not come to conclusion, if installing Mysql on windows would make a difference in syntax and coding.
I have spent a lot of time looking into this and need some help with direction on how to complete my project. Any type of help would be appreciated.
