[Opensim-users] MySQL Errors Unique to Linux and .net

[James Harrison]

Looks very much like a permissions problem to me. Have you set your 
MySQL user up properly for everything? What components are you using 
with MySQL? Does anything work with MySQL?

SELECT TABLES is a generic command to show tables in a database. Seems 
to me you've not got your GRANT statement right when setting up your 
user, or not set it up in the Opensim configuration.

Terry Ford wrote:
> Hi all,
>
> I'm new to the list but look forward to participating often.
> I have been able to compile/run .5 on my XP machine using mysql and it 
> works well.
>
> I decided to try to run it from my linux machine using mysql but 
> everytime I try starting the user server or the main opensim.exe file I 
> keep rec'ing the following error:
>
> Unhandled Exception: MySql.Data.MySqlClient.MySqlException: SELECT 
> command denied to user: 'username at localhost' for table 'TABLES'
>   at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]
>   at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& 
> affectedRows, System.Int64& lastInsertId) [0x00000]
>   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000]
>   at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
>
> I've have done some research on my own and have found this to be a linux 
> specific problem when using c#.
>
> Has anyone figured out a workaround??
>
> Thanks,
> -Terry
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>   

-- 
---

James Harrison
Balveda Studios
http://www.balvedastudios.com/