I am trying to get my app up and running on a dedicated virtual server
running on CentOS 5. I am using Ruby 1.8.5 and rails 1.2.3.
I can access/update my MySql tables through normal interaction with
the pages without any problem. I am assuming the user/pwd specified in
database.yml under the db_production is being picked up for this.
However at one point in my code I have to execute a stored procedure -
I know it goes against the philosophy of rails but I have to. To do
that I make a call as follows from my model object
However, when I try to load that page that runs that query, I get a
failure in my logs saying
Mysql::Error: There is no 'root'@'localhost' registered: call
Now my mongrel instances are running under a "mongrel" user name and
my db access is specified in the database.yml to be some other user.
So why is the system trying to use root@localhost (which I don't have
defined in db) and why is it not picking the username and password
specified in the database.yml file?
Thanks for any pointers/thoughts.