Re: Re: [Newbies] basicPortal V0.9 installation

I am still having problems loading
http://localhost/test.

I believe I have verified that the database connection
is being made by enabling debug logging in postgres. 
Here is that output ...

2003-04-24 00:00:54 [1688]   DEBUG:  connection:
host=127.0.0.1 user=bpuser database=basicportal
/bin/postmaster child[1688]: starting with (postgres
-d16 -v131072 -p basicportal )
2003-04-24 00:00:54 [1688]   DEBUG:  InitPostgres
2003-04-24 00:00:54 [1688]   DEBUG: 
StartTransactionCommand
2003-04-24 00:00:54 [1688]   DEBUG:  query: set
datestyle to 'ISO'; select version(), case when
pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN'
else getdatabaseencoding() end;

... a little later in that same log, you can see the
query being made:

2003-04-24 00:00:54 [1688]   DEBUG:  query: SELECT id,
content_id, parent_id, 
	usr_id, usr_handle_d, title, 
	cmnt, date_created 				
						FROM cmnts where CONTENT_ID = 8


... my error in the browser still reads:

[00:30] DEBUG ContentAct () - X the content to be
displayed -parm is HOSTING
java.lang.NullPointerException
        at
org.apache.scaffoldingXPress.base.BaseBean.getValue(BaseBean.java:103
)
        at
org.apache.basicPortal.coreBeans.CmntsBean.getTitle(CmntsBean.java:88
)
        at
org.apache.basicPortal.coreBeans.CmntsBean.testIt(CmntsBean.java:28)
        at
org.apache.basicPortal.coreBeans.TestServlet.doPost(TestServlet.java:
61)
        at
org.apache.basicPortal.coreBeans.TestServlet.doGet(TestServlet.java:8
3)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
        at
com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet
.java:96)
        at
com.caucho.server.http.Invocation.service(Invocation.java:315)
        at
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:1
35)
        at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246
)
        at
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:
164)
        at
com.caucho.server.TcpConnection.run(TcpConnection.java:139)
        at java.lang.Thread.run(Thread.java:536)


... what really has me baffled is the following lines
from my resin log:
CLOBERLE:/d/jasic/bp/WEB-INF/classes/org !#cd
apache/basicPortal/coreBeans/
        at
org.apache.basicPortal.coreBeans.ContentDAO.populate(ContentDAO.java:21)
        at
org.apache.basicPortal.coreBeans.ContentBean.populatePage(ContentBean.java:20)
        at
org.apache.basicPortal.cms.ContentAct.onDisplayExec(ContentAct.java:27)
        at
org.apache.scaffoldingXPress.base.BaseAct.onDefaultExec(BaseAct.java:87)
        ... 19 more
Caused by: Connection refused. Check that the hostname
and port are correct and that the p
ostmaster is accepting TCP/IP connections.
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connec
tion.java:167)
        at
org.postgresql.Driver.connect(Driver.java:122)
        at
com.caucho.sql.XADataSourceAdapter.getXAConnection(XADataSourceAdapter.java:119
)
        at
com.caucho.sql.XADataSourceAdapter.getPooledConnection(XADataSourceAdapter.java
:141)
        at
com.caucho.sql.DBPool.createConnection(DBPool.java:1404)
        at
com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1334)
        at
com.caucho.sql.DBPool.getConnection(DBPool.java:1198)
        at
com.caucho.sql.DBPool.getConnection(DBPool.java:1175)
        at
com.ibatis.db.sqlmap.SqlMap.startTransaction(Unknown
Source)
        at
org.apache.scaffoldingXPress.base.DAOIBaseHelper.doRetrieve(DAOIBaseHelper.java
:84)
        ... 23 more
[2003/04/22 18:31:13]
_web_22dinf._portlets._common._footer_0right__jsp:
destroy
[2003/04/22 18:31:13]
_web_22dinf._portlets._common._footer__jsp: destroy
[2003/04/22 18:31:13]
_web_22dinf._portlets._common._footer_0left__jsp:
destroy
[2003/04/22 18:31:13]
_web_22dinf._portlets._common._foota__jsp: destroy
[2003/04/22 18:31:13] com.caucho.jsp.JspServlet:
destroy
[2003/04/22 18:31:13]
com.caucho.server.http.DirectoryServlet: destroy
[2003/04/22 18:31:13]
com.caucho.server.http.FileServlet: destroy
[2003/04/22 18:31:13]
org.apache.basicPortal.coreBeans.TestServlet: destroy


According to this account of the error, it's still an
issue "Caused by: Connection refused. Check that the
hostname and port are correct and that the p
ostmaster is accepting TCP/IP connections."

I am really stumped here.  The postgres log shows the
connection and the query, but the resin log shows that
the connection refused.  Any help at all would be
greatly appreciated.

Thanks,

Chris




