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

[Todd Davis]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20130402/42d70e7f/attachment.html>