search

ogallagher / tejos_textiles

An online arts journal for publishing works in a new medium
MIT License
1 stars 0 forks source link

Database permission denied for admin user #116

Closed ogallagher closed 2 months ago

ogallagher commented 2 months ago

I'm seeing errors when accessing some db tables.

failed db query = call user_records('Francis C. Woodworth')
error in db data fetch: Error: ER_TABLEACCESS_DENIED_ERROR: SELECT command denied to user '<admin-user>'@'<server-ip>' for table 'plays'

failed db query = call search_all('.*((owen)).*')
error in db data fetch: Error: ER_TABLEACCESS_DENIED_ERROR: SELECT command denied to user '<admin-user>'@'<server-ip>' for table 'puzzles'
ogallagher commented 2 months ago

Not sure why my previous set of db allowable hosts was not working, but I ended up setting it to a single entry of % to not restrict db client connections by address. Certainly a more vulnerable configuration, relying only on the db user password, but I'm satisfied as is.