Anonymous | Login | Signup for a new account | 2021-01-23 13:05 PST | ![]() |
Main | My View | View Issues | Change Log | Roadmap | Summary | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | |||||
0005314 | opensim | [GRID] Robust Server | public | 2011-01-07 10:25 | 2011-02-03 05:30 | |||||
Reporter | samiam | |||||||||
Assigned To | ||||||||||
Priority | normal | Severity | minor | Reproducibility | always | |||||
Status | confirmed | Resolution | open | |||||||
Platform | Operating System | Operating System Version | ||||||||
Product Version | master (dev code) | |||||||||
Target Version | Fixed in Version | |||||||||
Summary | 0005314: Upper/Lower Case issues with mysql comunity server | |||||||||
Description | This one i chased around a bit after updating Mysql to current stable version. The data imports ok but now cares about the Upperlower case of the tables and fields. In My case it couldent read (MySql says they dosent exist) useraccounts and presence tables. It calls UserAcounts vrs all lowcase ect.. To workaround this i found a setting in Mysql Advanced that tells it to ignore case alltogether. Setting this worked and robust runs ok at this point. Im not shure if this is an actual bug with just the 2 tables or because of the changes to Mysql server revs. It only rejected thoughs 2 tables and only when a client trys to connect to robust. I thought at least i should point it out as out of the box its checking this now. The newer Mysql ships with most new linux distros btw. In my case SUSE 11.3 Tnx | |||||||||
Tags | No tags attached. | |||||||||
Git Revision or version number | .71 dev current master trunk | |||||||||
Run Mode | Grid (Multiple Regions per Sim) | |||||||||
Physics Engine | ODE | |||||||||
Script Engine | ||||||||||
Environment | Mono / Linux64 | |||||||||
Mono Version | 2.8 | |||||||||
Viewer | any | |||||||||
Attached Files | ||||||||||
![]() |
|
(0017800) samiam (reporter) 2011-01-07 12:02 |
SubNote: Dbl checked the data base from the working Msql Tables to the restored Data in the new rev. and all tables came out the same (both are lowercase). As i was testing this to evalate SUSE and the newer Mysql, i dident save the robust log sadly. Just my scrbble notes.. sry |
(0017940) Fly-Man- (developer) 2011-02-03 05:30 |
When changing your MySQL installation to include the following in the my.cnf lower_case_table_names = 1 If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive. (http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names [^]) |
![]() |
|||
Date Modified | Username | Field | Change |
2011-01-07 10:25 | samiam | New Issue | |
2011-01-07 10:25 | samiam | Git Revision | => .71 dev current master trunk |
2011-01-07 10:25 | samiam | SVN Revision | => 0 |
2011-01-07 10:25 | samiam | Run Mode | => Grid (Multiple Regions per Sim) |
2011-01-07 10:25 | samiam | Physics Engine | => ODE |
2011-01-07 10:25 | samiam | Environment | => Mono / Linux64 |
2011-01-07 10:25 | samiam | Mono Version | => 2.8 |
2011-01-07 10:25 | samiam | Viewer | => any |
2011-01-07 12:02 | samiam | Note Added: 0017800 | |
2011-02-03 05:30 | Fly-Man- | Note Added: 0017940 | |
2011-02-03 05:30 | Fly-Man- | Status | new => confirmed |
2014-01-23 15:41 | justincc | Category | Robust Server => [GRID] Robust Server |
Copyright © 2000 - 2012 MantisBT Group |