Apache Proxy Pass / Setting the Context Path


#41

Ah. I see. Yeah, I would want the headers forwarded to the store I suppose for traffic analysis. That makes sense.


#42

It’s not actually possible to make the store the root of the VirtualHost it seems. Else, I’m missing a detail trying to make that work. If you proxy “/” to “/store” than something like “/images” would become “/store/images”. Now I put those specifics first in the proxy order to avoid that, but still things are falling down. I guess I’m missing exceptions to that “which is root” rule.


#43

Essentially, this still looks messed up:

ProxyPass /images/ http://localhost:8180/images/
ProxyPass /base-theme/ http://localhost:8180/base-theme/
ProxyPass /foundation-shop-theme/ http://localhost:8180/foundation-shop-theme/
ProxyPass /ordermgr-js/ http://localhost:8180/ordermgr-js/

ProxyPassReverse /images/ http://localhost:8180/images/
ProxyPassReverse /base-theme/ http://localhost:8180/base-theme/
ProxyPassReverse /foundation-shop-theme/ http://localhost:8180/foundation-shop-theme/
ProxyPassReverse /ordermgr-js/ http://localhost:8180/ordermgr-js/
				
ProxyPass / http://localhost:8180/shop/
ProxyPassReverse / http://localhost:8180/shop/

#44

For instance, when you click “Log In” (which is displayed in a messed up manner), you get the error:

The requested URL /shop/shop/control/checkLogin/main was not found on this server.


#45

Hold up. I may have it. I added a proxypass for /shop, and I went back to that big pile I posted previously. Now it looks right! (working right? idk… hopefully!)

ProxyPass /images/ http://localhost:8180/images/
ProxyPass /resources/ http://localhost:8180/resources/
ProxyPass /ordermgr-js/ http://localhost:8180/ordermgr-js/
ProxyPass /base-theme/ http://localhost:8180/base-theme/
ProxyPass /bootstrap-theme/ http://localhost:8180/bootstrap-theme/
ProxyPass /foundation-shop-theme/ http://localhost:8180/foundation-shop-theme/
ProxyPass /foundation6-theme/ http://localhost:8180/foundation6-theme/
ProxyPass /ignite-admin-theme/ http://localhost:8180/ignite-admin-theme/
ProxyPass /ignite-shop-theme/ http://localhost:8180/ignite-shop-theme/
ProxyPass /metro-theme/ http://localhost:8180/metro-theme/
ProxyPassReverse /images/ http://localhost:8180/images/
ProxyPassReverse /resources/ http://localhost:8180/resources/
ProxyPassReverse /ordermgr-js/ http://localhost:8180/ordermgr-js/
ProxyPassReverse /base-theme/ http://localhost:8180/base-theme/
ProxyPassReverse /bootstrap-theme/ http://localhost:8180/bootstrap-theme/
ProxyPassReverse /foundation-shop-theme/ http://localhost:8180/foundation-shop-theme/
ProxyPassReverse /foundation6-theme/ http://localhost:8180/foundation6-theme/
ProxyPassReverse /ignite-admin-theme/ http://localhost:8180/ignite-admin-theme/
ProxyPassReverse /ignite-shop-theme/ http://localhost:8180/ignite-shop-theme/
ProxyPassReverse /metro-theme/ http://localhost:8180/metro-theme/

ProxyPass /shop/ http://localhost:8180/shop/
ProxyPassReverse /shop/ http://localhost:8180/shop/
				
ProxyPass / http://localhost:8180/shop/
ProxyPassReverse / http://localhost:8180/shop/

#46

@BuvinJ
Just an update: In the recent Git master branch we have made changes so it is possible to set a “webapp path prefix” in Scipio so that the generated links contain a path prefix, before the regular context path (that you must then make your load balancer rules match up with of course).

You can set a global prefix for all apps in framework/webapp/config/url.properties:

webapp.url.path.prefix=/something

It is then possible to make an exception for Shop by setting the “Webapp Path Prefix” field to a single slash / (or other path) on this screen:

