You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by BJ Freeman <bj...@free-man.net> on 2008/07/23 21:17:15 UTC

can't add website

https://localhost:8443/content/control/FindWebSite
click on Create New WebSite
it shows Edit Website
put bjfreemanteststore for Web Site Id
select bjfreemanteststore (already created)for Product Store Id

click on submit

next to Web Site Id I get    CommonCannotBeFound: [bjfreemanteststore]
there is no errors in the log.

Re: can't add website--ofbiz can not be used in OOTB with out a valid CA cert?

Posted by BJ Freeman <bj...@free-man.net>.

well I thought is was the expired jks file in ofbiz
but now i get following error:
Notes I saw some notes about ssl not accepting selfsigned certs
so ofbiz can not be used in OOTB with out a valid CA cert?

2008-07-30 22:51:52,703 (http-0.0.0.0-8443-1) [
RequestHandler.java:584:INFO ] servletName=control, view=EditWebSite
sessionId=0CF2C831EB0532ECBB21A55D24BAF535.jvm1
2008-07-30 22:51:52,703 (http-0.0.0.0-8443-1) [
JSSESupport.java:89 :DEBUG] Error getting client certs
javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated
	at
com.sun.net.ssl.internal.ssl.SSLSessionImpl.getPeerCertificates(SSLSessionImpl.java:345)
	at
org.apache.tomcat.util.net.jsse.JSSESupport.getX509Certificates(JSSESupport.java:87)
	at
org.apache.tomcat.util.net.jsse.JSSESupport.getPeerCertificateChain(JSSESupport.java:141)
	at
org.apache.coyote.http11.Http11Processor.action(Http11Processor.java:1011)
	at org.apache.coyote.Request.action(Request.java:352)
	at org.apache.catalina.connector.Request.getAttribute(Request.java:896)
	at
org.apache.catalina.connector.Request.getAttributeNames(Request.java:936)
	at
org.apache.catalina.connector.RequestFacade.getAttributeNames(RequestFacade.java:278)
	at org.ofbiz.base.util.UtilHttp.getAttributeMap(UtilHttp.java:198)
	at org.ofbiz.base.util.UtilHttp.getAttributeMap(UtilHttp.java:187)
	at org.ofbiz.base.util.UtilHttp.getCombinedMap(UtilHttp.java:90)
	at
org.ofbiz.widget.screen.ScreenRenderer.populateContextForRequest(ScreenRenderer.java:183)
	at
org.ofbiz.widget.screen.ScreenRenderer.populateContextForRequest(ScreenRenderer.java:175)
	at
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:92)
	at
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:651)
	at
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:435)
	at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:198)
	at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:78)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)
200

