faulted linux installation

[talh]

Hi,

I am trying to install konakart on centos 4.3 Using the installation command:

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

[talh]

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

[heidi]

Hi,

You need to put all the commands on one line... it appears that you didn't do that?

Heidi

[talh]

sure, it's one-lined...

[heidi]

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

[talh]

Hi again,

tried, getting the same error:

[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

[heidi]

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

[talh]

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:

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.

[talh]

* it's MSSql database (i have created the db) and konakart.sh script to automate the installation process as we talked earlier :

#!/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?

[heidi]

Well...  yes,  you haven't created the database, so double-check your database parameters.

Yes, that driver works for me.

Heidi.

[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

[talh]

Hi Heidi,

Thanks for the information, it's working fine now.

I've created bash script to automate it:

#!/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.

[heidi]

That's good 

Thanks for confirming that you got there in the end !!

Heidi