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 23:34:59 UTC
Re: can't add website--found fix
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--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.
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>
>