Hi,
I am trying to install konakart on centos 4.3 Using the installation command:
Quote
./KonaKart-2.2.2.0-Linux-Install -DDatabaseType mssqlserver -DDatabaseUrl jdbc:jtds:sqlserver://10.10.50.246:1433/mykkdb;SelectMethod=cursor -DDatabaseUsername XX -DDatabasePassword XXXXX -DPortNumber 80 -DDBLoad 1 -DDatabaseDriver net.sourceforge.jtds.jdbc.Driver -DmssqlDBO sa -DJavaJRE /usr/java/jdk
The problem is that the installation just ignores every command i wrote it's putting mysql (as default) including port 8780 and nothing work's...
Any idea?
Please, i need it urgent.
Hello again,
To be more preciesd:
[root@hgsql isos]# ./KonaKart-2.2.2.0-Linux-Install -S -DDatabaseType mssqlserver -DDatabaseUrl jdbc:jtds:sqlserver://10.10.50.246:1433/mykkdb;SelectMethod=cursor -DDatabaseUsername sa -DDatabasePassword XXXXX -DDatabaseDriver net.sourceforge.jtds.jdbc.Driver -DmssqlDBO sa -DJavaJRE /usr/java/jdk -DPortNumber 80 -DDBLoad 1
-bash: -DDatabaseUsername: command not found
Hi,
You need to put all the commands on one line... it appears that you didn't do that?
Heidi
sure, it's one-lined...
Hi,
I think the problem could be that you have specified
-DDatabaseType mssqlserver
when you should actually use:
-DDatabaseType mssql
Can you give that a try and let us know.
Thanks,
Heidi
Hi again,
tried, getting the same error:
Quote
[root@hgsql isos]# ./KonaKart-2.2.2.0-Linux-Install -S -DDatabaseType mssql -DDatabaseUrl jdbc:jtds:sqlserver://10.10.50.246:1433/mykkdb;SelectMethod=cursor -DDatabaseUsername sa -DDatabasePassword correl -DDatabaseDriver net.sourceforge.jtds.jdbc.Driver -DmssqlDBO sa -DJavaJRE /usr/java/jdk -DPortNumber 80 -DDBLoad 1
-bash: -DDatabaseUsername: command not found
Thanks for the fast reply
Your shell doesn't seem to be interpreting the commands properly as it thinks "-DDatabaseUsername" is a command.
I can run this successfully in the bash shell on CentOs:
kitName=./kits/KonaKart-${KONAKART_VERSION}-Linux-Install
${kitName} -S \
-DDatabaseDriver net.sourceforge.jtds.jdbc.Driver \
-DDatabaseUsername ${dbuser} -DDatabasePassword pwd \
-DDatabaseType mssql \
-DDatabaseUrl jdbc:jtds:sqlserver://westham:1597/konakart \
-DmssqlDBO ${dbuser} \
-DLoadDB 1 \
-DJavaJRE "${JAVA_HOME}"
Why don't you try moving the DatabaseUrl to the end (or removing parameters one by one) to see if you can narrow down the problem in your shell.
Perhaps it doesn't like the ";" in your URL. You should be able to remove ";SelectMethod=cursor"
Heidi
thanks,
there is no error in installation now,
but it simply doesn't create the database (it's empty)
and i'm getting this error:
Quote
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Cannot find bean: "konakartKey" in any scope
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.servlet.ServletException: Cannot find bean: "konakartKey" in any scope
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.WEB_002dINF.jsp.MainLayout_jsp._jspService(MainLayout_jsp.java:305)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.servlet.jsp.JspException: Cannot find bean: "konakartKey" in any scope
org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:935)
org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:230)
org.apache.jsp.WEB_002dINF.jsp.MainLayout_jsp._jspService(MainLayout_jsp.java:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:239)
org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
* it's MSSql database (i have created the db) and konakart.sh script to automate the installation process as we talked earlier :
Quote
#!/bin/sh
kitName=/mnt/isos/KonaKart-2.2.2.0-Linux-Install
${kitName} -S \
-DDatabaseDriver net.sourceforge.jtds.jdbc.Driver \
-DDatabaseUsername sa -DDatabasePassword xxxxxx \
-DDatabaseType mssql \
-DDatabaseUrl jdbc:jtds:sqlserver://10.10.50.246:1143/konakart \
-DmssqlDBO sa \
-DLoadDB 1 \
-DJavaJRE "/usr/java/jdk" \
-DPortNumber 80
is net.sourceforge.jtds.jdbc.Driver is the right driver to use for mssql?
Well... yes, you haven't created the database, so double-check your database parameters.
Yes, that driver works for me.
Heidi.
Have you looked at a log file called something like <KonaKart-Home-Dir>/DBLoadResult-mssql.log?
Perhaps it has some clues in it?
Heidi
Hi Heidi,
Thanks for the information, it's working fine now.
I've created bash script to automate it:
Quote
#!/bin/sh
kitName=/mnt/isos/KonaKart-2.2.2.0-Linux-Install
${kitName} -S \
-DDatabaseDriver net.sourceforge.jtds.jdbc.Driver \
-DDatabaseUsername sa -DDatabasePassword xxxxx \
-DDatabaseType mssql \
-DDatabaseUrl "jdbc:jtds:sqlserver://10.10.50.246:1433/mykkdb;SelectMethod=cursor" \
-DmssqlDBO xx \
-DLoadDB 1 \
-DJavaJRE "/usr/java/jdk" \
-DPortNumber 80
Thank you for your help
Mostly appriciated.
That's good :)
Thanks for confirming that you got there in the end !!
Heidi