https://localhost:8443/catalog/control/EditWebSite?webSiteId=ScipioWebStore

Please note this feature and several major link-building improvements are still under testing, so if you try this, please report any problems, thank you.


#47

Fantastic! Thanks, guys. I’ll give this a try in the near future for sure.


#48

Has anyone resolve this issue? because currently this is also my problem :frowning:


#49

Hey there marksman,

and welcome to the community.

Yes, this has been addressed and we wrote down a better configuration example afterwards: https://www.scipioerp.com/community/developer/installation-configuration/clustering/webserver-configuration/


#50

After many days of banging my head against the wall, I ended up using the subdomain design instead, per the original way they planned for this to work. It functioned more reliably (and faster) for me than anything else I attempted. Once I did that, I also created private SSL certs for the subdomain that are bi-bidirectionally validated. With that in place, the system is ultra secure. Instead of just a password, the user can’t access anything without the private certs. As such, I decided that was ultimately better anyway, despite being more work to setup and maintain.

Now, that private cert idea doesn’t work for the shop, of course, which must be open to the public, so on that subdomain I used an alternate cert. I went with a free one, so as to not to not run up an extra bill. Had I planned this ahead of time, I would have used a free one on my domain root, and a fancy paid one for the shop. Or, if I weren’t so cheap, I’d have just bought a wildcard cert (which works across subdomains). That’ s the easiest solution if you want to go with the subdomain plan while avoiding the hassle of having numerous certs and configurations for them.


#51

I followed this same instructions with nginx but still having some issues. here is an extract of my url.properties file

# HTTPS Port (Secure port)
port.https.enabled=Y
port.https=8443
force.https.host=https://ecs.com/

# HTTP Port (Not Secure port)
port.http=8080
force.http.host=http://ecs.com/

Also here is and extract of conf file

#user  nobody;
worker_processes  1;

#error_log  logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;

#pid        logs/nginx.pid;


events {
    worker_connections  1024;
}


