JAgadish,
I went ahead and undeployed my javaBridge and my JavaBridge2
then I redeployed to make sure that I was not missing any steps using
the instructions from:
http://www2.sebastiendionne.ca:8282/glassfish/joomla-on-glassfish.html
But I am back to the error message:
Database Error: Unable to connect to the database:The MySQL adapter "mysql"
is not available.
Well, I know that php works because I can see the test php programs from
JavaBridge working but I just do not know how to tell Glassfish to access
the database. Althought when I ping the mysql jdbc-connection-pool it is
sucessful.
Going to sleep. I will try again tomorro.
Thanks,
:-)
On Wed, Dec 17, 2008 at 10:31 PM, Néstor <rotsen_at_gmail.com> wrote:
> Jagadish,I did as you requested and I am able to ping the database but
> when I go to
> http://127.0.0.1:8080/JavaBridge2/ <http://127.0.0.1:8080/JavaBridge2/> I
> get the error:
> Database Error: Unable to connect to the database:The MySQL adapter "mysql"
> is not available.
>
> The jdbc-connection-pool looks like this:
> ------------------
> <jdbc-connection-pool allow-non-component-callers="false"
> associate-with-thread="false" connection-creation-retry-attempts="0"
> connection-creation-retry-interval-in-seconds="10"
> connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> connection-validation-method="auto-commit"
> datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
> fail-all-connections="false" idle-timeout-in-seconds="300"
> is-connection-validation-required="false"
> is-isolation-level-guaranteed="true" lazy-connection-association="false"
> lazy-connection-enlistment="false" match-connections="false"
> max-connection-usage-count="0" max-pool-size="32"
> max-wait-time-in-millis="60000" name="mysql-pool"
> non-transactional-connections="false" pool-resize-quantity="2"
> res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1"
> steady-pool-size="8" validate-atmost-once-period-in-seconds="0"
> wrap-jdbc-objects="false">
> <property name="user" value="root"/>
> <property name="url" value="jdbc:mysql://localhost:3306/joomla"/>
> <property name="password" value="loco"/>
> </jdbc-connection-pool
> -----------------------
>
> THe jbc-connection matches my settings for the joomla configuration.php
> file:
> -------------------
> /* Database Settings */
> var $dbtype = 'mysql';
> var $host = 'localhost';
> var $user = 'root';
> var $password = 'loco';
> var $db = 'joomla';
> var $dbprefix = 'jos_';
> -------------------------
>
> :-)
>
>
> On Wed, Dec 17, 2008 at 10:11 PM, Néstor <rotsen_at_gmail.com> wrote:
>
>> Jagadish,
>> When I click on the link I get a blank page.
>>
>> I will try to set up the jdbc-connection-pool to look just like the
>> included example.
>>
>> :-)
>>
>>
>> On Wed, Dec 17, 2008 at 9:02 PM, Jagadish Prasath Ramu <
>> Jagadish.Ramu_at_sun.com> wrote:
>>
>>> I could see the contents of the template :
>>>
>>> http://blogs.sun.com/JagadishPrasath/resource/conpool-templates/mysql_type4_datasource.xml
>>>
>>> For reference :
>>>
>>> ----------------------------Snippet---------------------------------------------------------------------
>>> <jdbc-connection-pool name="mysql-pool"
>>> datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
>>> res-type="javax.sql.DataSource">
>>> <property name="user" value="DB_USER"/>
>>> <property name="password" value="DB_PASSWORD"/>
>>> <property name="url"
>>> value="jdbc:mysql://DB_HOSTNAME:3306/DATABASE_NAME"/>
>>> </jdbc-connection-pool>
>>> <jdbc-resource enabled="true" jndi-name="jdbc/mysql-resource"
>>> object-type="user" pool-name="mysql-pool"/>
>>>
>>> ----------------------------Snippet---------------------------------------------------------------------
>>>
>>> can you try setting it according to the config posted above and do a
>>> ping connection pool?
>>> If ping fails, you will see exceptions logged in server.log
>>> (GF_INSTALL_DIR/domains/<domain1>/logs/server.log
>>> Please post the exception messages.
>>>
>>> Thanks,
>>> -Jagadish
>>>
>>>
>>>
>>> On Wed, 2008-12-17 at 20:42 -0800, Néstor wrote:
>>> > Jagadish,
>>> >
>>> >
>>> > Yes, I do hace access from localhost to mysql. I can log in from
>>> > command line and also via joomla/apache I can acccess the joomla
>>> > database.
>>> >
>>> >
>>> > I went earlier to the template database page but when you click on the
>>> > mysql_type4_datasource.xml, the file is empty. I also downloaded
>>> > mysql-connector-java-5.0.8-bin.jar yesterday and put it in the
>>> > directory
>>> >
>>> > C:\glassfish\lib
>>> >
>>> >
>>> > I think this is what you asked from the domain.xml file.
>>> > <jdbc-connection-pool allow-non-component-callers="true"
>>> > associate-with-thread="false" connection-creation-retry-attempts="0"
>>> > connection-creation-retry-interval-in-seconds="10"
>>> > connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
>>> > connection-validation-method="auto-commit"
>>> >
>>> datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"
>>> fail-all-connections="false" idle-timeout-in-seconds="300"
>>> is-connection-validation-required="false"
>>> is-isolation-level-guaranteed="true" lazy-connection-association="false"
>>> lazy-connection-enlistment="false" match-connections="false"
>>> max-connection-usage-count="0" max-pool-size="32"
>>> max-wait-time-in-millis="60000" name="mysql-pool"
>>> non-transactional-connections="false" pool-resize-quantity="2"
>>> res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1"
>>> steady-pool-size="8" validate-atmost-once-period-in-seconds="0"
>>> wrap-jdbc-objects="false">
>>> > <property name="datasourceName" value="mysql"/>
>>> > <property name="port" value="3306"/>
>>> > <property name="user" value="root"/>
>>> > <property name="password" value="loco"/>
>>> > <property name="databaseName" value="test"/>
>>> > <property name="serverName" value="localhost"/>
>>> > </jdbc-connection-pool>
>>> >
>>> >
>>> > Thanks,
>>> >
>>> >
>>> > Nestor :-)
>>> >
>>> >
>>> >
>>> >
>>> > On Wed, Dec 17, 2008 at 8:06 PM, Jagadish Prasath Ramu
>>> > <Jagadish.Ramu_at_sun.com> wrote:
>>> > Can you post your connection pool configuration ?
>>> > [you can find it in
>>> > GF_INSTALLATION_DIR/domains/<domain1>/config/domain.xml,
>>> > element
>>> > jdbc-connection-pool with your pool name]
>>> >
>>> >
>>> http://blogs.sun.com/JagadishPrasath/entry/jdbc_connection_pool_templates_glassfish
>>> >
>>> > has a template for MySQL (necessary properties to connect to
>>> > database)
>>> >
>>> > * Also, you may have to check whether MySQL is configured to
>>> > allow
>>> > access from your machine
>>> >
>>> > Thanks,
>>> > -Jagadish
>>> >
>>> >
>>> >
>>> > On Wed, 2008-12-17 at 19:44 -0800, Néstor wrote:
>>> > > I did the ping and I get an error:
>>> > > An error has occurred
>>> > > Access denied for user ''@'localhost' (using password:
>>> > NO)
>>> > >
>>> > >
>>> > >
>>> > > That means that somehow glassfish is using a user that has
>>> > no access
>>> > > permission.
>>> > > Or a user has not been configure, where do I caonfigure the
>>> > user in
>>> > > glassfisg?
>>> > >
>>> > >
>>> > > I know that the user that joomla is using is correct because
>>> > I can
>>> > > access mysql using joomla.
>>> > >
>>> > >
>>> > > Rotsen :-)
>>> > >
>>> > > On Tue, Dec 16, 2008 at 11:25 PM, Jagadish Prasath Ramu
>>> > > <Jagadish.Ramu_at_sun.com> wrote:
>>> > > Following URLs may be helpful :
>>> > > http://forums.mysql.com/read.php?10,155771,155771
>>> > > http://forum.joomla.org/viewtopic.php?f=429&t=206631
>>> > >
>>> > >
>>> > > This exception does not seem to come from MySQL or
>>> > GlassFish.
>>> > > Do you see any exception in GlassFish's server.log ?
>>> > > [GF_INSTALL_DIR/domains/<domain1>/logs]
>>> > >
>>> > > You can do "ping" on the connection pool created on
>>> > GlassFish
>>> > > to see
>>> > > whether your database related settings are correct.
>>> > > Access admin GUI, select the jdbc-connection-pool
>>> > and do ping.
>>> > >
>>> >
>>> http://blogs.sun.com/JagadishPrasath/entry/creating_jdbc_connection_pool_resource
>>> > >
>>> >
>>> http://blogs.sun.com/JagadishPrasath/entry/jdbc_connection_pool_templates_glassfish
>>> > >
>>> > > Thanks,
>>> > > -Jagadish
>>> > >
>>> > >
>>> > > On Tue, 2008-12-16 at 22:59 -0800, Néstor wrote:
>>> > > > I was sucessful at getting glassfish and
>>> > JavaBridge running
>>> > > but now I
>>> > > > am trying to run Joomla
>>> > > > with glassfish using the example
>>> > > > in
>>> > >
>>> >
>>> http://www2.sebastiendionne.ca:8282/glassfish/joomla-on-glassfish.html
>>> > > >
>>> > > >
>>> > > > When I try to access
>>> > > http://127.0.0.1:8080/JavaBridge2/joomla/ I get
>>> > > > the error:
>>> > > > Database Error: Unable to connect to the
>>> > database:The MySQL
>>> > > adapter
>>> > > > "mysql" is not available.
>>> > > >
>>> > > >
>>> > > >
>>> > > > I even create a JDBC COnnection and a JDBC
>>> > resource as
>>> > > describe in
>>> > > > this page:
>>> > > >
>>> > >
>>> >
>>> http://blog.linkedin.com/2008/08/19/jdbc-connection-pooling-for-rails-on-glassfish/
>>> > > >
>>> > > >
>>> > > > After searching the net, most people with this
>>> > problem is
>>> > > because they
>>> > > > are not able to access
>>> > > > mysql with php and ISS but my joomla/php/apache
>>> > has not
>>> > > problem
>>> > > > accessing mysql.
>>> > > >
>>> > > >
>>> > > > ANt ideas on how do I make glassfish talk to
>>> > mysql.?
>>> > > >
>>> > > >
>>> > > > Thanks,
>>> > > >
>>> > > >
>>> > > > Nestor :-)
>>> > > >
>>> > > >
>>> > > >
>>> > > >
>>> > >
>>> > >
>>> > >
>>> > >
>>> >
>>> ---------------------------------------------------------------------
>>> > > To unsubscribe, e-mail:
>>> > > users-unsubscribe_at_glassfish.dev.java.net
>>> > > For additional commands, e-mail:
>>> > > users-help_at_glassfish.dev.java.net
>>> > >
>>> > >
>>> > >
>>> >
>>> >
>>> >
>>> ---------------------------------------------------------------------
>>> > To unsubscribe, e-mail:
>>> > users-unsubscribe_at_glassfish.dev.java.net
>>> > For additional commands, e-mail:
>>> > users-help_at_glassfish.dev.java.net
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
>>> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>>>
>>>
>>
>