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

[sered secondlife]

Agreed, it looks like the default MySQL configuration in 
bin/mysql_connection.ini for OpenSim has not been adapted for the local 
system. There are several instructions for OpenSim and MySQL that 
suggest using the root account, but I agree with Kyle that using a 
separate, dedicated account is much better.

Cheers,
Sered

Kyle Hamilton wrote:
> I must point out that it's not at all recommended to run any service
> using the root user (it's literally akin to running things
> authenticated as 'sa' under Oracle).
>
> That said, if it works with the root user, then it's not an OpenSim
> problem, it's a MySQL permission-configuration problem.  (Which, from
> the original message, is what that error message indicates anyway.)
>
> -Kyle H
>
> On Wed, Feb 27, 2008 at 2:51 PM, ken yasue <ken at grid-pion.com> wrote:
>   
>> I had same problem in OpenSim0.5.0 release in LinuxBox.
>>  I just changed to connect mysql by root user, and it worked.
>>  So try connect with root user... If you can :)
>>
>>  Ken Yasue
>>
>>
>>
>>  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
>>  >
>>  >
>>
>>  _______________________________________________
>>  Opensim-users mailing list
>>  Opensim-users at lists.berlios.de
>>  https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>     
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>