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
