Banning Foreign Users in Hypergrid
From OpenSimulator
m (Removed 'Template:' prefix from template includings and/or changed external-link into internal-link) |
|||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
| − | {{ | + | {{Quicklinks}} |
=== Banning Foreign Users === | === Banning Foreign Users === | ||
Revision as of 05:55, 10 June 2011
 |
Languages: |
|
Banning Foreign Users
Even though the current viewers are incapable of dealing with foreign users, it is possible to ban specific foreign users from your estates. For now, you have to do it on the backend, i.e. directly editing the database and reviewing the log. Not easy for the faint of heart, but any sys admin should be able to do this with their eyes shut. What follows are instructions for adding a foreign user to the estate's ban list.
The first thing you need to do is to find out the UUID and IP address of the user you want to ban. For that you need to look at OpenSim.log. Search for log messages like this:
2009-01-23 03:45:11,995 INFO - OpenSim.Region.Communications.Hypergrid.HGGridServicesGridMode [HGrid]: Incoming HGrid Agent Annoying.Person http://problematic.domain.org:9002 2009-01-23 03:45:11,995 DEBUG - OpenSim.Region.Environment.Scenes.Scene [CONNECTION BEGIN]: Region Gateway 3000 told of incoming client Annoying.Person http://problematic.domain.org:9002 c3c9ecbf-bfb3-43eb-8dce-140afad7995f (circuit code 1896255323)
In this case, the information you need is: UUID = c3c9ecbf-bfb3-43eb-8dce-140afad7995f and IPAddress = problematic.domain.org
Next, let's add this foreign user to the ban list. Note that the estate information and ban lists are kept at the region server, not in the UGAIM. If you are using local storage for your regions, this information is stored in bin/OpenSim.db. So, open that DB with whatever tool you use to access your DBs. The instructions here assume a local sqlite database; if you're using MySql or other DB technologies for the regions' storage, the instructions are almost identical, but may need adjustments.
SqlLite usually comes with a common Linux installation. In Linux, just type:
$ sqlite3 OpenSim.db
In Windows, you need to get it from here. Once installed, run it on your OpenSim.db, like this, for example (on a command shell):
$ C:/Opt/SQLite3/sqlite3.exe OpenSim.db
Once you are connected to the database, you can explore as much as you want. What follows are the concrete interactions you need for adding that foreign user into an estate ban list. Change the data for your situation.
[opensim@ucigrid04 bin]$ sqlite3 OpenSim.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .tables
estate_groups estate_users migrations regionban
estate_managers estateban primitems regionsettings
estate_map land prims terrain
estate_settings landaccesslist primshapes
sqlite> .schema estateban
CREATE TABLE estateban (
EstateID int(10) NOT NULL,
bannedUUID varchar(36) NOT NULL,
bannedIp varchar(16) NOT NULL,
bannedIpHostMask varchar(16) NOT NULL,
bannedNameMask varchar(64) default NULL
);
CREATE INDEX estate_ban_estate_id on estateban(EstateID);
sqlite> select EstateID, EstateName from estate_settings;
100|My Estate
101|My Estate
102|My Estate
103|My Estate
sqlite> insert into estateban values (100, 'c3c9ecbf-bfb3-43eb-8dce-140afad7995f', 'problematic.domain.org', ' ', ' ');
sqlite> insert into estateban values (101, 'c3c9ecbf-bfb3-43eb-8dce-140afad7995f', 'problematic.domain.org', ' ', ' ');
sqlite> insert into estateban values (102, 'c3c9ecbf-bfb3-43eb-8dce-140afad7995f', 'problematic.domain.org', ' ', ' ');
sqlite> insert into estateban values (103, 'c3c9ecbf-bfb3-43eb-8dce-140afad7995f', 'problematic.domain.org', ' ', ' ');
sqlite> select * from estateban;
100|c3c9ecbf-bfb3-43eb-8dce-140afad7995f|problematic.domain.org||
101|c3c9ecbf-bfb3-43eb-8dce-140afad7995f|problematic.domain.org||
102|c3c9ecbf-bfb3-43eb-8dce-140afad7995f|problematic.domain.org||
103|c3c9ecbf-bfb3-43eb-8dce-140afad7995f|problematic.domain.org||
sqlite> .quit
Once this data is entered you need to restart OpenSim, so that it gets loaded.
