This week's book giveaways are in the Cloud and AI/ML forums.
We're giving away four copies each of Cloud Native Patterns and Natural Language Processing and have the authors on-line!
See this thread and this one for details.
Win a copy of Cloud Native PatternsE this week in the Cloud forum
or Natural Language Processing in the AI/ML forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

The web server and the database in different computer

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to know how use the IP address to access the databse(The web
server and the database in different computer)?
How to set the jforum-custom.conf content?
I try to set the IP Address replay the localhost ,but it can't acess the databse,ask for help�??
[originally posted on jforum.net by fangbiao]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
fangbiao,

When you install jforum it should guide you through the database setup, including prompting you for the database type (hsqldb, mysql, etc.) and the necessary configuration parameters (hostname, port, username, password, etc.) to make the connection.

The jforum-custom.conf in the jforum/WEB-INF/config directory should have the following settings defined:

database.connection.host=my.jforumhost.com
database.connection.port=3306
database.connection.dbname=jforum
database.connection.username=jforum
database.connection.password=jforum

You should be able to set the host to whichever IP/hostname your database is running on. The port number will vary depending on the database you are using; 3306 is the standard MySQL port.

Hope this helps.
[originally posted on jforum.net by Dave Gebhart]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I try to do it like this,but it can't sucess!
I set the jforum-custom.conf some parameters :

database.connection.host=172.16.20.222

(this ip Address which is my databse running on)

I use the IP Address replay the hostName
and my webApp and the mysql in different pc,now i try it only in the same pc with the webAPP and database ,but it also can't access the database ,if i use

databse.connection.host=localhost

it can running sucess!

tell me why,is my setting error or any other way to set it?
thanks!
[originally posted on jforum.net by fangbiao]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Every database engine has basic client to perform some queries. Try to install engine and client in one pc, test connection, then after install client in another one pc, test again connection. Later install JForum
[originally posted on jforum.net by redhand]
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!