NOTE: most of what is on this page has not been updated in 7 years or more. Some hasn't changed (ufw advice, mysql); most has.
Notes for me to refer back to when rebuilding or transferring my grid between operating systems.
Mysql notes:
Backup:
mysqldump -u (username) -p (database name) > (file)
Restore:
mysql -u (username) -p (database name) < (file)
username = database username (see opensim configuration file for this)
password = database user password (ditto)
database name = name of the database (ditto)
Using windows or OSX sql file on Linux:
The Linux file-system is case sensitive (meaning god.txt and God.txt are two different filenames), OSX and Windows are case insensitive (meaning god.txt and God.txt are the same filename). This can cause problems importing an sql database.
To work around this, add the following to the [mysqld] section of /etc/mysql/my.cnf:
lower_case_table_names=1
Mysql and CentOS 7:
Centos 7 doesn't ship with mysql, and I'm not clear if opensim plays nice with mariadb or not -I prefer not to take chances! A quick search revealed the following method for installing mysql:
install the mysql repo:
sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
then update your repos
sudo yum check-update
install mysql:
sudo yum install mysql-server
Mysql fuckery!:
It's easy to change various timestamps in a database using GUIs such as WorkBench or (a new favorite) DBeaver (https://dbeaver.io/download/). The site https://www.epochconverter.com/ is handy for creating UUIDs to make fun rez dates and land claimed dates with.
Firewall notes:
Opening up UFW
These are the commands I used to open up the ports needed by opensim on Ubuntu 14.04. I don't know if this will work on later editions; it didn't seem to work with Debian Jessie but more testing is needed.
root@vps:~# ufw allow proto tcp from any to any port 8000:8010,9000:9200
Rule added
Rule added (v6)
root@vps:~# ufw allow proto udp from any to any port 8000:8010,9000:9200
Rule added
Rule added (v6)
Opening up FirewallD (centos 7)
[root@server han]# firewall-cmd --zone=public --permanent --add-port=8000-8010/udp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=22/tcp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=8000-8010/tcp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=9000-9200/udp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=9000-9200/tcp
success
See also this link on Firewalld
Useful aliases (put in .bashrc):
alias nsh='cd ~/os/admeja/nsh/bin/;mono OpenSim.exe'
alias rob='cd ~/os/admeja/rob/bin/;mono Robust.exe -inifile=Robust.HG.ini'
alias sandbox='cd ~/os/admeja/sandbox/bin/;mono OpenSim.exe'
Loopback adapter:
To create a loopback adapter in linux:
As root, add "lo:10" to the list of interfaces in /etc/network/interfaces and then add an entry that looks similar to the following:
iface lo:10 inet static
address 192.168.10.1
netmask 255.255.255.0
network 192.168.10.0
Notes for adding a loopback adapter in OSX:
The loopback adapter is always up.
ifconfig lo0 alias 172.16.123.1 will add an alias IP 172.16.123.1 to the loopback adapter
ifconfig lo0 -alias 172.16.123.1 will remove it
(note: don't use 172.16.123.1; that was just the example used on the page I found those instructions on)
Enabling the loopback adapter in Windows:
Here are the instructions for enabling the loopback adapter in XP:
http://www.windowsnetworking.com/articles-tutorials/windows-xp/Install-Microsoft-Loopback-adapter-Windows-XP.html
Here are the instructions for enabling the loopback adapter in Windows 7:
http://www.windowsreference.com/windows-7/how-to-install-a-loopback-adapter-in-windows-7/
Here are the instructions for enabling the loopback adapter in Windows 8 (it's been renamed):
http://support.microsoft.com/kb/2777200
Enabling AMD/ATI graphics in Linux:
Screw that -seriously. Just use Ubuntu (or Lubuntu, or Xbuntu, or whatever) and enable the restricted video driver.
Getting headphones to work in an 2011 21.5" imac:
I use the solution posted by benzodiaz on the Ubuntu forums (link: http://ubuntuforums.org/showthread.php?t=2007829&p=12058171#post12058171 )
1. In a terminal, paste the line in the quotations, "sudo wget -O run.py http://www.alsa-project.org/hda-analyzer.py"
2. Then paste this, "sudo python run.py", and it will open what's called HDA Analyzer.
3. Click codec-0 on the left hand side, under Nodes. Where it says GPIO, uncheck out-dir, enable, and data for the row [1], and check them for row [2]. If you had your headphones on when you checked data [2], you should get output.
4. At the bottom, click Exp., save as, and save it in your home directory.
5. Open gedit and type, "gksu python /path/to/previously/saved/file" and save it in your home directory. Go to the gedit file you just made, right click and go to properties, click the permissions tab, and check make this file executable.
7. Whenever your headphones don't work and they should, open a terminal, Ctrl+Alt+t, and type the name of the gedit file you created. This reloads the settings you made in hda analyzer.
Replacement command for the ia32-libs in Ubuntu 13.10
As of 13.10, Ubuntu no longer ships w/ a metapackage of 32-bit libraries, forcing you to install them manually. The way you do that is to type:
sudo apt-get install bluez-alsa:i386 gstreamer0.10-plugins-base:i386 gstreamer0.10-plugins-good:i386 gtk2-engines:i386 gtk2-engines-murrine:i386 gtk2-engines-oxygen:i386 gtk2-engines-pixbuf:i386 gvfs:i386 ibus-gtk:i386 libacl1:i386 libaio1:i386 libao4:i386 libasound2:i386 libasound2-plugins:i386 libasyncns0:i386 libattr1:i386 libaudio2:i386 libcanberra-gtk-module:i386 libcap2:i386 libcapi20-3:i386 libcups2:i386 libcupsimage2:i386 libcurl3:i386 libdbus-glib-1-2:i386 libesd0:i386 libfontconfig1:i386 libfreetype6:i386 libgail-common:i386 libgconf-2-4:i386 libgdbm3:i386 libgettextpo0:i386 libglapi-mesa:i386 libglu1-mesa:i386 libgphoto2-6:i386 libgphoto2-port10:i386 libgtk2.0-0:i386 libmpg123-0:i386 libncursesw5:i386 libnspr4:i386 libnss3:i386 libodbc1:i386 libopenal1:i386 libpulse-mainloop-glib0:i386 libpulsedsp:i386 libqt4-dbus:i386 libqt4-network:i386 libqt4-opengl:i386 libqt4-qt3support:i386 libqt4-script:i386 libqt4-scripttools:i386 libqt4-sql:i386 libqt4-svg:i386 libqt4-test:i386 libqt4-xml:i386 libqt4-xmlpatterns:i386 libqtcore4:i386 libqtgui4:i386 libqtwebkit4:i386 librsvg2-common:i386 libsane:i386 libsdl-image1.2:i386 libsdl-mixer1.2:i386 libsdl-net1.2:i386 libsdl-ttf2.0-0:i386 libsdl1.2debian:i386 libsqlite3-0:i386 libssl0.9.8:i386 libssl1.0.0:i386 libstdc++5:i386 libstdc++6:i386 libxaw7:i386 libxml2:i386 libxp6:i386 libxslt1.1:i386 libxss1:i386 libxtst6:i386 odbcinst1debian2:i386 xaw3dg:i386 libgl1-mesa-dri:i386 libgl1-mesa-glx:i386 libpam-winbind:i386
Tip found on The Dark Mod forums: http://forums.thedarkmod.com/topic/15289-ubuntu-1310-64-bit-and-32-bit-libs/page__p__326036#entry326036
Essential Applications to run OpenSim on Linux:
apt-get install nvi screen mono-complete mysql-server
Essential Applications to run OpenSim on Linux:
apt-get install nvi screen mono-complete mysql-server
Using Mono 3.2.8? Some notes and suggestions from G+
((add the following to $HOME/.profile))
#I'd guess you're running OpenSim on some flavor of Linux using a newer version of Mono. You should probably set the nursery size before running Mono:
# If your Mono is new enough to be concerned with the nursery size, you might also benefit from adding the server flag as well. I.e.:
# --Shaun Emerald's comment on G+
MONO_GC_PARAMS=nursery-size=64m
export MONO_GC_PARAMS
BUILDING Singularity in Linux Mint:
You can mostly follow the instructions on their "building for linux" knowledge base page: http://www.singularityviewer.org/kb/build-linux
As of July 29, 2014, it's best to use Aleric Inglewood's repo. It can be found here: https://github.com/AlericInglewood/SingularityViewer
In addition, I had to pull in some additional software, here's a list pulled from my bash history (ignore the numbers at the beginning of each line -I'm too lazy to pull them out):
620 ln -s $PWD/fmodapi44439linux $HOME/fmodapi
627 sudo apt-get install cmake
629 sudo apt-get install libc6-dev libstdc++6 libx11-dev libxrender-dev libgl1-mesa-dev
630 sudo apt-get install gcc g++
642 sudo apt-get install libxinerama-dev
646 sudo apt-get install libmesa-dev
648 sudo apt-get install libglu1-mesa-dev
652 sudo apt-get install libxml2-dev
654 sudo apt-get install libglew-dev
656 sudo apt-get install libglu1-mesa-dev zlib1g-dev libssl-dev libogg-dev libpng12-dev libdbus-glib-1-dev libgtk2.0-dev
657 sudo apt-get install libopenal-dev libvorbis-dev libalut-dev libapr1-dev libaprutil1-dev libboost-dev libc-ares-dev libxmlrpc-epi-dev libopenjpeg-dev libjpeg62-dev libgtk2.0-dev libsdl1.2-dev libgstreamer0.10-dev libgstreamer-plugins-base0.10-dev google-mock
For mild curiosity's sake, here's the result of "time make -j5":
real 31m21.479s
user 98m0.412s
sys 3m51.476s
(on a quad core i5 2.5mhz processor)
Mysql notes:
Backup:
mysqldump -u (username) -p (database name) > (file)
Restore:
mysql -u (username) -p (database name) < (file)
username = database username (see opensim configuration file for this)
password = database user password (ditto)
database name = name of the database (ditto)
Using windows or OSX sql file on Linux:
The Linux file-system is case sensitive (meaning god.txt and God.txt are two different filenames), OSX and Windows are case insensitive (meaning god.txt and God.txt are the same filename). This can cause problems importing an sql database.
To work around this, add the following to the [mysqld] section of /etc/mysql/my.cnf:
lower_case_table_names=1
Mysql and CentOS 7:
Centos 7 doesn't ship with mysql, and I'm not clear if opensim plays nice with mariadb or not -I prefer not to take chances! A quick search revealed the following method for installing mysql:
install the mysql repo:
sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
then update your repos
sudo yum check-update
install mysql:
sudo yum install mysql-server
Mysql fuckery!:
It's easy to change various timestamps in a database using GUIs such as WorkBench or (a new favorite) DBeaver (https://dbeaver.io/download/). The site https://www.epochconverter.com/ is handy for creating UUIDs to make fun rez dates and land claimed dates with.
Firewall notes:
Opening up UFW
These are the commands I used to open up the ports needed by opensim on Ubuntu 14.04. I don't know if this will work on later editions; it didn't seem to work with Debian Jessie but more testing is needed.
root@vps:~# ufw allow proto tcp from any to any port 8000:8010,9000:9200
Rule added
Rule added (v6)
root@vps:~# ufw allow proto udp from any to any port 8000:8010,9000:9200
Rule added
Rule added (v6)
Opening up FirewallD (centos 7)
[root@server han]# firewall-cmd --zone=public --permanent --add-port=8000-8010/udp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=22/tcp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=8000-8010/tcp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=9000-9200/udp
success
[root@server han]# firewall-cmd --zone=public --permanent --add-port=9000-9200/tcp
success
See also this link on Firewalld
Useful aliases (put in .bashrc):
alias nsh='cd ~/os/admeja/nsh/bin/;mono OpenSim.exe'
alias rob='cd ~/os/admeja/rob/bin/;mono Robust.exe -inifile=Robust.HG.ini'
alias sandbox='cd ~/os/admeja/sandbox/bin/;mono OpenSim.exe'
Loopback adapter:
To create a loopback adapter in linux:
As root, add "lo:10" to the list of interfaces in /etc/network/interfaces and then add an entry that looks similar to the following:
iface lo:10 inet static
address 192.168.10.1
netmask 255.255.255.0
network 192.168.10.0
Notes for adding a loopback adapter in OSX:
The loopback adapter is always up.
ifconfig lo0 alias 172.16.123.1 will add an alias IP 172.16.123.1 to the loopback adapter
ifconfig lo0 -alias 172.16.123.1 will remove it
(note: don't use 172.16.123.1; that was just the example used on the page I found those instructions on)
Enabling the loopback adapter in Windows:
Here are the instructions for enabling the loopback adapter in XP:
http://www.windowsnetworking.com/articles-tutorials/windows-xp/Install-Microsoft-Loopback-adapter-Windows-XP.html
Here are the instructions for enabling the loopback adapter in Windows 7:
http://www.windowsreference.com/windows-7/how-to-install-a-loopback-adapter-in-windows-7/
Here are the instructions for enabling the loopback adapter in Windows 8 (it's been renamed):
http://support.microsoft.com/kb/2777200
Enabling AMD/ATI graphics in Linux:
Screw that -seriously. Just use Ubuntu (or Lubuntu, or Xbuntu, or whatever) and enable the restricted video driver.
Getting headphones to work in an 2011 21.5" imac:
I use the solution posted by benzodiaz on the Ubuntu forums (link: http://ubuntuforums.org/showthread.php?t=2007829&p=12058171#post12058171 )
1. In a terminal, paste the line in the quotations, "sudo wget -O run.py http://www.alsa-project.org/hda-analyzer.py"
2. Then paste this, "sudo python run.py", and it will open what's called HDA Analyzer.
3. Click codec-0 on the left hand side, under Nodes. Where it says GPIO, uncheck out-dir, enable, and data for the row [1], and check them for row [2]. If you had your headphones on when you checked data [2], you should get output.
4. At the bottom, click Exp., save as, and save it in your home directory.
5. Open gedit and type, "gksu python /path/to/previously/saved/file" and save it in your home directory. Go to the gedit file you just made, right click and go to properties, click the permissions tab, and check make this file executable.
7. Whenever your headphones don't work and they should, open a terminal, Ctrl+Alt+t, and type the name of the gedit file you created. This reloads the settings you made in hda analyzer.
Replacement command for the ia32-libs in Ubuntu 13.10
As of 13.10, Ubuntu no longer ships w/ a metapackage of 32-bit libraries, forcing you to install them manually. The way you do that is to type:
sudo apt-get install bluez-alsa:i386 gstreamer0.10-plugins-base:i386 gstreamer0.10-plugins-good:i386 gtk2-engines:i386 gtk2-engines-murrine:i386 gtk2-engines-oxygen:i386 gtk2-engines-pixbuf:i386 gvfs:i386 ibus-gtk:i386 libacl1:i386 libaio1:i386 libao4:i386 libasound2:i386 libasound2-plugins:i386 libasyncns0:i386 libattr1:i386 libaudio2:i386 libcanberra-gtk-module:i386 libcap2:i386 libcapi20-3:i386 libcups2:i386 libcupsimage2:i386 libcurl3:i386 libdbus-glib-1-2:i386 libesd0:i386 libfontconfig1:i386 libfreetype6:i386 libgail-common:i386 libgconf-2-4:i386 libgdbm3:i386 libgettextpo0:i386 libglapi-mesa:i386 libglu1-mesa:i386 libgphoto2-6:i386 libgphoto2-port10:i386 libgtk2.0-0:i386 libmpg123-0:i386 libncursesw5:i386 libnspr4:i386 libnss3:i386 libodbc1:i386 libopenal1:i386 libpulse-mainloop-glib0:i386 libpulsedsp:i386 libqt4-dbus:i386 libqt4-network:i386 libqt4-opengl:i386 libqt4-qt3support:i386 libqt4-script:i386 libqt4-scripttools:i386 libqt4-sql:i386 libqt4-svg:i386 libqt4-test:i386 libqt4-xml:i386 libqt4-xmlpatterns:i386 libqtcore4:i386 libqtgui4:i386 libqtwebkit4:i386 librsvg2-common:i386 libsane:i386 libsdl-image1.2:i386 libsdl-mixer1.2:i386 libsdl-net1.2:i386 libsdl-ttf2.0-0:i386 libsdl1.2debian:i386 libsqlite3-0:i386 libssl0.9.8:i386 libssl1.0.0:i386 libstdc++5:i386 libstdc++6:i386 libxaw7:i386 libxml2:i386 libxp6:i386 libxslt1.1:i386 libxss1:i386 libxtst6:i386 odbcinst1debian2:i386 xaw3dg:i386 libgl1-mesa-dri:i386 libgl1-mesa-glx:i386 libpam-winbind:i386
Tip found on The Dark Mod forums: http://forums.thedarkmod.com/topic/15289-ubuntu-1310-64-bit-and-32-bit-libs/page__p__326036#entry326036
Essential Applications to run OpenSim on Linux:
apt-get install nvi screen mono-complete mysql-server
Essential Applications to run OpenSim on Linux:
apt-get install nvi screen mono-complete mysql-server
Using Mono 3.2.8? Some notes and suggestions from G+
((add the following to $HOME/.profile))
#I'd guess you're running OpenSim on some flavor of Linux using a newer version of Mono. You should probably set the nursery size before running Mono:
# If your Mono is new enough to be concerned with the nursery size, you might also benefit from adding the server flag as well. I.e.:
# --Shaun Emerald's comment on G+
MONO_GC_PARAMS=nursery-size=64m
export MONO_GC_PARAMS
BUILDING Singularity in Linux Mint:
You can mostly follow the instructions on their "building for linux" knowledge base page: http://www.singularityviewer.org/kb/build-linux
As of July 29, 2014, it's best to use Aleric Inglewood's repo. It can be found here: https://github.com/AlericInglewood/SingularityViewer
In addition, I had to pull in some additional software, here's a list pulled from my bash history (ignore the numbers at the beginning of each line -I'm too lazy to pull them out):
620 ln -s $PWD/fmodapi44439linux $HOME/fmodapi
627 sudo apt-get install cmake
629 sudo apt-get install libc6-dev libstdc++6 libx11-dev libxrender-dev libgl1-mesa-dev
630 sudo apt-get install gcc g++
642 sudo apt-get install libxinerama-dev
646 sudo apt-get install libmesa-dev
648 sudo apt-get install libglu1-mesa-dev
652 sudo apt-get install libxml2-dev
654 sudo apt-get install libglew-dev
656 sudo apt-get install libglu1-mesa-dev zlib1g-dev libssl-dev libogg-dev libpng12-dev libdbus-glib-1-dev libgtk2.0-dev
657 sudo apt-get install libopenal-dev libvorbis-dev libalut-dev libapr1-dev libaprutil1-dev libboost-dev libc-ares-dev libxmlrpc-epi-dev libopenjpeg-dev libjpeg62-dev libgtk2.0-dev libsdl1.2-dev libgstreamer0.10-dev libgstreamer-plugins-base0.10-dev google-mock
For mild curiosity's sake, here's the result of "time make -j5":
real 31m21.479s
user 98m0.412s
sys 3m51.476s
(on a quad core i5 2.5mhz processor)