in /usr/local/pgsql/data/pg_hba.conf this kind of information is given # To allow TCP/IP access, even from localhost, the postmaster must also be # started with the -i option or the option TCPIP_SOCKET must be set in # /etc/postgresql/postgresql.conf.
In the end of my /usr/local/pgsql/data/postgresql.conf
# TCP/IP access is allowed by default, but the default access given in # pg_hba.conf will permit it only from localhost, not other machines. tcpip_socket = 1
I have postgres and tomcat in the same computer.
--Pertti
Altus Snyman wrote:
Does it any difference that I'm using a already running tomcat? Here is the output Thanks again for your help
DBCP borrowObject failed: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.taglib.bean.LocalStrings', returnNull=true Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true Apr 22, 2004 11:28:58 AM org.apache.struts.util.PropertyMessageResources <init> INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true DBCP borrowObject failed: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Stopping service Tomcat-Standalone
On Thu, 2004-04-22 at 14:30, Pertti Pikkarainen wrote:
After restarting postgres you need to stop and start $CATALINA_HOME/bin/shutdown.sh $CATALINA_HOME/bin/startup.sh
Or something is wrong with the postgre access rights. Did you remember modify /usr/local/pgsql/data/pg_hba.conf
If a new start doesn't help please, send me $CATALINA_HOME/logs/catalina.out
Best regards Pertti
Altus Snyman wrote:
-It comes up with the index page but when you login with admin,admin it says error logging on to database,postgresql is running as postgres user and the db has been added with the txt file,I did the change in tomcat folder.
Must postgresql run as postgres user? Any Ideas
Thanks Altus
On Thu, 2004-04-22 at 09:31, Altus Snyman wrote:
Is this error ok? When I insert txt file into the db,Im loged in as postgres
CREATE TABLE INSERT 16984 1 CREATE TABLE CREATE TABLE INSERT 17003 1 CREATE TABLE CREATE TABLE CREATE TABLE INSERT 17020 1 INSERT 17021 1 NOTICE: CREATE TABLE will create implicit sequence 'cdr_acctid_seq' for SERIAL column 'cdr.acctid' CREATE TABLE CREATE TABLE NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index 'cdr_pkey' for table 'cdr' ALTER TABLE setval -------- 454 (1 row)
ERROR: Relation "asterikssettings" does not exist GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT
On Thu, 2004-04-22 at 09:16, Pertti Pikkarainen wrote:
I'm so sorry. The file is now there. Please download it. Thanks !
Best regards Pertti
Altus Snyman wrote:
Good day all I'm trying this switchboard demo (ftp://ftp.lanwan.fi/switchboard) But in the pdf howto they speak about a swb.txt and I dont have that file
Thanks Altus
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
