search

inclusive-design / AChecker

Automated interactive Web content accessibility checker.
https://achecker.ca
GNU General Public License v2.0
70 stars 61 forks source link

MariaDB not working #57

Open foxpcteam opened 7 years ago

foxpcteam commented 7 years ago

Hi, I tried to install the AChecker but i get error at mysql step. I am using MariaDB can the AChecker work with MariaDB?

cindyli commented 7 years ago

AChecker only works with MySQL DB.

However, if you were a developer, the support of a new DB could be added by overriding AChecker DAO classes.

jtmoree-github-com commented 6 years ago

This title is confusing. the title suggests that MariaDB is working but the comments state otherwise. Which is it?

cindyli commented 6 years ago

@jtmoree-kahalamgmt-com, AChecker does not work with MariaDB. It only supports MySQL. Supporting other databases is possible but requires more development.

jtmoree-github-com commented 6 years ago

Thank you for the clarification. Can you give a little more detail on why this would not work? Mysql and MariaDb are derived from the same codebase and currently have binary compatibility at the data level. The differences in syntax, commands, and other calls are minimal. Shouldn't the client code not be able to tell the difference between a databased hosted by one or the other? So far, I have used all of the same mysql libraries and clients with mariadb servers without problem.

cindyli commented 6 years ago

@jtmoree-kahalamgmt-com, thanks for the information. I'm not familiar with MariaDB.

After reading a bit more on PHP with MariaDB, it seems once a MariaDB account is configured to use the new password encryption method, the PHP connectors for MySQL generally work with MariaDB as well. If you plan to try MariaDB with AChecker, your feedback on how it goes is appreciated.

jtmoree-github-com commented 6 years ago

We installed a dev setup with mysql 5.6 then migrated the database to Centos 7 with stock mariadb 5.5 and so far it is working.

cindyli commented 6 years ago

YAY! Great to know, thanks, @jtmoree-kahalamgmt-com.