You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by raúl fuenzalida <ae...@gmail.com> on 2009/03/31 03:08:00 UTC

database connection error

I'm installing Roller on Glassfish and when I launch Roller, appears
the Database Connection Error page

this is an image of the roller-custom.propierties file
http://tinyurl.com/cggzxx

this is how I've created the mysql database
http://tinyurl.com/ckjgah

and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
into the directories AppServer\lib and AppServer\domains\domain1\lib

help please

thanks in advance

Re: database connection error

Posted by raúl fuenzalida <ae...@gmail.com>.
well:

the solution I found was to reinstall glassfish without mysql and
install mysql appart, so i can configure mysql independently

thank you very much

raúl f.



-- 
http://www.transitorio.cl/

Re: database connection error

Posted by "Ing. Alfonso Romero" <ib...@prodigy.net.mx>.
I assume you´re using Windows...
Go to the MySQL Server Instance Configuration Wizard (Start | Programs | 
MySQL) and reconfigure your MySQL instance. That means you´re going to see 
all the instalation options again. There has to be a screen for network 
options, and that´s where you can select Enable TCP/IP Networking.

----- Original Message ----- 
From: "raúl fuenzalida" <ae...@gmail.com>
To: <us...@roller.apache.org>
Sent: Tuesday, March 31, 2009 12:34 AM
Subject: Re: database connection error


I don't remember if it ask that option. but i remember that it ask if
i want to enable "Windows services" for mysql ... and chose no

I can't find the my.cnf file. where is it?

On Mon, Mar 30, 2009 at 10:14 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:d
> Did you select the Enable TCP/IP Networking option when you installed it?
>
> ----- Original Message ----- From: "raúl fuenzalida" 
> <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 8:04 PM
> Subject: Re: database connection error
>
>
> how do i do that?
>
> I install the glassfish-mysql bundle
>
> to do the database I went to Sun\AppServer\mysql\bin and run mysql.exe
>
>
>
> On Mon, Mar 30, 2009 at 9:50 PM, Ing. Alfonso Romero
> <ib...@prodigy.net.mx> wrote:
>>
>> Did you enable TCP/IP on MySQL?
>>
>> ----- Original Message ----- From: "raúl fuenzalida"
>> <ae...@gmail.com>
>> To: <us...@roller.apache.org>
>> Sent: Monday, March 30, 2009 7:25 PM
>> Subject: Re: database connection error
>>
>>
>> yes, the three files are in the lib folder:
>> activation.jar
>> mail.jar
>> mysql-connector-java-5.1.6-bin.jar
>>
>> this is an image of the Database Connection Error page
>> http://tinyurl.com/dl2yj6
>>
>> On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
>> <ib...@prodigy.net.mx> wrote:
>>>
>>> Do you have activation.jar and mail.jar inside the lib folder, too?
>>> ----- Original Message ----- From: "raúl fuenzalida"
>>> <ae...@gmail.com>
>>> To: <us...@roller.apache.org>
>>> Sent: Monday, March 30, 2009 7:08 PM
>>> Subject: database connection error
>>>
>>>
>>>> I'm installing Roller on Glassfish and when I launch Roller, appears
>>>> the Database Connection Error page
>>>>
>>>> this is an image of the roller-custom.propierties file
>>>> http://tinyurl.com/cggzxx
>>>>
>>>> this is how I've created the mysql database
>>>> http://tinyurl.com/ckjgah
>>>>
>>>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>>>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>>>
>>>> help please
>>>>
>>>> thanks in advance
>>>>
>>>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>>>
>>>> Este mensaje ha sido analizado con NOD32 antivirus system
>>>> http://www.nod32.com
>>>>
>>>>
>>>
>>>
>>
>>
>>
>> --
>> http://www.transitorio.cl/
>>
>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>
>> Este mensaje ha sido analizado con NOD32 antivirus system
>> http://www.nod32.com
>>
>>
>>
>
>
>
> --
> http://www.transitorio.cl/
>
> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>
> Este mensaje ha sido analizado con NOD32 antivirus system
> http://www.nod32.com
>
>
>



-- 
http://www.transitorio.cl/

__________ Informacin de NOD32, revisin 3976 (20090330) __________

Este mensaje ha sido analizado con  NOD32 antivirus system
http://www.nod32.com



Re: database connection error

Posted by raúl fuenzalida <ae...@gmail.com>.
I don't remember if it ask that option. but i remember that it ask if
i want to enable "Windows services" for mysql ... and chose no

