Hello – I’m trying to install self-hosted (1.8) and am getting the following error in the Bluedragon runtime logs when the installation is trying to finalize:
CFML Runtime Error
Need some help? Visit our manual http://openbd.org/manual/
General SQL Error
Request /admin/index.cfm
File Trace /var/lib/tomcat7/webapps/razuna/admin/index.cfm
|
±- /var/lib/tomcat7/webapps/razuna/global/fusebox5/corefiles/fusebox5.cfm
|
±- /var/lib/tomcat7/webapps/razuna/global/fusebox5/corefiles/Application.cfc
|
±- /var/lib/tomcat7/webapps/razuna/admin/parsed/c.first_time_final.cfm
|
±- /var/lib/tomcat7/webapps/razuna/global/cfc/hosts.cfc
|
±- /var/lib/tomcat7/webapps/razuna/global/cfc/db_mysql.cfc
Type Database
Function(s) onError (/var/lib/tomcat7/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=267, Column=2)
|
±-onRequest (/var/lib/tomcat7/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=218, Column=2)
|
±-setupdb (/var/lib/tomcat7/webapps/razuna/global/cfc/hosts.cfc, Line=32, Column=1)
|
±-create_host (/var/lib/tomcat7/webapps/razuna/global/cfc/db_mysql.cfc, Line=1356, Column=2)
|
±-create_tables (/var/lib/tomcat7/webapps/razuna/global/cfc/db_mysql.cfc, Line=1364, Column=2)
Query Error Specified key was too long; max key length is 767 bytes
Datasource MYSQL
Native Error Code 1071
SQL State 42000
SQL CREATE TABLE razuna.raz1_files […output truncated, let me know if you want the full error file…]
I’m a bit baffled by this, as it seems like it would prevent MySQL installs from ever working (the key size limitation is a known constraint of InnoDB tables). I also tried 1.7, and it was affected by the same problem.
I’d really like to try Razuna because it looks like it’ll do exactly what I want, but am stuck on this.
We are installing Razuna multiple times a week on MySQL and we never saw this issue. Did you follow the guidelines for your MySQL setup at http://wiki.razuna.com/display/ecp/MySQL ?
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.
[HM_565272b5fc1324720c2ac726@helpmonks.com,565272affc1324720c2ac722@helpmonks.com] dtwright repliedMonday, November 23rd 2015, 1:58 amdtwright
November 23
Thanks, I missed the needed global settings on that page – switched from using an Amazon RDS DB to a local mysql install and added those settings to my.cnf, and all is working now.