[Opensim-users] Unable to connect to any of the specified MYSQL hosts

[Paul Rayner]

Thomas - I also tried localhost. Same error.
Luisillo - I used the tutorial @
http://opensimulator.org/wiki/Database_Settings and used those same
settings.

The database has been created - called opensim
User created for that database - opensimuser. Have tried both
opensimuser at localhost and opensimuser at 127.0.0.1.
Using root in MYSQL CLI - did the grant all on opensim.* to
'opensimuser'@'localhost';
and also 'opensimuser'@127.0.0.1;

Commented SQLite out in the StandAloneCommon.ini. Uncommented 2 lines in
MYSQL area, and changed string to suit my settings.

The OpenSim server and MYSQL server are both on the same machine (Ubuntu
11.10).

I know I'm not a Linux or MYSQL guru - so happy to answer any questions in
the quest to get this to work. I know full well it be operator error - so
I'm ready for that too.

Paul


On Tue, Apr 2, 2013 at 2:22 PM, Luisillo Contepomi <
luisillocontepomi at gmail.com> wrote:

> The error is "Connection refused".
> May be your server mysql have not user or database configured before you
> try to use.
> Your configuration: Data Source=127.0.0.1;Database=opensim;User
> ID=opensimuser;Password=xxxxx;
>
> Has you the mysql server in the same machine? if your answer is yes... ok
> the host can be localhost or 127.0.0.1
> Has you create before the database named "opensim", user named
> "opensimuser" with all permisions for this database in your mysql server?
>
> If not... doit and then start your region
> Regards,
> Luisillo
>
>
>
> 2013/4/2 Paul Rayner <prayner.basil at gmail.com>
>
>> Hi
>>
>> my server is Ubuntu 11.10, and it runs an out of the box LAMP  setup.
>>
>> I downloaded and installed OpenSim 0.7.5, and it ran out of the box using
>> SQLite. When I "followed" the tutorial at
>> http://opensimulator.org/wiki/Database_Settings to switch to a MYSQL
>> version of opensim, it won't start.
>> The pastebin of the error is pastebin.com/iK9bAPkX.
>>
>> I've tried to resolve my error at #opensim on IRC without success. Some
>> very patient helpers, as I'm neither a Linux nor MYSQL guru.
>>
>> While I have few days off, I'd love to get it running in time for school
>> again soon.
>>
>> I'd appreciate any advice
>>
>> Paul
>>
>> --
>> To subscribe to the ITS mailing list, go to
>> http://lists.otn.edu.au/mailman/listinfo/qsite-its.
>>
>> To email the list, use
>> qsite-its at lists.otn.edu.au
>>
>>
>>
>> _______________________________________________
>> 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
>



-- 
To subscribe to the ITS mailing list, go to
http://lists.otn.edu.au/mailman/listinfo/qsite-its.

To email the list, use
qsite-its at lists.otn.edu.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20130402/508814d1/attachment.html>