Hi all.
Need some help.
I have setup dbconnector to MySQL database, but I am not sure if it's working.
We have 2 servers Web and DB. When I try to setup db data source and run simple query like "select all" nothing happens.
I have tried to use Submission actions on a form to submit to that database what I get is this:
Fatal error: Uncaught exception 'DALException' with message 'DBError!:SQLSTATE[28000] [1045] Access denied for user 'bookings'@'###.###.##' (using password: YES)' in /home/websites/pcc3283/core/lib/DAL/DAL.inc:1313 Stack trace:
###.###.## - is the domain, what is interesting is that domain it displays is web servers not database server. "bookings" is database user not an account on that domain.
I am confused I have other apps on this combination where front end sits on web server and MySQL db on DB server and everything works fine.
Matrix itself sit's on websever and postgress on db and works fine, so why is the db connector with all the right details having trouble to connect?
Also is there any way to test if connector is successfull without building data sources?
What else am I missing?
P.S. sorry for the cross post, but I don't see any way to move it.
Hi Eric,
I have deleted the duplicate thread in Developers.
Unlike (what I am aware with) in PostgreSQL, in MySQL the user account is identified by both the user name and the host it is connecting from. Do you have a user either for 'bookings'@'###.###.##' (whatever your error is reporting), or for 'bookings'@'%' (the '%' means any server, which is rather less secure), with the correct grants for the database you're accessing?
Thank you for a hint. You were right it was access issue.