• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

The web server and the database in different computer

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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]
 
reply
    Bookmark Topic Watch Topic
  • New Topic