konakart admin WAR issue on a different port than 8780

[michaelwechner]

Hi

The WAR file generation worked very fine and also it runs fine within my own Tomcat on port 8080, but
I receive the following exception when signing in as admin user

Exception Stack Trace =
at com.konakart.bl.KKRecord.isMySQL(Unknown Source)
at com.konakartadmin.bl.AdminProductMgr.searchForProductsPrivate(Unknown Source)
at com.konakartadmin.bl.AdminProductMgr.searchForProducts(Unknown Source)
at com.konakartadmin.bl.KKAdmin.searchForProducts(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.searchForProducts(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:166)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:637)

Also the admin webapp still tries to connect to 8780 when I click on "My Store Status".

Any idea what might be wrong?

(btw, I am using PostgreSQL 8.4 and the latest ZIP version of the community edition 4.2.0.1-C (built 3:47PM 18-Jan-2010 GMT)

Thanks

Michael

[greg]

I don't understand the problem.

Please can you state what you have done, one step at a time, to arrive at this position.

Start with how you installed it (did you use the GUI?) and which port you defined at that time.

What's different about your tomcat and the tomcat provided with KonaKart?

[michaelwechner]

1) I have downloaded the community edition ZIP file from http://www.konakart.com/downloads/community_edition

2) I have setup the konkart demo store within my PostgreSQL 8.4:
   # /Library/PostgreSQL/8.4/bin/createdb -U postgres --encoding unicode konakart
   # /Library/PostgreSQL/8.4/bin/psql -U postgres -d konakart -f database/PostgreSQL/konakart_demo.sql

3) I have created the WAR files:
      # cd custom
      # ant make_wars

4) I have copied the WAR files konakart.war and konakartadmin.war to the webapps directory of my own Tomcat

5) I have started my own Tomcat running on Port 8080 and am accessing the admin webapp via

    http://127.0.0.1:8080/konakartadmin/

6) I login as admin@konakart.com and can see the "My Store Status" page/screen, but receive the exception as mentioned within my previous email and also telling me within an iframe at the bottom that it cannot connect to localhost:8780

[greg]

There are some configuration variables in the database that will refer to the port you used at installation time (default 8780).   Change those to 8080 and see where that takes you.

Is it just the Admin App that doesn't work or is the konakart webapp as well?

Could be jars used by your tomcat are incompatible with those in the Admin App..  Check those in your tomcat lib vs those in the default tomcat lib in the download package.

The IFrame at the bottom is trying to show a report...  using the birtviewer at 8780 - that's defined in a configuration variable in the database.

[michaelwechner]

Thanks for your help. Indeed the port is referenced within

database/PostgreSQL/konakart_demo.sql

or rather

grep -rl 8780 database/PostgreSQL/*
database/PostgreSQL/konakart_demo.sql
database/PostgreSQL/upgrade_2.2.0.1_to_2.2.0.2.sql
database/PostgreSQL/upgrade_2.2.6.0_to_3.0.1.0.sql
database/PostgreSQL/upgrade_3.0.1.0_to_3.2.0.0.sql

Thanks

Michael

[michaelwechner]

Also these two files seem to contain the port 8780:

webapps/konakart/WEB-INF/classes/konakart_axis_client.properties
webapps/konakartadmin/WEB-INF/classes/konakartadmin_axis_client.properties

whereas it is not clear to me that if one should also replace 'localhost' by the real host name
when deployed on an actual server instead just locally?!

Cheers

Michael