Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 09-10-2005, 05:24 AM   #1
Registered: Jun 2005
Location: Pune
Distribution: mandrake
Posts: 30

Rep: Reputation: 15
unable to establish connection

hello everyone,
i have developed an application using j2ee technologies and postgresql-7.2.1 is the database,
now when i run the jboss-3.2.6 application server owned bythe root and i run it in the root login
the database server is started by an user account who is the owner of the pgsql directory
Both the terminals i.e. of jboss and pgsql, displays a message that the server is started successfully,
but for viewing the application when i open the browser and type the url, i get to see the GUI nicely, but cannot use the system because the application is not connected to database
whereas if i access the same url (linux server ) from any other windows machine i see my application running properly.

can anyone tell me what might be the problem
waiting eagerly for your reply
thanks in advance
Old 09-14-2005, 10:19 PM   #2
Registered: Sep 2005
Distribution: Slackware 13.37
Posts: 112

Rep: Reputation: 15
PostgreSQL 7.2.1 is a rather old version but anyway:

When you initiateed postgreSQL for the 1st time you are supposed to do this as postgres user; this is for security reasons and most packaged flavours of linux have everything pre-setup.

Log as postgres User
[root@DataTaskmanager root]# su postgres

Initialize the Database System
-bash-2.05b$ initdb D /var/lib/pgsql/data

Activate Listening on the TCPIP port by editing
Locate your postgresql.conf
iE /var/lib/pgsql/data/postgresql.conf
changing the line:
#tcpip_socket=false to tcpip_socket=true

Alter the file /var/lib/pgsql/data/pg_hba.conf in order to accept requests from the machine(s) you would like to allow access to.

local all ident sameuser
host all password
host all password

add the postgreSQL daemon to your services and start it.

Then you have to get into the database (psql [databasename]) you would like to access and create a database user with the necesary privileges.
The database user you create here is the user (name and password) you will use to access the database with through ODBC.
Old 09-14-2005, 10:22 PM   #3
Registered: Sep 2005
Distribution: Slackware 13.37
Posts: 112

Rep: Reputation: 15
For PostgreSQL 8.x.x users!
In version 8 the configuration of your pg_hba.conf is slightly different.
There are examples within the file.

The changes to postgresql.conf are no longer required in version 8.x.x


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to establish internet connection using Linksys WRT54G Router on Mandrake 10 djynen Linux - Networking 3 11-25-2006 10:01 AM
Still can't establish a pppoe connection Andriy Slackware 17 12-06-2005 07:01 AM
Please help me establish an internect connection AlexBell Linux - Hardware 1 05-23-2005 12:11 PM
cannot establish dial up connection Mr_C Linux - Networking 5 06-03-2004 10:32 PM
Unable to establish a connection to my ISP? phobos Linux - Networking 2 10-22-2002 11:59 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:03 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration