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 <[email protected]> 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 > <[email protected]> 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 <[email protected]> >>> 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@localhost and [email protected]. >>> 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 >>> <[email protected]> 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 <[email protected]> >>>>> 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 >>>>> [email protected] >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Opensim-users mailing list >>>>> [email protected] >>>>> https://lists.berlios.de/mailman/listinfo/opensim-users >>>> >>>> >>>> _______________________________________________ >>>> Opensim-users mailing list >>>> [email protected] >>>> 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 >>> [email protected] >>> >>> >>> >>> _______________________________________________ >>> Opensim-users mailing list >>> [email protected] >>> https://lists.berlios.de/mailman/listinfo/opensim-users >> >> >> _______________________________________________ >> Opensim-users mailing list >> [email protected] >> 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 > [email protected] > > > _______________________________________________ > Opensim-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