I can't find the my.cnf file. where is it?

On Mon, Mar 30, 2009 at 10:14 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:d
> Did you select the Enable TCP/IP Networking option when you installed it?
>
> ----- Original Message ----- From: "raúl fuenzalida" <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 8:04 PM
> Subject: Re: database connection error
>
>
> how do i do that?
>
> I install the glassfish-mysql bundle
>
> to do the database I went to Sun\AppServer\mysql\bin and run mysql.exe
>
>
>
> On Mon, Mar 30, 2009 at 9:50 PM, Ing. Alfonso Romero
> <ib...@prodigy.net.mx> wrote:
>>
>> Did you enable TCP/IP on MySQL?
>>
>> ----- Original Message ----- From: "raúl fuenzalida"
>> <ae...@gmail.com>
>> To: <us...@roller.apache.org>
>> Sent: Monday, March 30, 2009 7:25 PM
>> Subject: Re: database connection error
>>
>>
>> yes, the three files are in the lib folder:
>> activation.jar
>> mail.jar
>> mysql-connector-java-5.1.6-bin.jar
>>
>> this is an image of the Database Connection Error page
>> http://tinyurl.com/dl2yj6
>>
>> On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
>> <ib...@prodigy.net.mx> wrote:
>>>
>>> Do you have activation.jar and mail.jar inside the lib folder, too?
>>> ----- Original Message ----- From: "raúl fuenzalida"
>>> <ae...@gmail.com>
>>> To: <us...@roller.apache.org>
>>> Sent: Monday, March 30, 2009 7:08 PM
>>> Subject: database connection error
>>>
>>>
>>>> I'm installing Roller on Glassfish and when I launch Roller, appears
>>>> the Database Connection Error page
>>>>
>>>> this is an image of the roller-custom.propierties file
>>>> http://tinyurl.com/cggzxx
>>>>
>>>> this is how I've created the mysql database
>>>> http://tinyurl.com/ckjgah
>>>>
>>>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>>>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>>>
>>>> help please
>>>>
>>>> thanks in advance
>>>>
>>>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>>>
>>>> Este mensaje ha sido analizado con NOD32 antivirus system
>>>> http://www.nod32.com
>>>>
>>>>
>>>
>>>
>>
>>
>>
>> --
>> http://www.transitorio.cl/
>>
>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>
>> Este mensaje ha sido analizado con NOD32 antivirus system
>> http://www.nod32.com
>>
>>
>>
>
>
>
> --
> http://www.transitorio.cl/
>
> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>
> Este mensaje ha sido analizado con  NOD32 antivirus system
> http://www.nod32.com
>
>
>



-- 
http://www.transitorio.cl/

Re: database connection error

Posted by "Ing. Alfonso Romero" <ib...@prodigy.net.mx>.
Did you select the Enable TCP/IP Networking option when you installed it?

----- Original Message ----- 
From: "raúl fuenzalida" <ae...@gmail.com>
To: <us...@roller.apache.org>
Sent: Monday, March 30, 2009 8:04 PM
Subject: Re: database connection error


how do i do that?

I install the glassfish-mysql bundle

to do the database I went to Sun\AppServer\mysql\bin and run mysql.exe



On Mon, Mar 30, 2009 at 9:50 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:
> Did you enable TCP/IP on MySQL?
>
> ----- Original Message ----- From: "raúl fuenzalida" 
> <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 7:25 PM
> Subject: Re: database connection error
>
>
> yes, the three files are in the lib folder:
> activation.jar
> mail.jar
> mysql-connector-java-5.1.6-bin.jar
>
> this is an image of the Database Connection Error page
> http://tinyurl.com/dl2yj6
>
> On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
> <ib...@prodigy.net.mx> wrote:
>>
>> Do you have activation.jar and mail.jar inside the lib folder, too?
>> ----- Original Message ----- From: "raúl fuenzalida"
>> <ae...@gmail.com>
>> To: <us...@roller.apache.org>
>> Sent: Monday, March 30, 2009 7:08 PM
>> Subject: database connection error
>>
>>
>>> I'm installing Roller on Glassfish and when I launch Roller, appears
>>> the Database Connection Error page
>>>
>>> this is an image of the roller-custom.propierties file
>>> http://tinyurl.com/cggzxx
>>>
>>> this is how I've created the mysql database
>>> http://tinyurl.com/ckjgah
>>>
>>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>>
>>> help please
>>>
>>> thanks in advance
>>>
>>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>>
>>> Este mensaje ha sido analizado con NOD32 antivirus system
>>> http://www.nod32.com
>>>
>>>
>>
>>
>
>
>
> --
> http://www.transitorio.cl/
>
> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>
> Este mensaje ha sido analizado con NOD32 antivirus system
> http://www.nod32.com
>
>
>



