Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support for MariaDB 10.5 #37

Closed
bschmalhofer opened this issue May 22, 2020 · 5 comments
Closed

Support for MariaDB 10.5 #37

bschmalhofer opened this issue May 22, 2020 · 5 comments
Milestone
OTOBO 10.0.1

Comments

@bschmalhofer
Copy link
Contributor

bschmalhofer commented May 22, 2020 •
edited
Loading

ManiaDB 10.5 does not spport the CREATE USER ... IDENTIFIED WITH .. BY ... syntax. An alternative might be to use IDENTIFIED WITH .. AS PASSWORD(...) . This should also work on MySQL 5.7 and MySQL 8.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 22, 2020
@bschmalhofer
Issue RotherOSS#31 and RotherOSS#37: Adapt the CREATE USER statement …
0ed6bbf 
…for MariaDB 10.3

Looks like there is no IDENTIFIED BY in MariaDB
@bschmalhofer
Copy link
Contributor Author

It would be interesting to see what happens when using the simple statement:
CREATE USER $DB{OTOBODBUser}\@$HostIDENTIFIED BY '$DB{OTOBODBPassword}',
I don't know why the authorisation backend needs to be specified. Simply use the default backend.

@bschmalhofer
Copy link
Contributor Author

Testing under MySQL 5.7 resulted in an error.

@StefanRother-OTOBO
Copy link
Contributor

CREATE USER $DB{OTOBODBUser}@$HostIDENTIFIED BY '$DB{OTOBODBPassword}' works for MySQL 5.7 and MariaDB.

Thanks Bernhard!

@StefanRother-OTOBO
Copy link
Contributor

MySQL 8 works too. Changed and closed.

@bschmalhofer
Copy link
Contributor Author

bschmalhofer commented Jun 5, 2020 •
edited
Loading

This is broken again for MaraDB as MariaDB chokes on the 'WITH mysql_native_password' . @StefanRother-OTOBO please reopen the isssue.
See https://mariadb.com/kb/en/authentication-plugin-mysql_native_password/

@bschmalhofer bschmalhofer mentioned this issue Jun 8, 2020
Closed
@bschmalhofer bschmalhofer added this to the OTOBO 10.0 milestone Jul 22, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
OTOBO 10.0.1
Development

No branches or pull requests
2 participants
@bschmalhofer @StefanRother-OTOBO