http {
    include       mime.types;
    default_type  application/octet-stream;

    #log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
    #                  '$status $body_bytes_sent "$http_referer" '
    #                  '"$http_user_agent" "$http_x_forwarded_for"';

    #access_log  logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  65;

    #gzip  on;

    server {
        listen       80;
        listen       8443;
        server_name  localhost;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;

        #location / {
        #    root   html;
        #    index  index.html index.htm;
        #}

		location / {
        proxy_next_upstream error timeout invalid_header http_500 http_502 http_503 http_504;

        proxy_set_header Host $host;
        proxy_set_header X-Forwarded-Host $host;
        proxy_set_header X-Forwarded-Server $host;
        proxy_set_header        X-Real-IP $remote_addr;
        proxy_set_header        X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header        X-Forwarded-Proto https;
        proxy_cookie_path ~*^/.* /;
        add_header Front-End-Https   on;

        proxy_pass  http://localhost:8080/shop/;
     }

    location /solr/ {
           auth_basic "Restricted";
           auth_basic_user_file /var/www/.../private/.htpasswd;
            proxy_set_header Host $host;
            proxy_pass  http://localhost:8080/solr/;
            proxy_set_header X-Real-IP $remote_addr;
            proxy_set_header X-Forwarded-for $remote_addr;
            port_in_redirect off;
            proxy_connect_timeout 300;
            proxy_pass_header Set-Cookie;
    }

    location /base-theme/ {
                    proxy_set_header Host $host;
                    proxy_pass  http://localhost:8080/base-theme/;
                    proxy_set_header X-Real-IP $remote_addr;
                    proxy_set_header X-Forwarded-for $remote_addr;
                    port_in_redirect off;
                    proxy_connect_timeout 300;
                    proxy_pass_header Set-Cookie;
    }

    location /images/ {
                    proxy_set_header Host $host;
                    proxy_pass  http://localhost:8080/images/;
                    proxy_set_header X-Real-IP $remote_addr;
                    proxy_set_header X-Forwarded-for $remote_addr;
                    port_in_redirect off;
                    proxy_connect_timeout 300;
                    proxy_pass_header Set-Cookie;
    }

    location /foundation-shop-theme/ {
                    proxy_set_header Host $host;
                    proxy_pass  http://localhost:8080/foundation-shop-theme/;
                    proxy_set_header X-Real-IP $remote_addr;
                    proxy_set_header X-Forwarded-for $remote_addr;
                    port_in_redirect off;
                    proxy_connect_timeout 300;
                    proxy_pass_header Set-Cookie;
    }

    location /ordermgr-js/ {
                    proxy_set_header Host $host;
                    proxy_pass  http://localhost:8080/ordermgr-js/;
                    proxy_set_header X-Real-IP $remote_addr;
                    proxy_set_header X-Forwarded-for $remote_addr;
                    port_in_redirect off;
                    proxy_connect_timeout 300;
                    proxy_pass_header Set-Cookie;
    }
}

I have also restarted the nginx server and scipio server. But when I type httsp://ecs.com/ it opens site cannot be reached


#52

I am assuming that you configured your registar DNS to point to your local instance/server. You may also need to configure NAT, depending on your network settings. Is that correct?


#53

Yes I did in my host file:

127.0.0.1       localhost
127.0.0.1   https://ecs.com
127.0.0.1   https://www.ecs.com 
127.0.0.1   http://ecs.com

#54

Yea, that should work. Your settings look alright, anyway.

Can you remove the comments for the access_log entries and post here what you get there?


#55

Also the first error_log. I think that may shed some light.


#56

Access log
192.168.43.181 - - [07/Feb/2019:12:20:12 +0100] “GET / HTTP/1.1” 404 - “-” “avast! Antivirus”
192.168.43.181 - - [07/Feb/2019:12:20:12 +0100] “GET / HTTP/1.1” 404 - “-” “avast! Antivirus”
192.168.43.181 - - [07/Feb/2019:12:20:14 +0100] “GET /HNAP1/ HTTP/1.1” 404 - “-” “avast! Antivirus”
127.0.0.1 - - [07/Feb/2019:12:20:47 +0100] “POST /solr/product/select HTTP/1.1” 200 5538 “-” “Solr[org.apache.solr.client.solrj.impl.HttpSolrClient] 1.0”
127.0.0.1 - - [07/Feb/2019:12:20:53 +0100] “POST /solr/product/select HTTP/1.1” 200 4894 “-” “Solr[org.apache.solr.client.solrj.impl.HttpSolrClient] 1.0”
127.0.0.1 - - [07/Feb/2019:12:20:55 +0100] “GET /shop/ HTTP/1.0” 200 350 “-” “avast! Antivirus”

Error log

2019-02-07 11:56:39,941 |Scipio-JobQueue-1    |GenericDelegator              |E| Failure in create operation for entity [ServiceSemaphore]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServiceSemaphore][serviceName,rebuildSolrIndex(java.lang.String)][lockedByInstanceId,scipio1(java.lang.String)][lockThread,Scipio-JobQueue-1(java.lang.String)][lockTime,2019-02-07 11:56:38.392(java.sql.Timestamp)][lastUpdatedStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][lastUpdatedTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVICE_SEMAPHORE (SERVICE_NAME, LOCKED_BY_INSTANCE_ID, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL190130221312010' defined on 'SERVICE_SEMAPHORE'.)). Rolling back transaction.

2019-02-07 11:56:39,941 |Scipio-JobQueue-1 |ServiceSemaphore |E| null
org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServiceSemaphore][serviceName,rebuildSolrIndex(java.lang.String)][lockedByInstanceId,scipio1(java.lang.String)][lockThread,Scipio-JobQueue-1(java.lang.String)][lockTime,2019-02-07 11:56:38.392(java.sql.Timestamp)][lastUpdatedStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][lastUpdatedTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVICE_SEMAPHORE (SERVICE_NAME, LOCKED_BY_INSTANCE_ID, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL190130221312010’ defined on ‘SERVICE_SEMAPHORE’.)) (Error while inserting: [GenericEntity:ServiceSemaphore][serviceName,rebuildSolrIndex(java.lang.String)][lockedByInstanceId,scipio1(java.lang.String)][lockThread,Scipio-JobQueue-1(java.lang.String)][lockTime,2019-02-07 11:56:38.392(java.sql.Timestamp)][lastUpdatedStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][lastUpdatedTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVICE_SEMAPHORE (SERVICE_NAME, LOCKED_BY_INSTANCE_ID, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL190130221312010’ defined on ‘SERVICE_SEMAPHORE’.)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:904) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericValue.create(GenericValue.java:88) ~[ofbiz-entity.jar:?]
at org.ofbiz.service.semaphore.ServiceSemaphore.dbWrite(ServiceSemaphore.java:172) [ofbiz-service.jar:?]
at org.ofbiz.service.semaphore.ServiceSemaphore.checkLockNeedToWait(ServiceSemaphore.java:137) [ofbiz-service.jar:?]
at org.ofbiz.service.semaphore.ServiceSemaphore.acquire(ServiceSemaphore.java:70) [ofbiz-service.jar:?]
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:292) [ofbiz-service.jar:?]
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:248) [ofbiz-service.jar:?]
at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:90) [ofbiz-service.jar:?]
at com.ilscipio.scipio.solr.SolrProductSearch.rebuildSolrIndexAuto(SolrProductSearch.java:1561) [ofbiz-solr.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?]
at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?]
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423) [ofbiz-service.jar:?]
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:248) [ofbiz-service.jar:?]
at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:90) [ofbiz-service.jar:?]
at org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70) [ofbiz-service.jar:?]
at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) [ofbiz-service.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202-ea]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202-ea]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServiceSemaphore][serviceName,rebuildSolrIndex(java.lang.String)][lockedByInstanceId,scipio1(java.lang.String)][lockThread,Scipio-JobQueue-1(java.lang.String)][lockTime,2019-02-07 11:56:38.392(java.sql.Timestamp)][lastUpdatedStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][lastUpdatedTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)][createdTxStamp,2019-02-07 11:56:38.806(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SERVICE_SEMAPHORE (SERVICE_NAME, LOCKED_BY_INSTANCE_ID, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL190130221312010’ defined on ‘SERVICE_SEMAPHORE’.))
at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz-entity.jar:?]
… 22 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.SERVICE_SEMAPHORE (SERVICE_NAME, LOCKED_BY_INSTANCE_ID, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL190130221312010’ defined on ‘SERVICE_SEMAPHORE’.)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz-entity.jar:?]
… 22 more
Caused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL190130221312010’ defined on ‘SERVICE_SEMAPHORE’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz-entity.jar:?]
… 22 more
Caused by: org.apache.derby.iapi.error.StandardException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL190130221312010’ defined on ‘SERVICE_SEMAPHORE’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:881) ~[ofbiz-entity.jar:?]
… 22 more


#57

Is it possible that Avast is blocking the connection for some reason? can you try disabling it for and while a see what happens? as for the error, forget about it, it’s unrelated most likely.


#58

I have uninstalled avast completely, restarted system, nginx and scipio server but issue still seems to be there, am not sure what am doing wrong.
This is the address am typing https://ecs.com but still same http://ecs.com/

Also
I am suspecting that the issue is coming at the level of ports or http/https, when I enter my local address ip, it opens up the front end http store as defined in nginx. but when I try defining the backend, it doesnt work, for backend access, am defining something like this which seem not to be working

	location / {
    proxy_pass  http://localhost:8443/admin/;
    }

#59

oh, wait. I think you got your hosts file wrong. You don’t need to specify the protocol in your hosts file. Try to change it to:

127.0.0.1   ecs.com
127.0.0.1   www.ecs.com 
127.0.0.1   ecs.com

#60

I corrected as you said, thanks its resolving now but when I redirecitt in the webserver

location / {
proxy_pass  http://localhost:8443/admin/;
}

it works but with no css or js and login stops working.