Quote:
Originally Posted by lerxst2112
|
I did some testing on this and it appears taking that route you suggested
does not really present a solution for it.
After re-sourcing my database, (with all tables in lower case),
I did a mysqladmin variable check and it was set to 0 by default.
So I changed it to 1 using the /etc/mysql/my.cnf with the line:
lower_case_table_names=1 (and restarted mysqld)
This did change the variable to 1, but when I tried to log my toon in to
world, I got the same error, (failed banned ip check).
I got to thinking afterwards, (I am no expert here, so I am just asking),
If the code in the source is set to query a table with mixed/upper/lower case
letters, doesn't setting that mysql to 1, simply just force the use of lower
case table names and really doesn't do anything for the app that is querying
the database ? (the query is still looking for Banned_IPs, not banned_ips).
When I tried this using the EQEmuLoginServer, mysql couldn't find the logindb,
when I restarted itbecause the table names are in a mixture of upper/lower
case.
So you get the same result. whether the lower_case_table_names is set to
0 or 1
I'm guessing maybe there is something I am missing, since it's evident that
others are running linux servers, without these problems
