Hi

I have a drupal/MySQL website hosted on Azure. I can connect to the website with no issues. However, when I try to log-in, I get an error. The ClearDB support centre thinks the user in the error message is different to the user created on the MySQL database and require change, but without the ability to connect, this can be verified and solved. Please help. The error is:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user 'b40c90effc5c0e'@'213.199.134.209' for table 'watchdog': INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => user [:db_insert_placeholder_2] => Session opened for %name. [:db_insert_placeholder_3] => a:1:{s:5:"%name";s:5:"admin";} [:db_insert_placeholder_4] => 5 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://ruddington-shotokan.co.uk/user [:db_insert_placeholder_7] => http://ruddington-shotokan.co.uk/user [:db_insert_placeholder_8] => 86.157.241.98 [:db_insert_placeholder_9] => 1408033458 ) in dblog_watchdog() (line 154 of D:\home\site\wwwroot\modules\dblog\dblog.module).

Hi Maan,

According to your description, since the issue regards Azure Web Sites, I recommend you post the thread on the Azure Web Sites forum at http://social.msdn.microsoft.com/Forums/windowsazure/en-US/home?forum=windowsazurewebsitespreview. It is appropriate and more experts will assist you.

In addition, the error is related to the database size limit. on Azure, the free MySQL database size is limited to 20 MB which is really too little for any hosted application. A suggestion is related to permission. In MySQL, error code 1142 is a pure permissions issue. I recommend  you check the permissions in the MySQL client such as php-myadmin.

Regards,
Sofiya Li