-- 
http://www.transitorio.cl/

__________ Informacin de NOD32, revisin 3976 (20090330) __________

Este mensaje ha sido analizado con  NOD32 antivirus system
http://www.nod32.com



Re: database connection error

Posted by "Ing. Alfonso Romero" <ib...@prodigy.net.mx>.
check into your my.cnf file (the configuration file for MySQL), the 
following line:

#skip-networking

must be commented, so MySQL can listen to the TCP/IP port.

----- Original Message ----- 
From: "raúl fuenzalida" <ae...@gmail.com>
To: <us...@roller.apache.org>
Sent: Monday, March 30, 2009 8:04 PM
Subject: Re: database connection error


how do i do that?

I install the glassfish-mysql bundle

to do the database I went to Sun\AppServer\mysql\bin and run mysql.exe



On Mon, Mar 30, 2009 at 9:50 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:
> Did you enable TCP/IP on MySQL?
>
> ----- Original Message ----- From: "raúl fuenzalida" 
> <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 7:25 PM
> Subject: Re: database connection error
>
>
> yes, the three files are in the lib folder:
> activation.jar
> mail.jar
> mysql-connector-java-5.1.6-bin.jar
>
> this is an image of the Database Connection Error page
> http://tinyurl.com/dl2yj6
>
> On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
> <ib...@prodigy.net.mx> wrote:
>>
>> Do you have activation.jar and mail.jar inside the lib folder, too?
>> ----- Original Message ----- From: "raúl fuenzalida"
>> <ae...@gmail.com>
>> To: <us...@roller.apache.org>
>> Sent: Monday, March 30, 2009 7:08 PM
>> Subject: database connection error
>>
>>
>>> I'm installing Roller on Glassfish and when I launch Roller, appears
>>> the Database Connection Error page
>>>
>>> this is an image of the roller-custom.propierties file
>>> http://tinyurl.com/cggzxx
>>>
>>> this is how I've created the mysql database
>>> http://tinyurl.com/ckjgah
>>>
>>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>>
>>> help please
>>>
>>> thanks in advance
>>>
>>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>>
>>> Este mensaje ha sido analizado con NOD32 antivirus system
>>> http://www.nod32.com
>>>
>>>
>>
>>
>
>
>
> --
> http://www.transitorio.cl/
>
> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>
> Este mensaje ha sido analizado con NOD32 antivirus system
> http://www.nod32.com
>
>
>



-- 
http://www.transitorio.cl/

__________ Informacin de NOD32, revisin 3976 (20090330) __________

Este mensaje ha sido analizado con  NOD32 antivirus system
http://www.nod32.com



Re: database connection error

Posted by raúl fuenzalida <ae...@gmail.com>.
how do i do that?

I install the glassfish-mysql bundle

to do the database I went to Sun\AppServer\mysql\bin and run mysql.exe



On Mon, Mar 30, 2009 at 9:50 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:
> Did you enable TCP/IP on MySQL?
>
> ----- Original Message ----- From: "raúl fuenzalida" <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 7:25 PM
> Subject: Re: database connection error
>
>
> yes, the three files are in the lib folder:
> activation.jar
> mail.jar
> mysql-connector-java-5.1.6-bin.jar
>
> this is an image of the Database Connection Error page
> http://tinyurl.com/dl2yj6
>
> On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
> <ib...@prodigy.net.mx> wrote:
>>
>> Do you have activation.jar and mail.jar inside the lib folder, too?
>> ----- Original Message ----- From: "raúl fuenzalida"
>> <ae...@gmail.com>
>> To: <us...@roller.apache.org>
>> Sent: Monday, March 30, 2009 7:08 PM
>> Subject: database connection error
>>
>>
>>> I'm installing Roller on Glassfish and when I launch Roller, appears
>>> the Database Connection Error page
>>>
>>> this is an image of the roller-custom.propierties file
>>> http://tinyurl.com/cggzxx
>>>
>>> this is how I've created the mysql database
>>> http://tinyurl.com/ckjgah
>>>
>>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>>
>>> help please
>>>
>>> thanks in advance
>>>
>>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>>
>>> Este mensaje ha sido analizado con NOD32 antivirus system
>>> http://www.nod32.com
>>>
>>>
>>
>>
>
>
>
> --
> http://www.transitorio.cl/
>
> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>
> Este mensaje ha sido analizado con  NOD32 antivirus system
> http://www.nod32.com
>
>
>



