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
>>
>>
>