can't add website

[BJ Freeman]

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.

[BJ Freeman]

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.
>
>
>
>

[BJ Freeman]

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.
>>
>>
>>
>>
>
>
>
>

[BJ Freeman]

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.
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>
>