db error when running installation on Resin

[cifo]

I am trying to run the installation and I get this db error (copied from log file):

---------------
Apr 04 2009 17:56 -- database_setup
FATAL: Connection to Database failed -

---------------
Apr 04 2009 17:56 -- database_setup1
Installer - Page: database_setup -- collected information: Array
(
[language] => english
[DIR_FS_SQL_CACHE] => /C:/resin-3.1.8/webapps/zencart/cache
[DB_TYPE] => mysql
[DB_PREFIX] =>
[DB_SERVER] => localhost
[DB_SERVER_USERNAME] => root
[DB_SERVER_PASSWORD] => WVdKak1USXo=
[DB_DATABASE] => zencart
[STORE_SESSIONS] => db
[USE_PCONNECT] =>
[SQL_CACHE_METHOD] => none
)

I followed the tutorials closely, with no success.
I am able to log into mysql with user ("root") and the given password (hashed in the log above). I also created the database "zencart". I made sure that the database side is correct by (double) checking with ToadForMySQL.

The suspect at this moment is Resin and the way it executes the command to connect to mysql.

Did anyone run into similar problems?

How can I capture the command that gets executed to connect to the database?

[DrByte]

I'm not sure what exactly you're trying to do with Resin.

Zen Cart runs PHP, and PHP does the connection to MySQL using the mysql_connect() function.
It would seem like your PHP configuration isn't talking to the database successfully.
Perhaps it's missing the appropriate MySQL Connector?

Why specifically are you using Resin instead of something much more traditional and robust like Apache?

[cifo]

I thought of using resin because of its ease of use. PHP seems to be supported out of the box in Resin (I did not have to install PHP). They even claim that it is much faster than Apache/Tomcat + PHP (This is my first contact with PHP, so I cannot vouch for that).
Anyway, the php pages seem to get executed by Resin (index.php etc), as opposed to Apache, where I have to explicitly install PHP (index.php is shown as file content, I tried).
So, I intended to make this my next step: install PHP and try zen-cart with Apache/Tomcat.
But it is still pretty annoying, not understanding what is going on.

Thank you, anyway. Any other suggestions you may have regarding this, please don't hesitate to post.

And, if I don't ask for too much, when you have 5 minutes, please try to replicate this experiment (installing zen-cart on Resin). Downloading and installing Resin is, honestly, the quickest software of this kind (and I have no affiliation with the company).
http://www.caucho.com/download/
This was the first reason I installed it myself. Quick and painless.

Well, again, thank you.

[cifo]

DrByte, your post was really helpful. I solved it, thanks again.
Resin uses some Java-implementation of PHP, so the db connector was missing.
This article tells how to install db support for PHP:
http://www.caucho.com/resin/doc/quercus.xtp#databases

All I did was download the connector for mysql and copy some jars in the lib directory of Resin. Unbelievably, it worked.

Thanks again. It is not for nothing they call you "Dr"

[tony_sar]

this is first time hearing about this program . and base on what i can see on the site , you might have to configure resin to communicate with MYSQL . default install of this program might have been configured to use different database ..

[cifo]

The HTTP server is reportedly named "Apache PHP Quercus(3.1.8)"

You should check it out. The easiest ever and very small footprint, perfect for my needs (small number of connections).

Everybody in this forum from Canada (I am) :) ?