Fresh install fails (ubuntu 19.10)

opennetadmin / ona

OpenNetAdmin IP Address Management (IPAM) system

opennetadmin.com

GNU General Public License v2.0

136 stars 34 forks source link

Fresh install fails (ubuntu 19.10) #148

Closed dmgeurts closed 4 years ago

dmgeurts commented 4 years ago

Fresh install on a Raspberry pi (natively supported since 19.10).

Connected to 'localhost' as 'root'.
Dropped existing instance of 'ona_default'.
Created new database 'ona_default'.
Selected existing DB: 'ona_default'.
There was an error processing tables. -- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ( id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, ' at line 1
There was a fatal error. Install may be incomplete. Fix the issue and try again.

PHP version 7.3 MySQL version 8.0.18 (MariaDB)

dmgeurts commented 4 years ago

I can manually create the groups table using the code from /opt/ona/install/ona-table.sql tp create table 'groups'.

dmgeurts commented 4 years ago

Using the CLI installer yields the same result. But doesn't show any errors.

dmgeurts commented 4 years ago

Using the dev branch and CLI I get the same error as when using the webinstall:

There was an error processing tables.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server 
version for the right syntax to use near 'groups (
id                       INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
' at line 1
There was a fatal error. Install may be incomplete. Fix the issue and try again

dmgeurts commented 4 years ago

Found the issue. the conversion from xml file to sql doesn't wrap table names in back-ticks (`). The table called groups must be wrapped in these for the sql table creation to work.

dmgeurts commented 4 years ago

Wrapping the groups table name in backticks in the xml schema file resolves that issue. Next:

ERROR => There was an error creating DB user: You have an error in your SQL syntax; check the manual that co
rresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'xxxxxxxxxx'' at line 1

mattpascoe commented 4 years ago

I have an idea of why its not working.. mysql 8+ has made some changes to how the user is created. I need to test a few things and see what I can come up with. It should just be an update to the syntax of the user create.

cj0nes commented 3 years ago

Are there any updates to this? Or at least a workaround? I'm hitting the same issue with the DB user creation.

mattpascoe commented 3 years ago

@cj0nes there are some workarounds we might try but first, have you tried the development branch? It had some updates that should have fixed the issue. Please confirm if it is, or is not working for you. Thanks!