montera34 / pageonex

PageOneX. Analyzing front pages
http://pageonex.com
GNU Affero General Public License v3.0
54 stars 13 forks source link

Fix mysql config permissions for Windows users #241

Closed rporres closed 2 years ago

rporres commented 2 years ago

Windows docker mounts are in world writable mode, which makes mysql ignore our port configuration. This patch solves it in a brutal way, by manually setting the permissions of the file rather than playing with docker mount syntaxes that may or may not work depending on the FS driver.

Fixes #240

Signed-off-by: Rafa Porres Molina rporresm@redhat.com

NoahAssam commented 2 years ago

how exactly do I access the port or the MySQL when referring to the same issue as before. also, what is this the file location '/var/run/mysqld'

mysql_1 | 2022-03-15 22:59:58 1 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. mysql_1 | 2022-03-15 22:59:58 1 [Warning] 'proxies_priv' entry '@ root@8d2195861cd8' ignored in --skip-name-resolve mode. mysql_1 | 2022-03-15 22:59:58 1 [Note] Event Scheduler: Loaded 0 events mysql_1 | 2022-03-15 22:59:58 1 [Note] mysqld: ready for connections. mysql_1 | Version: '5.6.40' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)

rporres commented 2 years ago

hi @NoahAssam . Can you create a new issue detailing what you're trying to do and which is your problem?