New Install using MYSQL setup wizard failure

andrewgordo · October 8, 2018, 10:08pm

Hi - I am trying to follow the very limited guides on setting up MYSQL as i have been told that MS SQL isn’t supported anymore.
I have installed MYSQL and made as many of the suggested changes as possible, I can connect successfully to the razuna database
I cannot get past the Razuna Setup Wizard it just keeps sitting on the Finalize Setup screen with the progress bars moving that never stop
when i exit it makes me run the wizard again and i get back to the same place

it doesn’t matter what settings I try, it just wont work… any guidance would be appreciated.
Thanks
Andrew

not sure if this helps
{ts ‘2018-10-09 09:50:02’} — Executing Remove from Cron
{ts ‘2018-10-09 09:50:02’} ---------------------- Starting removal
{ts ‘2018-10-09 09:50:02’} ---------------------- Config Error. Aborting… !!!
±-------------±-
| type | Database
| detail | The datasource razuna_server could not be found or was invalid
| message | General SQL Error
| errorcode | errorCode.sqlError
| extendedinfo | javax.naming.NameNotFoundException: Name [razuna_server] is not bound in this Context. Unable to find [r
| tagcontext | {CFML Type::array}
| tagname | CFQUERY
| template | E:/tomcat/webapps/razuna-searchserver/api/authentication.cfc
| line | 71
| column | 4
±-------------±-

Neeru_Singh · October 10, 2018, 7:06am

I am also facing the same issue -Razuna with mysql database.

Nitai · October 10, 2018, 11:17am

The version of Razuna? MySQL version?

There are no “limited” guides as you don’t need anything else. The information you need is located at Setting up MySQL

scivray · October 12, 2018, 2:49pm

Hi,
I don’t know if this issue was corrected, but it may help you : Razuna 1.9.5 error in razuna/global/cfc/db_mysql.cfc

Regards.

jpaw · January 30, 2019, 1:51pm

Any luck with this? - I am having the same error with razuna 1.9.6 and MySQL 5.7

Leiping_Zhu · August 12, 2019, 8:46am

Same here,
Mysql: 5.6.45
razuna: 1.9.6

The error message. Whyt the cron jobs are connecting to H2 database when it was set to mysql.

app_1           | ============================ START
app_1           | {ts '2019-08-12 08:44:22'} --- Executing script cron job 1min
app_1           | {ts '2019-08-12 08:44:22'} ---------------------- Error script cron job 1min
app_1           | {
app_1           |   "type" : "Database",
app_1           |   "detail" : "The datasource h2 could not be found or was invalid",
app_1           |   "message" : "General SQL Error",
app_1           |   "errorcode" : "errorCode.sqlError",
app_1           |   "extendedinfo" : "javax.naming.NameNotFoundException: Name [h2] is not bound in this Context. Unable to find [h2].",
app_1           |   "tagcontext" : [ {
app_1           |     "id" : "CFQUERY",
app_1           |     "line" : 1495,
app_1           |     "column" : 3,
app_1           |     "template" : "/workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna/global/cfc/scheduler.cfc"
app_1           |   }, {
app_1           |     "id" : "CFFUNCTION",
app_1           |     "line" : 1491,
app_1           |     "column" : 2,
app_1           |     "template" : "/workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna/global/cfc/scheduler.cfc"
app_1           |   }, {
app_1           |     "id" : "CFINVOKE",
app_1           |     "line" : 65,
app_1           |     "column" : 2,
app_1           |     "template" : "/workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna/cron/cron.1min/sched_scripts.cfm"
app_1           |   }, {
app_1           |     "id" : "CFTRY",
app_1           |     "line" : 37,
app_1           |     "column" : 1,
app_1           |     "template" : "/workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna/cron/cron.1min/sched_scripts.cfm"
app_1           |   } ],
app_1           |   "tagname" : "CFQUERY",
app_1           |   "template" : "/workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna/global/cfc/scheduler.cfc",
app_1           |   "line" : 1495,
app_1           |   "column" : 3
app_1           | }
app_1           | {ts '2019-08-12 08:44:26'} --- Executing Remove from Cron
app_1           | {ts '2019-08-12 08:44:26'} ---------------------- Starting removal
app_1           | {ts '2019-08-12 08:44:26'} ---------------------- Config Error. Aborting... !!!!!!!!!!!!!!!!!!!!!!!!!
app_1           | +--------------+--
app_1           | |         type | Database
app_1           | |       detail | The datasource razuna_server could not be found or was invalid
app_1           | |      message | General SQL Error
app_1           | |    errorcode | errorCode.sqlError
app_1           | | extendedinfo | javax.naming.NameNotFoundException: Name [razuna_server] is not bound in this Context. Unable to find [r
app_1           | |   tagcontext | {CFML Type::array}
app_1           | |      tagname | CFQUERY
app_1           | |     template | /workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna-searchserver/api/authentication.cfc
app_1           | |         line | 70
app_1           | |       column | 4
app_1           | +--------------+--
app_1           | {ts '2019-08-12 08:44:26'} --- Executing Indexing from Cron
app_1           | {ts '2019-08-12 08:44:26'} ---------------------- Config Error. Aborting... !!!!!!!!!!!!!!!!!!!!!!!!!
app_1           | +--------------+--
app_1           | |         type | Database
app_1           | |       detail | The datasource razuna_server could not be found or was invalid
app_1           | |      message | General SQL Error
app_1           | |    errorcode | errorCode.sqlError
app_1           | | extendedinfo | javax.naming.NameNotFoundException: Name [razuna_server] is not bound in this Context. Unable to find [r
app_1           | |   tagcontext | {CFML Type::array}
app_1           | |      tagname | CFQUERY
app_1           | |     template | /workdir/razuna_tomcat_1_9_6/tomcat/webapps/razuna-searchserver/api/authentication.cfc
app_1           | |         line | 70
app_1           | |       column | 4
app_1           | +--------------+--

Leiping_Zhu · August 12, 2019, 9:19am

Sorry, I didn’t follow the instructions

after setting these variables, I can complete the initialization.

SET GLOBAL innodb_large_prefix = 1 ;

SET GLOBAL innodb_file_format = barracuda;

SET GLOBAL innodb_file_per_table = true ;

SET GLOBAL innodb_large_prefix = ON;

ddog800 · October 11, 2019, 2:43pm

I’ve been fighting this problem since yesterday. I’ve been trying to run:
Razuna 1.9.6
MySQL 5.7.24

I went through the guide to the letter, but continued to get stuck forever at “Finalizing setup”.

In the end, I had to downgrade MySQL to 5.6.45. Once I did that and went through all of the MySQL setup steps again, I was able to complete the wizard with no problems.

My final configuration is:
Razuna 1.9.6
MySQL 5.6.45

I’d initially tried MySQL 5.7 because the guide indicated “5.6 and above…”. It appears that it will not initialize properly on 5.7, so you’ll need to stick with 5.6.

On a slightly related note, I did some testing with MariaDB 10.3 (which has elements of MySQL 8.x). It appeared to work at first, but I ran into some other bizarre issues later on (i.e. folder tree “refreshing” forever). I wouldn’t recommend using that variant of MySQL with Razuna.

Nitai · October 16, 2019, 7:09pm

That’s because you did not read the settings you need to enable for MySQL 5.7.

Our paid Razuna offering supports MySQL 8 already. Please see what else is new over at https://trello.com/b/VyTSxfpf

ddog800 · October 18, 2019, 12:49am

Are you referring to the settings in the guide here?

If so, then yes, I configured all of these settings precisely as they are laid out in this guide. When it didn’t work, I blew it all away and tried it again. Unless there is something about CentOS 7 that is different from Ubuntu that could cause this problem, then it does not work with MySQL 5.7 or the guide is incomplete.

Nitai · October 18, 2019, 1:29am

Yes. I just installed a new server today with MySQL 5.7 and it worked. Sorry, don’t know what the issue is.