<div dir="ltr">Pardon my ignorance here - do you mean "bind address" - 192.168.x.xxx<div><br></div><div style>The internal IP of the server.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Apr 3, 2013 at 12:02 AM, Todd Davis <span dir="ltr"><<a href="mailto:opensiminfo@virtualrealmsgrid.com" target="_blank">opensiminfo@virtualrealmsgrid.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div>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. </div>
<div><br></div><div>Todd</div><div><br><br>Sent from my iPhone</div><div><div class="h5"><div><br>On 2013-04-02, at 2:18 AM, Paul Rayner <<a href="mailto:prayner.basil@gmail.com" target="_blank">prayner.basil@gmail.com</a>> wrote:<br>
<br></div><blockquote type="cite"><div><div dir="ltr">Connect just to the database??? Yes<div>Just create another database (for a PHP exercise I'm working on) and that connected OK using the instructions from the OpenSim wiki.</div>
<div><br></div>
<div>Paul</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Apr 2, 2013 at 3:59 PM, Luisillo Contepomi <span dir="ltr"><<a href="mailto:luisillocontepomi@gmail.com" target="_blank">luisillocontepomi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Can you connect successfully from a mysql shell, from the same machine, with the username and password in the database server?<br>
</div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/2 Paul Rayner <span dir="ltr"><<a href="mailto:prayner.basil@gmail.com" target="_blank">prayner.basil@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thomas - I also tried localhost. Same error.<div>Luisillo - I used the tutorial @ <a href="http://opensimulator.org/wiki/Database_Settings" target="_blank">http://opensimulator.org/wiki/Database_Settings</a> and used those same settings.</div>
<div><br></div><div>The database has been created - called opensim</div><div>User created for that database - opensimuser. Have tried both opensimuser@localhost and <a href="mailto:opensimuser@127.0.0.1" target="_blank">opensimuser@127.0.0.1</a>.</div>
<div>Using root in MYSQL CLI - did the <span style="line-height:1.1em;background-color:rgb(249,249,249)">grant all on opensim.* to 'opensimuser'@'localhost'; and also </span><span style="line-height:14.296875px;background-color:rgb(249,249,249)">'<a href="mailto:opensimuser%27@127.0.0.1" target="_blank">opensimuser'@127.0.0.1</a>;</span></div>
<div><span style="line-height:14.296875px;background-color:rgb(249,249,249)"><br></span></div><div><span style="line-height:14.296875px;background-color:rgb(249,249,249)">Commented SQLite out in the StandAloneCommon.ini. Uncommented 2 lines in MYSQL area, and changed string to suit my settings.</span></div>
<div><span style="line-height:14.296875px;background-color:rgb(249,249,249)"><br></span></div><div><span style="line-height:14.296875px;background-color:rgb(249,249,249)">The OpenSim server and MYSQL server are both on the same machine (Ubuntu 11.10).</span></div>
<div><span style="line-height:14.296875px;background-color:rgb(249,249,249)"><br></span></div><div><span style="line-height:14.296875px;background-color:rgb(249,249,249)">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.</span></div>
<div><span style="line-height:14.296875px;background-color:rgb(249,249,249)"><br></span></div><div><span style="line-height:14.296875px;background-color:rgb(249,249,249)">Paul</span></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Apr 2, 2013 at 2:22 PM, Luisillo Contepomi <span dir="ltr"><<a href="mailto:luisillocontepomi@gmail.com" target="_blank">luisillocontepomi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>The error is "Connection refused".<br>May be your server mysql have not user or database configured before you try to use.<br>
Your configuration: Data Source=127.0.0.1;Database=opensim;User ID=opensimuser;Password=xxxxx;<br>
<br></div>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<br></div>Has you create before the database named "opensim", user named "opensimuser" with all permisions for this database in your mysql server?<br>
<br></div>If not... doit and then start your region<br></div>Regards,<br>Luisillo<br><div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/2 Paul Rayner <span dir="ltr"><<a href="mailto:prayner.basil@gmail.com" target="_blank">prayner.basil@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Hi<div><br></div><div>my server is Ubuntu 11.10, and it runs an out of the box LAMP setup.</div>
<div><br>
</div><div>I downloaded and installed OpenSim 0.7.5, and it ran out of the box using SQLite. When I "followed" the tutorial at <a href="http://opensimulator.org/wiki/Database_Settings" target="_blank">http://opensimulator.org/wiki/Database_Settings</a> to switch to a MYSQL version of opensim, it won't start.</div>
<div>The pastebin of the error is <a href="http://pastebin.com/iK9bAPkX" target="_blank">pastebin.com/iK9bAPkX</a>.</div><div><br></div><div>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.</div>
<div><br></div><div>While I have few days off, I'd love to get it running in time for school again soon.</div><div><br></div><div>I'd appreciate any advice</div><span><font color="#888888"><div><br>
</div><div>Paul<br clear="all"><div><br></div>
-- <br>
<div dir="ltr"><div><span style="color:rgb(136,136,136)">To subscribe to the ITS mailing list, go to </span><a href="http://lists.otn.edu.au/mailman/listinfo/qsite-its" style="color:rgb(17,85,204)" target="_blank">http://lists.otn.edu.au/mailman/listinfo/qsite-its</a><span style="color:rgb(136,136,136)">.</span><span style="line-height:19px;font-size:13px;font-family:sans-serif"><br>
</span></div><div><span style="color:rgb(136,136,136)"><br></span></div><div><span style="color:rgb(136,136,136)">To email the list, use</span></div><div><span style="white-space:nowrap"><a href="mailto:qsite-its@lists.otn.edu.au" target="_blank">qsite-its@lists.otn.edu.au</a></span> <span style="color:rgb(136,136,136)"><br>
</span></div><div><span style="line-height:19px;font-size:13px;font-family:sans-serif"><br></span></div><div><br></div></div>
</div></font></span></div>
<br></div></div><div>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br></div></blockquote></div><br></div>
<br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><span><font color="#888888"><br></font></span></blockquote></div>
<span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
<div><span style="color:rgb(136,136,136)">To subscribe to the ITS mailing list, go to </span><a href="http://lists.otn.edu.au/mailman/listinfo/qsite-its" style="color:rgb(17,85,204)" target="_blank">http://lists.otn.edu.au/mailman/listinfo/qsite-its</a><span style="color:rgb(136,136,136)">.</span><span style="line-height:19px;font-size:13px;font-family:sans-serif"><br>
</span></div><div><span style="color:rgb(136,136,136)"><br></span></div><div><span style="color:rgb(136,136,136)">To email the list, use</span></div><div><span style="white-space:nowrap"><a href="mailto:qsite-its@lists.otn.edu.au" target="_blank">qsite-its@lists.otn.edu.au</a></span> <span style="color:rgb(136,136,136)"><br>
</span></div><div><span style="line-height:19px;font-size:13px;font-family:sans-serif"><br></span></div><div><br></div></div>
</font></span></div>
<br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
<div><span style="color:rgb(136,136,136)">To subscribe to the ITS mailing list, go to </span><a href="http://lists.otn.edu.au/mailman/listinfo/qsite-its" style="color:rgb(17,85,204)" target="_blank">http://lists.otn.edu.au/mailman/listinfo/qsite-its</a><span style="color:rgb(136,136,136)">.</span><span style="line-height:19px;font-size:13px;font-family:sans-serif"><br>
</span></div><div><span style="color:rgb(136,136,136)"><br></span></div><div><span style="color:rgb(136,136,136)">To email the list, use</span></div><div><span style="white-space:nowrap"><a href="mailto:qsite-its@lists.otn.edu.au" target="_blank">qsite-its@lists.otn.edu.au</a></span> <span style="color:rgb(136,136,136)"><br>
</span></div><div><span style="line-height:19px;font-size:13px;font-family:sans-serif"><br></span></div><div><br></div></div>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Opensim-users mailing list</span><br><span><a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a></span><br>
<span><a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a></span></div></blockquote></div></div></div><br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
<div><span style="color:rgb(136,136,136)">To subscribe to the ITS mailing list, go to </span><a href="http://lists.otn.edu.au/mailman/listinfo/qsite-its" style="color:rgb(17,85,204)" target="_blank">http://lists.otn.edu.au/mailman/listinfo/qsite-its</a><span style="color:rgb(136,136,136)">.</span><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;line-height:19px"><br>
</span></div><div><span style="color:rgb(136,136,136)"><br></span></div><div><span style="color:rgb(136,136,136)">To email the list, use</span></div><div><span style="white-space:nowrap"><a href="mailto:qsite-its@lists.otn.edu.au" target="_blank">qsite-its@lists.otn.edu.au</a></span> <span style="color:rgb(136,136,136)"><br>
</span></div><div><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;line-height:19px"><br></span></div><div><br></div></div>
</div>