You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Abel MacAdam <ab...@gmail.com> on 2008/07/17 12:57:46 UTC
Jetspeed and MySQL?
Hi,
At the moment I'm bootstrapping Jetspeed-2. After finding out I had a
corrupt installer, and finding a new one, I could start the installer. At
one moment the installer asked my to what database it should connect. I
choose MySQL (which I re-installed for Jetspeed). This is what I filled in:
Database User Name: root
Database Password: <MyRootPassword>
JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed
JDBC Driver Classname: com.mysql.jdbc.Driver
JDBC driver:
D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar
As database user name I choose the same username and password as for my
MySQL installation. Is that the wise choice, or should I choose something
like:
Database User Name: <jetspeed-user>
Database Password: <MyJetspeedPassword>
The JDBC driver is also newly installed, in the location I indicated above.
When the installer tests the database connection I get a "Connection to the
database failed". What am I doing wrong?
Abel
--
View this message in context: http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html
Sent from the Jetspeed - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Jetspeed and MySQL?
Posted by Ron Wheeler <rw...@artifact-software.com>.
Did you create the database called Jetspeed with access rights for root?
You are trying to connect to jetspeed so it should be there.
Otherwise, your string looks good.
I would not use root for the database user just in case you ever want to
put this into a production environment.
Might as well start with a Jetspeed user that can work with more limited
powers.
For screwing about on your own machine it doesn't matter.
Ron
Abel MacAdam wrote:
> I looked up an easy application, added a JDBC jar file, compiled it and ran
> it. It works as expected.P-( So no exception that can enlighten me.
>
>
> ghufran-2 wrote:
>
>> Try to create a small java application to check the db connectivity
>>
>> Actually you need to see the exception that it throws
>> The exception will give you idea of the problem
>>
>> Once the problem is identified, you will be able to fix it accordingly
>>
>>
>> Ghufran
>>
>> -----Original Message-----
>> From: Abel MacAdam [mailto:abel.macadam@gmail.com]
>> Sent: Thursday, July 17, 2008 4:28 PM
>> To: jetspeed-user@portals.apache.org
>> Subject: RE: Jetspeed and MySQL?
>>
>>
>> Hi Ghufran,
>>
>> Thanks for your reply. I tried what you suggested, but no luck. I still
>> get
>> the "Connection to the
>> database failed" when the installer is testing the connection.
>>
>> Abel
>>
>>
>> ghufran-2 wrote:
>>
>>> Try to give permission to the user
>>> Run this sql
>>> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
>>>
>>> If you are accessing it from different computer then type your ip instead
>>> of
>>> localhost in the above sql
>>>
>>>
>>> Hope it helps
>>>
>>> Regards
>>> Ghufran
>>>
>>> -----Original Message-----
>>> From: Abel MacAdam [mailto:abel.macadam@gmail.com]
>>> Sent: Thursday, July 17, 2008 3:58 PM
>>> To: jetspeed-user@portals.apache.org
>>> Subject: Jetspeed and MySQL?
>>>
>>>
>>> Hi,
>>>
>>> At the moment I'm bootstrapping Jetspeed-2. After finding out I had a
>>> corrupt installer, and finding a new one, I could start the installer. At
>>> one moment the installer asked my to what database it should connect. I
>>> choose MySQL (which I re-installed for Jetspeed). This is what I filled
>>> in:
>>> Database User Name: root
>>> Database Password: <MyRootPassword>
>>> JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed
>>> JDBC Driver Classname: com.mysql.jdbc.Driver
>>> JDBC driver:
>>> D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar
>>>
>>> As database user name I choose the same username and password as for my
>>> MySQL installation. Is that the wise choice, or should I choose something
>>> like:
>>> Database User Name: <jetspeed-user>
>>> Database Password: <MyJetspeedPassword>
>>>
>>> The JDBC driver is also newly installed, in the location I indicated
>>> above.
>>>
>>> When the installer tests the database connection I get a "Connection to
>>> the
>>> database failed". What am I doing wrong?
>>>
>>> Abel
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html
>>> Sent from the Jetspeed - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>>
>>>
>>>
>>>
>> --
>> View this message in context:
>> http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506394.html
>> Sent from the Jetspeed - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>
>>
>>
>>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: Jetspeed and MySQL?
Posted by Abel MacAdam <ab...@gmail.com>.
I looked up an easy application, added a JDBC jar file, compiled it and ran
it. It works as expected.P-( So no exception that can enlighten me.
ghufran-2 wrote:
>
> Try to create a small java application to check the db connectivity
>
> Actually you need to see the exception that it throws
> The exception will give you idea of the problem
>
> Once the problem is identified, you will be able to fix it accordingly
>
>
> Ghufran
>
> -----Original Message-----
> From: Abel MacAdam [mailto:abel.macadam@gmail.com]
> Sent: Thursday, July 17, 2008 4:28 PM
> To: jetspeed-user@portals.apache.org
> Subject: RE: Jetspeed and MySQL?
>
>
> Hi Ghufran,
>
> Thanks for your reply. I tried what you suggested, but no luck. I still
> get
> the "Connection to the
> database failed" when the installer is testing the connection.
>
> Abel
>
>
> ghufran-2 wrote:
>>
>> Try to give permission to the user
>> Run this sql
>> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
>>
>> If you are accessing it from different computer then type your ip instead
>> of
>> localhost in the above sql
>>
>>
>> Hope it helps
>>
>> Regards
>> Ghufran
>>
>> -----Original Message-----
>> From: Abel MacAdam [mailto:abel.macadam@gmail.com]
>> Sent: Thursday, July 17, 2008 3:58 PM
>> To: jetspeed-user@portals.apache.org
>> Subject: Jetspeed and MySQL?
>>
>>
>> Hi,
>>
>> At the moment I'm bootstrapping Jetspeed-2. After finding out I had a
>> corrupt installer, and finding a new one, I could start the installer. At
>> one moment the installer asked my to what database it should connect. I
>> choose MySQL (which I re-installed for Jetspeed). This is what I filled
>> in:
>> Database User Name: root
>> Database Password: <MyRootPassword>
>> JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed
>> JDBC Driver Classname: com.mysql.jdbc.Driver
>> JDBC driver:
>> D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar
>>
>> As database user name I choose the same username and password as for my
>> MySQL installation. Is that the wise choice, or should I choose something
>> like:
>> Database User Name: <jetspeed-user>
>> Database Password: <MyJetspeedPassword>
>>
>> The JDBC driver is also newly installed, in the location I indicated
>> above.
>>
>> When the installer tests the database connection I get a "Connection to
>> the
>> database failed". What am I doing wrong?
>>
>> Abel
>> --
>> View this message in context:
>> http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html
>> Sent from the Jetspeed - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506394.html
> Sent from the Jetspeed - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506946.html
Sent from the Jetspeed - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: Jetspeed and MySQL?
Posted by Ghufran <gh...@vopium.com>.
Try to create a small java application to check the db connectivity
Actually you need to see the exception that it throws
The exception will give you idea of the problem
Once the problem is identified, you will be able to fix it accordingly
Ghufran
-----Original Message-----
From: Abel MacAdam [mailto:abel.macadam@gmail.com]
Sent: Thursday, July 17, 2008 4:28 PM
To: jetspeed-user@portals.apache.org
Subject: RE: Jetspeed and MySQL?
Hi Ghufran,
Thanks for your reply. I tried what you suggested, but no luck. I still get
the "Connection to the
database failed" when the installer is testing the connection.
Abel
ghufran-2 wrote:
>
> Try to give permission to the user
> Run this sql
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
>
> If you are accessing it from different computer then type your ip instead
> of
> localhost in the above sql
>
>
> Hope it helps
>
> Regards
> Ghufran
>
> -----Original Message-----
> From: Abel MacAdam [mailto:abel.macadam@gmail.com]
> Sent: Thursday, July 17, 2008 3:58 PM
> To: jetspeed-user@portals.apache.org
> Subject: Jetspeed and MySQL?
>
>
> Hi,
>
> At the moment I'm bootstrapping Jetspeed-2. After finding out I had a
> corrupt installer, and finding a new one, I could start the installer. At
> one moment the installer asked my to what database it should connect. I
> choose MySQL (which I re-installed for Jetspeed). This is what I filled
> in:
> Database User Name: root
> Database Password: <MyRootPassword>
> JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed
> JDBC Driver Classname: com.mysql.jdbc.Driver
> JDBC driver:
> D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar
>
> As database user name I choose the same username and password as for my
> MySQL installation. Is that the wise choice, or should I choose something
> like:
> Database User Name: <jetspeed-user>
> Database Password: <MyJetspeedPassword>
>
> The JDBC driver is also newly installed, in the location I indicated
> above.
>
> When the installer tests the database connection I get a "Connection to
> the
> database failed". What am I doing wrong?
>
> Abel
> --
> View this message in context:
> http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html
> Sent from the Jetspeed - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
--
View this message in context:
http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506394.html
Sent from the Jetspeed - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: Jetspeed and MySQL?
Posted by Abel MacAdam <ab...@gmail.com>.
Hi Ghufran,
Thanks for your reply. I tried what you suggested, but no luck. I still get
the "Connection to the
database failed" when the installer is testing the connection.
Abel
ghufran-2 wrote:
>
> Try to give permission to the user
> Run this sql
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
>
> If you are accessing it from different computer then type your ip instead
> of
> localhost in the above sql
>
>
> Hope it helps
>
> Regards
> Ghufran
>
> -----Original Message-----
> From: Abel MacAdam [mailto:abel.macadam@gmail.com]
> Sent: Thursday, July 17, 2008 3:58 PM
> To: jetspeed-user@portals.apache.org
> Subject: Jetspeed and MySQL?
>
>
> Hi,
>
> At the moment I'm bootstrapping Jetspeed-2. After finding out I had a
> corrupt installer, and finding a new one, I could start the installer. At
> one moment the installer asked my to what database it should connect. I
> choose MySQL (which I re-installed for Jetspeed). This is what I filled
> in:
> Database User Name: root
> Database Password: <MyRootPassword>
> JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed
> JDBC Driver Classname: com.mysql.jdbc.Driver
> JDBC driver:
> D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar
>
> As database user name I choose the same username and password as for my
> MySQL installation. Is that the wise choice, or should I choose something
> like:
> Database User Name: <jetspeed-user>
> Database Password: <MyJetspeedPassword>
>
> The JDBC driver is also newly installed, in the location I indicated
> above.
>
> When the installer tests the database connection I get a "Connection to
> the
> database failed". What am I doing wrong?
>
> Abel
> --
> View this message in context:
> http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html
> Sent from the Jetspeed - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506394.html
Sent from the Jetspeed - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: Jetspeed and MySQL?
Posted by Ghufran <gh...@vopium.com>.
Try to give permission to the user
Run this sql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
If you are accessing it from different computer then type your ip instead of
localhost in the above sql
Hope it helps
Regards
Ghufran
-----Original Message-----
From: Abel MacAdam [mailto:abel.macadam@gmail.com]
Sent: Thursday, July 17, 2008 3:58 PM
To: jetspeed-user@portals.apache.org
Subject: Jetspeed and MySQL?
Hi,
At the moment I'm bootstrapping Jetspeed-2. After finding out I had a
corrupt installer, and finding a new one, I could start the installer. At
one moment the installer asked my to what database it should connect. I
choose MySQL (which I re-installed for Jetspeed). This is what I filled in:
Database User Name: root
Database Password: <MyRootPassword>
JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed
JDBC Driver Classname: com.mysql.jdbc.Driver
JDBC driver:
D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar
As database user name I choose the same username and password as for my
MySQL installation. Is that the wise choice, or should I choose something
like:
Database User Name: <jetspeed-user>
Database Password: <MyJetspeedPassword>
The JDBC driver is also newly installed, in the location I indicated above.
When the installer tests the database connection I get a "Connection to the
database failed". What am I doing wrong?
Abel
--
View this message in context:
http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html
Sent from the Jetspeed - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org