0005314: Upper/Lower Case issues with mysql comunity server

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

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

OS 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

Relationships

Notes
(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 [^])

Issue History
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