--- Aymeric Alibert <[email protected]>
wrote:
> Yes,
> There is another small issue with the sql mapping.
> In the
> org\apache\basicPortal\coreBeans\ContentSQL.xml
> file, some
> queries are accessing the topic_code column, but the
> database defines a
> subtopic_code column instead.
> Just changed the name in ContentSQL.xml and it works
> fine now.
>  
> Aymeric.
> 
> 
> >>> [email protected] 04/22/03 05:41PM >>>
> Hi Albert,
> 
> I had the exact same experience using Vic's
> instructions.  I modified the db connection part of
> resin.conf to be the following, but I'm still
> getting
> the error below.  Did you get this issue resolved? 
> If
> so, would you mind sharing how you did it?
> 
> <resource-ref>
>   <res-ref-name>bppool</res-ref-name>
>   <res-type>javax.sql.DataSource</res-type>
>   <init-param driver-name="org.postgresql.Driver"/>
>   <init-param
>
url="jdbc:postgresql://127.0.0.1/basicportal?autoReconnect=true"/>
>   <init-param user="bpuser"/>
>   <init-param password="bpus3r"/>
>   <init-param max-connections="3"/>
>   <init-param max-idle-time="30"/>
> </resource-ref>
> 
> Error...
> java.lang.NullPointerException at
>
org.apache.scaffoldingXPress.base.BaseBean.getValue(BaseBean.java:103)
> at
>
org.apache.basicPortal.coreBeans.CmntsBean.getTitle(CmntsBean.java:88)
> at
>
org.apache.basicPortal.coreBeans.CmntsBean.testIt(CmntsBean.java:28)
> at
>
org.apache.basicPortal.coreBeans.TestServlet.doPost(TestServlet.java:61)
> at
>
org.apache.basicPortal.coreBeans.TestServlet.doGet(TestServlet.java:83)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at
>
com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
> at
>
com.caucho.server.http.Invocation.service(Invocation.java:315)
> at
>
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
> at
>
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
> at
>
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
> at
>
com.caucho.server.TcpConnection.run(TcpConnection.java:139)
> at java.lang.Thread.run(Thread.java:536)
> java.lang.NullPointerException 
> 
> Thanks!
> 
> 
> --- Aymeric Alibert
> <[email protected]>
> wrote:
> > Vic,
> >  
> > I just downloaded the basicportal application. It
> > looks like a great
> > starting point for web portal.
> >  
> > I really liked the quick installation guide. Very
> > simple and
> > straightforward.
> > Just one comment on the 'starting the application
> > server' section,
> > there should be a paragraph on the settings of the
> > database pooling
> > configuration in the resin.conf file. It needs to
> be
> > changed to point to
> > your local postgresql database
> >   <init-param
> driver-name="org.postgresql.Driver"/>
> >   <init-param
> >
>
url="jdbc:postgresql://192.168.0.150:5432/basicportal?autoReconnect=true"/>
> >   <init-param user="bpuser"/>
> >   <init-param password="changeme"/>
> >   <init-param max-connections="3"/>
> >   <init-param max-idle-time="30"/>
> > 
> > Also, when I try to access the
> http://localhost/test 
> > page I got the
> > following error. Any Idea?
> >  
> > java.lang.NullPointerException at
> >
>
org.apache.scaffoldingXPress.base.BaseBean.getValue(BaseBean.java:103)
> > 
> > at
> >
>
org.apache.basicPortal.coreBeans.CmntsBean.getTitle(CmntsBean.java:88)
> > at
> >
>
org.apache.basicPortal.coreBeans.CmntsBean.testIt(CmntsBean.java:28)
> > 
> > at
> >
>
org.apache.basicPortal.coreBeans.TestServlet.doPost(TestServlet.java:61)
> > 
> > at
> >
>
org.apache.basicPortal.coreBeans.TestServlet.doGet(TestServlet.java:83)
> > 
> > at
> >
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> > at
> >
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> > 
> > at
> >
>
com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
> > 
> > at
> >
>
com.caucho.server.http.Invocation.service(Invocation.java:315)
> > 
> > at
> >
>
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
> > 
> > at
> >
>
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
> > 
> > at
> >
>
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
> > 
> > at
> >
>
com.caucho.server.TcpConnection.run(TcpConnection.java:139)
> > 
> > at java.lang.Thread.run(Thread.java:534)
> > java.lang.NullPointerException
> > 
> >  
> > Thanks,
> >  
> > Aymeric.
> >  
> > 
> > >>> [email protected] 04/21/03 07:58PM >>>
> > Are you looking for a fast Blogger written in
> > Struts?
> > 
> > In prior version, "bp" had a KISS Content
> Management
> > System, retrieved
> > 
> > like this:
> > <Item  name="about_contacts"
> title="About/Contacts"
> > page="/do/cmsPg?content=ABOUT"/>
> > </Menu>
> > 
> > So how it does a do content=ABOUT? Easy to display
> > "about us" page.
> > So it was easy to add Blogg, it's just content..
> You
> > can see blog 
> > working (not much content) and comment on blogg on
> > baseBeans.com blog 
> > page. (J2EE will force you to join and login via
> > container
> > authentication).
> > It' just a bare bone Blogger for now.
> > 
> > This version also adds better install
> instructions,
> > even Anna Nichole 
> > Smith can install it I hope.It uses
> > ScaffoldingXPress v.1.1 
> > (supported/release Struts v1.1).
> > 
> > 
> > Vic Cekvenich
> > <a href ="baseBeans.com">Struts Training</a> and
> > project recovery in 
> 
=== message truncated ===


__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com