CFML Runtime Error:General SQL Error

Razuna v2 Legacy Self-Hosted
1

I install Razuna 1.7 Stand-alone Serve on centos 6.6 today ,Install Razuna on Linux:http://wiki.razuna.com/display/ecp/Install+Razuna+on+Linux.
Error :
,

Thank you

2

A SQL error, means a SQL error :wink: In other words, check that the database
is up and running and permissions are set properly.

To see the full error go to (/razuna/WEB-INF/bluedragon/work/temp/rtelogs)

3

razuna can not create h2 db，why？

4

No idea. But it would be good to know a bit more what you are doing :wink:

5

I am getting the same error. What I am doing is following the installation guide that has absolutely no mention of starting a database. Only run the ./startup.sh script in the tomcat/bin directory then connect to Razuna. Doing that returns that error. However, if I connect to server:8080/razuna/bluedragon/administrator I am able to login with BlueDragon’s default password. But the “First Time Startup” of Razuna does not run.

6

Getting the same error after installing and following the guide with razuna 1_7 on Mac OSX

7

SAME PROBLEM.

fresh install on amazon ec2 linux centos, followed install docs to the letter, all went well, except when i run ./startup i get this

./startup.sh
Using CATALINA_BASE: /opt/razuna_tomcat_1_7/tomcat
Using CATALINA_HOME: /opt/razuna_tomcat_1_7/tomcat
Using CATALINA_TMPDIR: /opt/razuna_tomcat_1_7/tomcat/temp
Using JRE_HOME: /usr/lib/jvm/jre
Using CLASSPATH: /opt/razuna_tomcat_1_7/tomcat/bin/bootstrap.jar:/opt/razuna_tomcat_1_7/tomcat/bin/tomcat-juli.jar
Tomcat started.

and tomcat isn’t started

so then i run ./catalina.sh run

and it runs, then i connect to http:// ip:8080 /razuna/ and it redirects to http://ip:8080/razuna/admin/index.cfm

and i have same error message, i have checked permissions, i have deleted, retried unzip standalone 1.7 many times

i have tried in this order, and deleting / unzipping fresh standalone each time.

chmod 777 -R /opt/razuna_tomcat_1_7/tomcat/webapps/razuna/db – didn’t help
chmod 777 -R /opt/razuna_tomcat_1_7/tomcat/webapps/razuna/assets – didn’t help
chmod 777 -R /opt/razuna_tomcat_1_7/tomcat/webapps/razuna – didn’t help
chmod 777 -R /opt/razuna_tomcat_1_7 – didn’t help

not sure why the opendb can’t run the last step “Once the server has successfully started you should navigate to http://localhost:8080/razuna and you will be presented with the Firsttime Wizard to finish setup.”

how to get “irsttime Wizard to finish setup” - it seems the standalone zip is zipped with wrong permissions?

==== editing here ====

here’s the bderror -

IO Exception: “java.net.UnknownHostException: ip-10-10-16-4: ip-10-10-16-4: Name or service not known” [90028-174]

please advise… thanks for help in advance!

8

okay, well, i solved this, here’s how i did it

actual error from bderror was "IO Exception: “java.net.UnknownHostException: ip-10-10-16-4: ip-10-10-16-4: Name or service not known”

so i found a solution on http://stackoverflow.com/questions/6484275/what-causes-the-error-java-net-unknownhostexception

To resolve:

  1. Do echo $HOSTNAME on your terminal.
  2. Whatever hostname it shows (lets say myHostName), try to ping it : ping myHostName. If it returns ping: cannot resolve myHostName: Unknown host then add an entry into your /etc/hosts file.
  3. For that edit /etc/hosts file and add following:

127.0.0.1 myHostName

then it runs past this screen…

Hope it helps.