Would KonaKart get any benefit from installing the Tomcat native library onto the server? I suppose it speeds up execution but only if certain functions are used.
Show posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
2
Feature Requests / Re: Product Templates
February 27, 2008, 06:10:43 pm
Those are good suggestions. Thanks!
3
Feature Requests / Product Templates
February 26, 2008, 02:19:15 am
Being able to mark a product entry as a template would be nice. It could be chosen to fill-in common information when creating new product entries.
Some stores may sell lots of unique products that share some attributes. Making product entries for such stores would be a particular chore, so having some amenities that help this situation could be a real plus.
Some stores may sell lots of unique products that share some attributes. Making product entries for such stores would be a particular chore, so having some amenities that help this situation could be a real plus.
4
Feature Requests / Re: multiple images
January 29, 2008, 07:10:18 am
FWIW, I implemented multiple images in a simple fashion where ShowImageBody uses struts logic to look for image filenames SKU_im1, SKU_im2, SKU_im3 etc. I then wrote a script to have imagemagick generate thumbnails from the first image for each SKU.
5
Installation of KonaKart / Hosting talk
January 29, 2008, 06:58:47 am
Not having a big deadline to get my konakart project online, I decided to try for the lowest priced hosting provider I could find with reasonable quality. Been through a number of providers since December with some interesting results:
GoDaddy: Don't recommend. Their MySQL support is old and their shared Tomcat is a total afterthought that can't handle much more than some lightweight jsps. As soon as you mention Java or Tomcat you will be mercilessly stonewalled by support.
Ubiquity: Not bad for a shared Tomcat. Can basically run Konakart. But they only do shared hosting and if you need a dedicated IP for SSL then forget it. Can't do port 80 or 843 access from Tomcat. Support was cowed by anything "Java".
Arvixe: Experienced hardware crash soon after signing up. Thereafter they couldn't keep Tomcat from crashing... seemed unable to setup mod_jk properly.
EatJ: Free trial accounts available, great for experimentation and can run KonaKart. But didn't answer my questions about specs for a paid account.
DailyRazor: You need their RazorBLAZE account at minimum to run KonaKart. Add $5/mo if you need an IP address. A bit pricey IMO and they say they are still gettin' around to refunding me before trial period is up. Hmmm...
4TVirtual: This one is a VPS. Rather inexpensive and have only seen good comments about them (incl. a report which rates them with very high uptime). Support is responsive and knowledgeable so far. They gave us two months free because of a billing hassle caused by their bank. They only offer VPS, so the usual tradeoffs apply: You get more control but also have to take care of firewall, ssh, etc. setup yourself so must be comfortable handling a Linux server. I also had to setup mod_jk myself, a non-trivial task (actually, I assumed I had to set it up... didn't ask support). Right now signing up for a year gets you a $13/mo rate with dedicated IP and 300MB memory, a better deal than Eapps.
In fact Eapps is the one obvious choice that I didn't try, and would have if 4T didn't work out.
As for Godaddy, I do recommend them for SSL certs. Very cheap and they don't work through the rather disturbing VeriSign racket. Search for SSL certs in Google then click on the Godaddy ad to get a discount.
I realize this falls somewhat outside of the scope of the Konakart group, as their product is aimed at in-house med-large projects. But its still a vital data point to see how easily an app can adapt to humble hosting constraints. The conclusion I have come to is that Tomcat apps in general do not faire well at all, and that the state of Java hosting appears to be a shambles compared to PHP, Python and Ruby. I ran into developer blogs that said "Java hosting kicked my @zz". This is one area that Sun and IBM need bear down on to secure the future of the platform, and that reflects on KonaKart indirectly.
Konakart itself is great and something I'll be sticking with for at least this one project, but if something happens to my current hosting service then I have less than a handful of affordable alternatives to choose from. Beyond those few alternatives, there is much negative variability from virtually unusable memory constraints to those shiny-new JDK 1.6 setups paired with obsolete Tomcat or Mysql, to being told you can't use port 80 or that support's lone "Java guy" will fix your problem in several days because he only comes in once a week. What PHP developer would put up with that at even $7/mo?
So that, in a nutshell, is my trip through Java hosting land. I hope some of it will be useful (or at least interesting) to readers here.
GoDaddy: Don't recommend. Their MySQL support is old and their shared Tomcat is a total afterthought that can't handle much more than some lightweight jsps. As soon as you mention Java or Tomcat you will be mercilessly stonewalled by support.
Ubiquity: Not bad for a shared Tomcat. Can basically run Konakart. But they only do shared hosting and if you need a dedicated IP for SSL then forget it. Can't do port 80 or 843 access from Tomcat. Support was cowed by anything "Java".
Arvixe: Experienced hardware crash soon after signing up. Thereafter they couldn't keep Tomcat from crashing... seemed unable to setup mod_jk properly.
EatJ: Free trial accounts available, great for experimentation and can run KonaKart. But didn't answer my questions about specs for a paid account.
DailyRazor: You need their RazorBLAZE account at minimum to run KonaKart. Add $5/mo if you need an IP address. A bit pricey IMO and they say they are still gettin' around to refunding me before trial period is up. Hmmm...
4TVirtual: This one is a VPS. Rather inexpensive and have only seen good comments about them (incl. a report which rates them with very high uptime). Support is responsive and knowledgeable so far. They gave us two months free because of a billing hassle caused by their bank. They only offer VPS, so the usual tradeoffs apply: You get more control but also have to take care of firewall, ssh, etc. setup yourself so must be comfortable handling a Linux server. I also had to setup mod_jk myself, a non-trivial task (actually, I assumed I had to set it up... didn't ask support). Right now signing up for a year gets you a $13/mo rate with dedicated IP and 300MB memory, a better deal than Eapps.
In fact Eapps is the one obvious choice that I didn't try, and would have if 4T didn't work out.
As for Godaddy, I do recommend them for SSL certs. Very cheap and they don't work through the rather disturbing VeriSign racket. Search for SSL certs in Google then click on the Godaddy ad to get a discount.
I realize this falls somewhat outside of the scope of the Konakart group, as their product is aimed at in-house med-large projects. But its still a vital data point to see how easily an app can adapt to humble hosting constraints. The conclusion I have come to is that Tomcat apps in general do not faire well at all, and that the state of Java hosting appears to be a shambles compared to PHP, Python and Ruby. I ran into developer blogs that said "Java hosting kicked my @zz". This is one area that Sun and IBM need bear down on to secure the future of the platform, and that reflects on KonaKart indirectly.
Konakart itself is great and something I'll be sticking with for at least this one project, but if something happens to my current hosting service then I have less than a handful of affordable alternatives to choose from. Beyond those few alternatives, there is much negative variability from virtually unusable memory constraints to those shiny-new JDK 1.6 setups paired with obsolete Tomcat or Mysql, to being told you can't use port 80 or that support's lone "Java guy" will fix your problem in several days because he only comes in once a week. What PHP developer would put up with that at even $7/mo?
So that, in a nutshell, is my trip through Java hosting land. I hope some of it will be useful (or at least interesting) to readers here.
6
Programming of KonaKart / Re: Category list not properly populated when accessing some url
January 26, 2008, 05:55:47 pm
http://www.thecrystalshard.com/shop/SelectProd.do?prodId=54&redir=true&manufacturer=nature&category=Thumbnail&name=Aquamarine%20Crystal%20-%20Namibia&model=Thumbnail
Then try removing '&redir=true' from the url. Also, if you click on a different product (say in another browser tab) then access the above url, the other product will be shown not the one that belongs to id 54.
BTW I'm mainly using Firefox 2.x to test, but have also tested this in Safari, Opera and Konqueror.
Then try removing '&redir=true' from the url. Also, if you click on a different product (say in another browser tab) then access the above url, the other product will be shown not the one that belongs to id 54.
BTW I'm mainly using Firefox 2.x to test, but have also tested this in Safari, Opera and Konqueror.
7
Programming of KonaKart / Re: Category list not properly populated when accessing some url
January 25, 2008, 09:16:26 pm
BTW - The category tile no longer shows as empty after the change, but I'd have to say that the modification doesn't work.
8
Programming of KonaKart / Re: Category list not properly populated when accessing some url
January 25, 2008, 09:14:46 pm
I inserted this into the jsp as directed, but its causing the 'home' page or other product page to load instead of the one corresponding to the url.
This only happens when the session is expired/does not yet exist and 'redir=true' is specified in the URL (which is most of the time).
This only happens when the session is expired/does not yet exist and 'redir=true' is specified in the URL (which is most of the time).
9
Programming of KonaKart / Re: Trying to compile custom payment module
January 25, 2008, 05:18:34 pm
Thanks for the clarification Pete...
I went ahead and used .COD, and the desired payment description still gets recorded in the orders table and shows up on invoices. That's as good as I need.
I went ahead and used .COD, and the desired payment description still gets recorded in the orders table and shows up on invoices. That's as good as I need.
10
Programming of KonaKart / Trying to compile custom payment module
January 25, 2008, 06:27:45 am
In Kona 2.2.0.6 I'm trying to compile a Check/Money Order payment module 'Checkmo.java' which is adapted from a copy of Cod.java, but I am getting an error "PaymentDetails.CHECKMO cannot be resolved".
Seems that 'PaymentDetails' class has a constant 'COD' of type integer. I guess what I need to know is whether I am stuck using 'COD' for my module? And if so, how will we tell the difference between orders paid by COD and those paid by Check?
Seems that 'PaymentDetails' class has a constant 'COD' of type integer. I guess what I need to know is whether I am stuck using 'COD' for my module? And if so, how will we tell the difference between orders paid by COD and those paid by Check?
11
Programming of KonaKart / Re: Category list not properly populated when accessing some url
January 25, 2008, 04:52:26 am
Thank you Pete. I will let you know shortly if it works.
12
Programming of KonaKart / Re: Category list not properly populated when accessing some url
January 24, 2008, 04:46:29 pm
I've noticed this too. It's a bug that limits the site's sales appeal when new shoppers go directly to a product page they found from a search engine, link from a friend or newsletter, etc.
I encourage the KonaKart developers to fix this one, as its probably the application's biggest UI flaw.
I encourage the KonaKart developers to fix this one, as its probably the application's biggest UI flaw.
13
Configuration of KonaKart / Missing modules?
January 22, 2008, 11:51:38 pm
I noticed that the properties files for konakart and admin refer to payment modules like 'MoneyOrder' and 'NoChex', as well as shipping modules 'Ups' and 'Usps' which do not appear as options anywhere in the main app or admin. Are these modules missing or hidden somewhere?
Some of these would seem to provide needed options for orders paid by check and money order, for instance.
Some of these would seem to provide needed options for orders paid by check and money order, for instance.
14
Miscellaneous / Re: Data truncation: Out of range value adjusted for column 'products_weight'
January 21, 2008, 06:36:30 pm
OK, thanks Julie.
15
Miscellaneous / Data truncation: Out of range value adjusted for column 'products_weight'
January 21, 2008, 06:01:01 pm
Since we have settled on grams for unit of weight, we will sometimes need values into the thousands. But we cannot add values greater than 999 to a product's weight field, which seems to be defined as DECIMAL(5,2).
This looks like a bug.
KonaKart 2.2.0.6
This looks like a bug.
Code Select
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'products_weight' at row 1
Exception Stack Trace =
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:106)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:653)
at org.apache.torque.util.BasePeer.access$000(BasePeer.java:80)
at org.apache.torque.util.BasePeer$4.process(BasePeer.java:1230)
at org.apache.torque.util.BasePeer.processTables(BasePeer.java:1716)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1225)
at com.konakartadmin.bl.AdminProductMgr.editProduct(AdminProductMgr.java:437)
at com.konakartadmin.bl.KKAdmin.editProduct(KKAdmin.java:2275)
at com.konakartadmin.server.KKAdminGWTServiceImpl.editProduct(KKAdminGWTServiceImpl.java:3262)
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:585)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:262)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:146)
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:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Exception Cause =
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2868)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at com.workingdogs.village.Record.saveWithUpdate(Record.java:349)
at com.workingdogs.village.Record.save(Record.java:234)
at com.workingdogs.village.Record.save(Record.java:198)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:650)
at org.apache.torque.util.BasePeer.access$000(BasePeer.java:80)
at org.apache.torque.util.BasePeer$4.process(BasePeer.java:1230)
at org.apache.torque.util.BasePeer.processTables(BasePeer.java:1716)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1225)
at com.konakartadmin.bl.AdminProductMgr.editProduct(AdminProductMgr.java:437)
at com.konakartadmin.bl.KKAdmin.editProduct(KKAdmin.java:2275)
at com.konakartadmin.server.KKAdminGWTServiceImpl.editProduct(KKAdminGWTServiceImpl.java:3262)
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:585)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:262)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:146)
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:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)KonaKart 2.2.0.6