search

apioo / fusio

Open source API management platform
https://www.fusio-project.org
Apache License 2.0
1.84k stars 220 forks source link

Installation issue (oci8) #328

Open dataforce-troy opened 4 years ago

dataforce-troy commented 4 years ago

Having some issues with installation.

I am using Oracle database and OCI8 driver.

I was unable to use install.php script, received error "could not connect to database" so tried manual method instead.

Updated .env as directed, then after running php bin/fusio install it runs through and creates tables, triggers sequences etc but then throws error when trying to insert admin user record:

++ migrating 20180713131743

 -> INSERT INTO fusio_user (status, name, email, password, points, date) VALUES (?, ?, ?, ?, ?, ?) with parameters ([1], [Administrator], [admin@localhost.com], [], [], [2020-08-31 00:32:14])

Migration 20180713131743 failed during Execution. Error An exception occurred while executing 'INSERT INTO fusio_user (status, name, email, password, points, date) VALUES (?, ?, ?, ?, ?, ?)' with params [1, "Administrator", "admin@localhost.com", "$2y$10$Oo13xKPCqZdHgrxLpqbWYeXWjk5bVB9EYxdIJrH644.1T2HNmK6LK", null, "2020-08-31 00:32:14"]:

ORA-01747: invalid user.table.column, table.column, or column specification

In AbstractOracleDriver.php line 57:

An exception occurred while executing 'INSERT INTO fusio_user (status, name, email, password, points, date) VALUES (?, ?, ?, ?, ?, ?)' with params [1, "Administrator", "admin@localhost.com", "$2y$10$Oo13xKPCqZdHgrxLpqbWYeXWjk5bVB9EYxd
IJrH644.1T2HNmK6LK", null, "2020-08-31 00:32:14"]:

ORA-01747: invalid user.table.column, table.column, or column specification

In OCI8Exception.php line 20:

ORA-01747: invalid user.table.column, table.column, or column specification

migration:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--connection CONNECTION] [--] []

chriskapp commented 4 years ago

Hi, mhh I would guess that the user table contains a column name which is reserved in oracle, I would recommend to use either postgres or mysql/mariadb since our CI server test both databases.