Set up Glassfish connection pool to talk to a database on a Ubuntu VPS The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Come Celebrate our 10 Year Anniversary!What is the debian-sys-maint MySQL user (and more)?Problem about IP and computer name in Ubuntu3 Root accounts in MySQl databaseCan not connect remotely to MySQL Server on Ubuntu 10.10How to regain access to myql server and dump database?Postfix and MySQL configurationJDBC Connection Pool details on GlassfishMySQL on Ubuntu. 10061 error on 3306MySQL cannot connect via SSH tunnel — Connection refusedunable to remotely connect to mysql on ubuntu server
Multi tool use
What do I do when my TA workload is more than expected?
Make it rain characters
Identify 80s or 90s comics with ripped creatures (not dwarves)
What to do when moving next to a bird sanctuary with a loosely-domesticated cat?
Accepted by European university, rejected by all American ones I applied to? Possible reasons?
Windows 10: How to Lock (not sleep) laptop on lid close?
What is the padding with red substance inside of steak packaging?
Circular reasoning in L'Hopital's rule
Variable with quotation marks "$()"
Button changing its text & action. Good or terrible?
Why can't wing-mounted spoilers be used to steepen approaches?
Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?
Working through the single responsibility principle (SRP) in Python when calls are expensive
How did passengers keep warm on sail ships?
What was the last x86 CPU that did not have the x87 floating-point unit built in?
Mortgage adviser recommends a longer term than necessary combined with overpayments
How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time
US Healthcare consultation for visitors
How do you keep chess fun when your opponent constantly beats you?
Can withdrawing asylum be illegal?
What information about me do stores get via my credit card?
Presidential Pardon
Why doesn't a hydraulic lever violate conservation of energy?
Do I have Disadvantage attacking with an off-hand weapon?
Set up Glassfish connection pool to talk to a database on a Ubuntu VPS
The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Come Celebrate our 10 Year Anniversary!What is the debian-sys-maint MySQL user (and more)?Problem about IP and computer name in Ubuntu3 Root accounts in MySQl databaseCan not connect remotely to MySQL Server on Ubuntu 10.10How to regain access to myql server and dump database?Postfix and MySQL configurationJDBC Connection Pool details on GlassfishMySQL on Ubuntu. 10061 error on 3306MySQL cannot connect via SSH tunnel — Connection refusedunable to remotely connect to mysql on ubuntu server
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
On my Ubuntu VPS, i have a mysql server running and a Glassfish 3.0.1 Application Server running. And I am having a hard to have my GF successfully ping the database. Here is my GF set up
Assume: x.y.z.t is the ip of my VPS
Resource Type: javax.sql.ConnectionPoolDataSource
User: root
DatabaseName: scholar
Url: jdbc:mysql://x.y.z.t:3306/scholar
URL: jdbc:mysql://x.y.z.t:3306/scholar
Password: xxxx
PortNumber: 3306
ServerName: x.y.z.t
Inside my glassfish3/glassfish/lib, I have my mysql-connector-java-5.1.13-bin.jar
Inside the database, table mysql here is the result of the query
select User, Host from user;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| root | yunaeyes |
+------------------+-----------+
Now from my machine, if I try to connect to this db via mysql browser (mysql client software), well I cant. Well from the table above, seem like it only allow localhost to connect to this db. Keep in mind that both my db and my GF are on the same VPS. Please help
ubuntu database glassfish application-server
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
add a comment |
On my Ubuntu VPS, i have a mysql server running and a Glassfish 3.0.1 Application Server running. And I am having a hard to have my GF successfully ping the database. Here is my GF set up
Assume: x.y.z.t is the ip of my VPS
Resource Type: javax.sql.ConnectionPoolDataSource
User: root
DatabaseName: scholar
Url: jdbc:mysql://x.y.z.t:3306/scholar
URL: jdbc:mysql://x.y.z.t:3306/scholar
Password: xxxx
PortNumber: 3306
ServerName: x.y.z.t
Inside my glassfish3/glassfish/lib, I have my mysql-connector-java-5.1.13-bin.jar
Inside the database, table mysql here is the result of the query
select User, Host from user;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| root | yunaeyes |
+------------------+-----------+
Now from my machine, if I try to connect to this db via mysql browser (mysql client software), well I cant. Well from the table above, seem like it only allow localhost to connect to this db. Keep in mind that both my db and my GF are on the same VPS. Please help
ubuntu database glassfish application-server
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
can you send the domain.xml ?
– silviud
Jan 2 '11 at 14:00
I kind of figure it out. Since both my database, and my GF are on the same VPS, I changeUrl: jdbc:mysql://x.y.z.t:3306/scholartoUrl: jdbc:mysql://localhost:3306/scholar, and it worked. Plus from what theusertable show above, it look like, the db only allow access from localhost anyway. Do you know how to make it so that I can access it remotely?
– Harry Pham
Jan 3 '11 at 4:15
1
Grant privileges to'user'@'*'or to the specific domains that they will be connecting from, i.e.'user'@'x.y.z.t'.
– Andrew M.
Jan 3 '11 at 5:59
add a comment |
On my Ubuntu VPS, i have a mysql server running and a Glassfish 3.0.1 Application Server running. And I am having a hard to have my GF successfully ping the database. Here is my GF set up
Assume: x.y.z.t is the ip of my VPS
Resource Type: javax.sql.ConnectionPoolDataSource
User: root
DatabaseName: scholar
Url: jdbc:mysql://x.y.z.t:3306/scholar
URL: jdbc:mysql://x.y.z.t:3306/scholar
Password: xxxx
PortNumber: 3306
ServerName: x.y.z.t
Inside my glassfish3/glassfish/lib, I have my mysql-connector-java-5.1.13-bin.jar
Inside the database, table mysql here is the result of the query
select User, Host from user;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| root | yunaeyes |
+------------------+-----------+
Now from my machine, if I try to connect to this db via mysql browser (mysql client software), well I cant. Well from the table above, seem like it only allow localhost to connect to this db. Keep in mind that both my db and my GF are on the same VPS. Please help
ubuntu database glassfish application-server
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
On my Ubuntu VPS, i have a mysql server running and a Glassfish 3.0.1 Application Server running. And I am having a hard to have my GF successfully ping the database. Here is my GF set up
Assume: x.y.z.t is the ip of my VPS
Resource Type: javax.sql.ConnectionPoolDataSource
User: root
DatabaseName: scholar
Url: jdbc:mysql://x.y.z.t:3306/scholar
URL: jdbc:mysql://x.y.z.t:3306/scholar
Password: xxxx
PortNumber: 3306
ServerName: x.y.z.t
Inside my glassfish3/glassfish/lib, I have my mysql-connector-java-5.1.13-bin.jar
Inside the database, table mysql here is the result of the query
select User, Host from user;
+------------------+-----------+
| User | Host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| root | yunaeyes |
+------------------+-----------+
Now from my machine, if I try to connect to this db via mysql browser (mysql client software), well I cant. Well from the table above, seem like it only allow localhost to connect to this db. Keep in mind that both my db and my GF are on the same VPS. Please help
ubuntu database glassfish application-server
ubuntu database glassfish application-server
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
asked Jan 2 '11 at 5:40
Harry PhamHarry Pham
88111
88111
can you send the domain.xml ?
– silviud
Jan 2 '11 at 14:00
I kind of figure it out. Since both my database, and my GF are on the same VPS, I changeUrl: jdbc:mysql://x.y.z.t:3306/scholartoUrl: jdbc:mysql://localhost:3306/scholar, and it worked. Plus from what theusertable show above, it look like, the db only allow access from localhost anyway. Do you know how to make it so that I can access it remotely?
– Harry Pham
Jan 3 '11 at 4:15
1
Grant privileges to'user'@'*'or to the specific domains that they will be connecting from, i.e.'user'@'x.y.z.t'.
– Andrew M.
Jan 3 '11 at 5:59
add a comment |
can you send the domain.xml ?
– silviud
Jan 2 '11 at 14:00
I kind of figure it out. Since both my database, and my GF are on the same VPS, I changeUrl: jdbc:mysql://x.y.z.t:3306/scholartoUrl: jdbc:mysql://localhost:3306/scholar, and it worked. Plus from what theusertable show above, it look like, the db only allow access from localhost anyway. Do you know how to make it so that I can access it remotely?
– Harry Pham
Jan 3 '11 at 4:15
1
Grant privileges to'user'@'*'or to the specific domains that they will be connecting from, i.e.'user'@'x.y.z.t'.
– Andrew M.
Jan 3 '11 at 5:59
can you send the domain.xml ?
– silviud
Jan 2 '11 at 14:00
can you send the domain.xml ?
– silviud
Jan 2 '11 at 14:00
I kind of figure it out. Since both my database, and my GF are on the same VPS, I change
Url: jdbc:mysql://x.y.z.t:3306/scholar to Url: jdbc:mysql://localhost:3306/scholar, and it worked. Plus from what the user table show above, it look like, the db only allow access from localhost anyway. Do you know how to make it so that I can access it remotely?– Harry Pham
Jan 3 '11 at 4:15
I kind of figure it out. Since both my database, and my GF are on the same VPS, I change
Url: jdbc:mysql://x.y.z.t:3306/scholar to Url: jdbc:mysql://localhost:3306/scholar, and it worked. Plus from what the user table show above, it look like, the db only allow access from localhost anyway. Do you know how to make it so that I can access it remotely?– Harry Pham
Jan 3 '11 at 4:15
1
1
Grant privileges to
'user'@'*' or to the specific domains that they will be connecting from, i.e. 'user'@'x.y.z.t'.– Andrew M.
Jan 3 '11 at 5:59
Grant privileges to
'user'@'*' or to the specific domains that they will be connecting from, i.e. 'user'@'x.y.z.t'.– Andrew M.
Jan 3 '11 at 5:59
add a comment |
1 Answer
1
active
oldest
votes
Your database is binding on 127.0.0.1. just change, in my.cnf, bind-interface to: x.y.z.t and it will work.
answered May 5 '11 at 7:25
SacxSacx
2,2811213
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f217897%2fset-up-glassfish-connection-pool-to-talk-to-a-database-on-a-ubuntu-vps%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your database is binding on 127.0.0.1. just change, in my.cnf, bind-interface to: x.y.z.t and it will work.
answered May 5 '11 at 7:25
SacxSacx
2,2811213
add a comment |
Your database is binding on 127.0.0.1. just change, in my.cnf, bind-interface to: x.y.z.t and it will work.
answered May 5 '11 at 7:25
SacxSacx
2,2811213
add a comment |
Your database is binding on 127.0.0.1. just change, in my.cnf, bind-interface to: x.y.z.t and it will work.
answered May 5 '11 at 7:25
SacxSacx
2,2811213
Your database is binding on 127.0.0.1. just change, in my.cnf, bind-interface to: x.y.z.t and it will work.
answered May 5 '11 at 7:25
SacxSacx
2,2811213
answered May 5 '11 at 7:25
SacxSacx
2,2811213
answered May 5 '11 at 7:25
SacxSacx
2,2811213
answered May 5 '11 at 7:25
SacxSacx
2,2811213
2,2811213
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f217897%2fset-up-glassfish-connection-pool-to-talk-to-a-database-on-a-ubuntu-vps%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
fVzVSiCSUiAtG107CN7mEx
can you send the domain.xml ?
– silviud
Jan 2 '11 at 14:00
I kind of figure it out. Since both my database, and my GF are on the same VPS, I change
Url: jdbc:mysql://x.y.z.t:3306/scholartoUrl: jdbc:mysql://localhost:3306/scholar, and it worked. Plus from what theusertable show above, it look like, the db only allow access from localhost anyway. Do you know how to make it so that I can access it remotely?– Harry Pham
Jan 3 '11 at 4:15
1
Grant privileges to
'user'@'*'or to the specific domains that they will be connecting from, i.e.'user'@'x.y.z.t'.– Andrew M.
Jan 3 '11 at 5:59