-- 
http://www.transitorio.cl/

Re: database connection error

Posted by "Ing. Alfonso Romero" <ib...@prodigy.net.mx>.
Did you enable TCP/IP on MySQL?

----- Original Message ----- 
From: "raúl fuenzalida" <ae...@gmail.com>
To: <us...@roller.apache.org>
Sent: Monday, March 30, 2009 7:25 PM
Subject: Re: database connection error


yes, the three files are in the lib folder:
activation.jar
mail.jar
mysql-connector-java-5.1.6-bin.jar

this is an image of the Database Connection Error page
http://tinyurl.com/dl2yj6

On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:
> Do you have activation.jar and mail.jar inside the lib folder, too?
> ----- Original Message ----- From: "raúl fuenzalida" 
> <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 7:08 PM
> Subject: database connection error
>
>
>> I'm installing Roller on Glassfish and when I launch Roller, appears
>> the Database Connection Error page
>>
>> this is an image of the roller-custom.propierties file
>> http://tinyurl.com/cggzxx
>>
>> this is how I've created the mysql database
>> http://tinyurl.com/ckjgah
>>
>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>
>> help please
>>
>> thanks in advance
>>
>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>
>> Este mensaje ha sido analizado con NOD32 antivirus system
>> http://www.nod32.com
>>
>>
>
>



-- 
http://www.transitorio.cl/

__________ Informacin de NOD32, revisin 3976 (20090330) __________

Este mensaje ha sido analizado con  NOD32 antivirus system
http://www.nod32.com



Re: database connection error

Posted by raúl fuenzalida <ae...@gmail.com>.
yes, the three files are in the lib folder:
activation.jar
mail.jar
mysql-connector-java-5.1.6-bin.jar

this is an image of the Database Connection Error page
http://tinyurl.com/dl2yj6

On Mon, Mar 30, 2009 at 9:15 PM, Ing. Alfonso Romero
<ib...@prodigy.net.mx> wrote:
> Do you have activation.jar and mail.jar inside the lib folder, too?
> ----- Original Message ----- From: "raúl fuenzalida" <ae...@gmail.com>
> To: <us...@roller.apache.org>
> Sent: Monday, March 30, 2009 7:08 PM
> Subject: database connection error
>
>
>> I'm installing Roller on Glassfish and when I launch Roller, appears
>> the Database Connection Error page
>>
>> this is an image of the roller-custom.propierties file
>> http://tinyurl.com/cggzxx
>>
>> this is how I've created the mysql database
>> http://tinyurl.com/ckjgah
>>
>> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
>> into the directories AppServer\lib and AppServer\domains\domain1\lib
>>
>> help please
>>
>> thanks in advance
>>
>> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>>
>> Este mensaje ha sido analizado con  NOD32 antivirus system
>> http://www.nod32.com
>>
>>
>
>



-- 
http://www.transitorio.cl/

Re: database connection error

Posted by "Ing. Alfonso Romero" <ib...@prodigy.net.mx>.
Do you have activation.jar and mail.jar inside the lib folder, too?
----- Original Message ----- 
From: "raúl fuenzalida" <ae...@gmail.com>
To: <us...@roller.apache.org>
Sent: Monday, March 30, 2009 7:08 PM
Subject: database connection error


> I'm installing Roller on Glassfish and when I launch Roller, appears
> the Database Connection Error page
>
> this is an image of the roller-custom.propierties file
> http://tinyurl.com/cggzxx
>
> this is how I've created the mysql database
> http://tinyurl.com/ckjgah
>
> and I've verified that the mysql-connector-java-5.1.6-bin.jar file is
> into the directories AppServer\lib and AppServer\domains\domain1\lib
>
> help please
>
> thanks in advance
>
> __________ Informacin de NOD32, revisin 3976 (20090330) __________
>
> Este mensaje ha sido analizado con  NOD32 antivirus system
> http://www.nod32.com
>
>