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

Tue Apr 2 22:14:47 UTC 2013

That was the problem....changed it...and it worked. Thanks for all your
responses.

On Wed, Apr 3, 2013 at 7:56 AM, Paul Rayner <prayner.basil at gmail.com> wrote:

> Pardon my ignorance here - do you mean "bind address" - 192.168.x.xxx
>
> The internal IP of the server.
>
>
> On Wed, Apr 3, 2013 at 12:02 AM, Todd Davis <
> opensiminfo at virtualrealmsgrid.com> wrote:
>
>> What is your MySQL server listening on in the my.cnf.     I set mysql to
>> listen on 0.0.0.0.   I believe the default is 127.0.0.1.     May try to
>> change it.
>>
>> Todd
>>
>>
>> Sent from my iPhone
>>
>> On 2013-04-02, at 2:18 AM, Paul Rayner <prayner.basil at gmail.com> wrote:
>>
>> Connect just to the database??? Yes
>> Just create another database (for a PHP exercise I'm working on) and that
>> connected OK using the instructions from the OpenSim wiki.
>>
>> Paul
>>
>>
>> On Tue, Apr 2, 2013 at 3:59 PM, Luisillo Contepomi <
>> luisillocontepomi at gmail.com> wrote:
>>
>>> Can you connect successfully from a mysql shell, from the same machine,
>>> with the username and password in the database server?
>>>
>>>
>>> 2013/4/2 Paul Rayner <prayner.basil at gmail.com>
>>>
>>>> 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
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>
>>
>>  _______________________________________________
>> 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
>
>
>

-- 
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/20130403/44de98ea/attachment.html>