I've set up rails as instructed on the wiki, but am having a problem connecting from my rails app to the mysql database.
Here's my database.yml:
I'm using RAILS_ENV=production. When I try to run "rake db:migrate", I get the following:
[cableboy]~/crm.johnpelly.com> rake db:migrate
Access denied for user 'agilitelabscom'@'126.96.36.199/255.255.224.0' to database 'fat_free_crm_production'
I can connect to MySQL fine on the command line:
mysql -u agilitelabscom -p****** -h mysql.agilitelabs.com agilite_fat_free_crm_production
It looks like there's a problem with reverse DNS lookup from rails - note how the error message says "@'188.8.131.52/255.255.224.0' " - looks like it's not correctly identifying cableboy's DNS name.
Any help appreciated!