Ivan Linux Server

This is a 32-bit machine!

$ uname -a
Linux ivan 3.16.0-6-686-pae #1 SMP Debian 3.16.57-2 (2018-07-14) i686 GNU/Linux

Available only inside the local network at 192.168.0.10. This DNS'ed by the DSL router to “dancoIvan.” (Ivan stopped working, perhaps ivan.Home became taken externally.)

• Investigation - Troubleshooting

To install sudo (info: http://www.linuxhelp.net/guides/sudo/) apt-get install sudo Then, anyone in the “sudo” group can run sudo. Ran “usermod -a -G sudo dwheele” to grant sudo

To move mysql

 http://muhdzamri.blogspot.com/2011/01/moving-your-mysql-database-to-another.html

To install mysql

sudo apt-get update sudo apt-get dist-upgrade

sudo apt-get install mysql-server mysql-client It asked for a new root password, provided '–rootPW–'

Instructions recommend, but not needed: sudo mysqladmin -u root -h localhost password '–rootPW–' sudo mysqladmin -u root -h myhostname password '–rootPW–'

Ran this, which seemed to modify apache2 sudo apt-get install php5-mysql

You can now access your MySQL server like this:

mysql -u root -p

apt-get install samba

cd /etc/samba sudo smbpasswd -a dwheele

sudo apt-get install ssh

mysql -u root -p create database rempat_db

create user 'rempat'@'%' identified by 'pat2gist';

grant all on rempat_db.* to 'rempat'@'%';

If you can't create a user, try deleting old stuff like this:

  delete from mysql.user where user=foo;
  delete from mysql.db where user=foo

or

  flush privileges;

(at the mysql prompt)

Had to enable remote access, by modifying /etc/mysql/my.cnf, changing bind-address to 192.168.0.11

Installed Subversion on ivan (now DNSed to dancoivan). Did approximately these steps:

sudo mkdir /var/svn
sudo chgrp users /var/svn
sudo chmod 775 /var/svn
mkdir /var/svn/repos
svnadmin create /var/svn/repos

Then modify file at /var/svn/repos/conf/svnserve.conf

anon-access = none
auth-access = write
password-db = passwd

Then modify the file “passwd” in the same directory to have

mycuid = mycuidpassword

then run

svnserve -d

Installed subversion plugin into eclipse. The URL is

svn://dancoivan/var/svn/repos

Under that it makes a subdirectory with the same name as the project name, e.g., cantata2

3/10/2016 Reinstalled Linux

Over the past few days, bought a SSD, installed Linux Debian 8.3 on it, then have mounted directories from the one terabyte hard drive into the SSD space. Mostly working OK.

initdb is in /usr/lib/postgresql/9.4/bin

# su - postgres
$ initdb -D /var/postgresql/data

Success. You can now start the database server using:
 
   ./postgres -D /var/postgresql/data
or
   ./pg_ctl -D /var/postgresql/data -l logfile start
 

As postgres run psql

This server is set up to allow a DNS name from the public internet, to hit this server, even though its IP address changes regularly by the ISP.

Previously I had DynDNS.com services, but I discontinued them because they doubled their rates. I've moved to afraid.org

• Instructions/cron example: http://freedns.afraid.org/dynamic/index.php?action=script&method=example&data_id=18623878

I installed a wget line in the root crontab (I removed part of the password string).

4,9,14,19,24,29,34,39,44,49,54,59 * * * * sleep 7 ; wget -O - http://freedns.afraid.org/dynamic/update.php?VHlPcEBLMzFVMVVBQUN2c2hV== >> /tmp/freedns_quizkid_isageek_net.log 2>&1 &

[8/14/2021] Today I received an email from freedns.afraid.org telling me that I hadn't logged in for 5.5 months, so I logged in there. The cron described above is still active on server Ivan. However, both servers Ivan and Joshua are accessible on selected ports.