BJ Freeman sent the following on 7/23/2008 2:34 PM:
> Duh there is now an error log
> 
> ---- exception report
> ----------------------------------------------------------
> Failure in create operation for entity [WebSite]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:WebSite][allowProductStoreChange,null()][cookieDomain,bjfreemanteststore(java.lang.String)][createdStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][createdTxStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][enableHttps,null()][httpHost,null()][httpPort,null()][httpsHost,null()][httpsPort,null()][lastUpdatedStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-23
> 14:04:10.593(java.sql.Timestamp)][productStoreId,bjfreemanteststore(java.lang.String)][secureContentPrefix,null()][siteName,bjfreemanteststore(java.lang.String)][standardContentPrefix,null()][webSiteId,bjfreemanteststore(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO OFBIZ.WEB_SITE
> (WEB_SITE_ID, SITE_NAME, ALLOW_PRODUCT_STORE_CHANGE, HTTP_HOST,
> HTTP_PORT, HTTPS_HOST, HTTPS_PORT, ENABLE_HTTPS,
> STANDARD_CONTENT_PREFIX, SECURE_CONTENT_PREFIX, COOKIE_DOMAIN,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP, PRODUCT_STORE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WEB_SITE' caused a violation of
> foreign key constraint 'WEB_SITE_PRDS' for key (bjfreemanteststore).
> The statement has been rolled back.)). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> BJ Freeman sent the following on 7/23/2008 2:14 PM:
>> Ok here it is.
>> https://localhost:8443/content/control/EditWebSite
>> uses the Storename in the Product Store ID box and passes that instead
>> of the productstoreID so it has a PFK error.
>> which btw does not show up in the log.
>>
>>
>>
>> BJ Freeman sent the following on 7/23/2008 12:17 PM:
>>> https://localhost:8443/content/control/FindWebSite
>>> click on Create New WebSite
>>> it shows Edit Website
>>> put bjfreemanteststore for Web Site Id
>>> select bjfreemanteststore (already created)for Product Store Id
>>>
>>> click on submit
>>>
>>> next to Web Site Id I get    CommonCannotBeFound: [bjfreemanteststore]
>>> there is no errors in the log.
>>>
>>>
>>>
>>>
>>
>>
>>
> 
> 
> 
>

Re: can't add website--found fix

Posted by BJ Freeman <bj...@free-man.net>.

Duh there is now an error log

---- exception report
----------------------------------------------------------
Failure in create operation for entity [WebSite]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:WebSite][allowProductStoreChange,null()][cookieDomain,bjfreemanteststore(java.lang.String)][createdStamp,2008-07-23
14:04:10.593(java.sql.Timestamp)][createdTxStamp,2008-07-23
14:04:10.593(java.sql.Timestamp)][enableHttps,null()][httpHost,null()][httpPort,null()][httpsHost,null()][httpsPort,null()][lastUpdatedStamp,2008-07-23
14:04:10.593(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-23
14:04:10.593(java.sql.Timestamp)][productStoreId,bjfreemanteststore(java.lang.String)][secureContentPrefix,null()][siteName,bjfreemanteststore(java.lang.String)][standardContentPrefix,null()][webSiteId,bjfreemanteststore(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.WEB_SITE
(WEB_SITE_ID, SITE_NAME, ALLOW_PRODUCT_STORE_CHANGE, HTTP_HOST,
HTTP_PORT, HTTPS_HOST, HTTPS_PORT, ENABLE_HTTPS,
STANDARD_CONTENT_PREFIX, SECURE_CONTENT_PREFIX, COOKIE_DOMAIN,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP, PRODUCT_STORE_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WEB_SITE' caused a violation of
foreign key constraint 'WEB_SITE_PRDS' for key (bjfreemanteststore).
The statement has been rolled back.)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting:
BJ Freeman sent the following on 7/23/2008 2:14 PM:
> Ok here it is.
> https://localhost:8443/content/control/EditWebSite
> uses the Storename in the Product Store ID box and passes that instead
> of the productstoreID so it has a PFK error.
> which btw does not show up in the log.
> 
> 
> 
> BJ Freeman sent the following on 7/23/2008 12:17 PM:
>> https://localhost:8443/content/control/FindWebSite
>> click on Create New WebSite
>> it shows Edit Website
>> put bjfreemanteststore for Web Site Id
>> select bjfreemanteststore (already created)for Product Store Id
>>
>> click on submit
>>
>> next to Web Site Id I get    CommonCannotBeFound: [bjfreemanteststore]
>> there is no errors in the log.
>>
>>
>>
>>
> 
> 
> 
>

Re: can't add website

Posted by BJ Freeman <bj...@free-man.net>.

Ok here it is.
https://localhost:8443/content/control/EditWebSite
uses the Storename in the Product Store ID box and passes that instead
of the productstoreID so it has a PFK error.
which btw does not show up in the log.



BJ Freeman sent the following on 7/23/2008 12:17 PM:
> https://localhost:8443/content/control/FindWebSite
> click on Create New WebSite
> it shows Edit Website
> put bjfreemanteststore for Web Site Id
> select bjfreemanteststore (already created)for Product Store Id
> 
> click on submit
> 
> next to Web Site Id I get    CommonCannotBeFound: [bjfreemanteststore]
> there is no errors in the log.
> 
> 
> 
>