SARK Debian Accidental Lockouts

From sailpbx
Revision as of 19:53, 29 April 2017 by Adminwiki (talk | contribs) (Windows procedure)
Jump to: navigation, search

back to SARK v4.0.0 contents

SARK V5.0.0 Debian accidental lockouts and how to deal with them

SARK V5 has both strong security and a powerful on-board firewall. It is possible to lock yourself out of the system in a couple of ways, either because you have mis-set the firewall or because you have lost or forgotten the admin password. Here is a guide to unlocking the system if you should find yourself in one of these situations.

Firewall Lockouts

You've set the firewall in such a way that it will no longer allow you access on HTTPS and/or SSH

HTTPS lockout (SSH still available)

This is the easiest lockout to repair. SSH to the box using native ssh (Linux), PuTTY or WinSCP if you prefer (Windows). You will find the SARK shorewall firewall rules in the file:- /etc/shorewall/sark_rules. The example below is the correct default rule-set.


cat /etc/shorewall/sark_rules 

ACCEPT net:$LAN $FW tcp 5060 - - # TCP SIP
ACCEPT net:$LAN $FW tcp 5061 - - # TCP SIP
ACCEPT net:$LAN $FW tcp 80 - - # HTTP
ACCEPT net:$LAN $FW tcp 443 - - # HTTPS
ACCEPT net:$LAN $FW tcp 22 - - # SSH
ACCEPT net:$LAN $FW udp 123 - - # NTP
ACCEPT net:$LAN $FW tcp 389 - - # LDAP
ACCEPT net:$LAN $FW udp 389 - - # LDAP
ACCEPT net:$LAN $FW udp 4569 - -  # IAX2
ACCEPT net:$LAN $FW udp 5060 - - # SIP
ACCEPT net:$LAN $FW udp 10000:20000 - - # RTP

Add back or correct the rules and either reboot the box or, if you are using ssh or PuTTY, simply restart the firewall with the following command and you should be back on the road.

shorewall restart

HTTPS AND SSH lockout

This is a more difficult scenario because you cannot get to the box at all. You cannot perform this fix remotely because the drive is going to have to come out and be attached to another computer.

If the SARK is a SARK200 box, you can simply remove the SD Card and slot it into a USB card reader. For conventional drives you will probably need to use a USB SATA caddy of some description. The procedure for accessing the data is different depending upon whether you have attached your SARK drive to a Linux machine or a Windows machine.

Linux procedure

Depending upon your Linux distro you may find the external drive caddy will automount on your box, in which case you can just modify the firewall rules without further ado. If it doesn't automount, then you can use dmesg to see which device linux has allocated to it and mount the device manually.

dmesg
.
.
.
[18728740.570834] usb-storage 2-1.5:1.0: USB Mass Storage device detected
[18728740.571011] scsi host39: usb-storage 2-1.5:1.0
[18728741.568149] scsi 39:0:0:0: Direct-Access     Generic  STORAGE DEVICE   0819 PQ: 0 ANSI: 6
[18728741.568481] sd 39:0:0:0: Attached scsi generic sg3 type 0
[18728741.711336] sd 39:0:0:0: [sde] 8011776 512-byte logical blocks: (4.10 GB/3.82 GiB)
[18728741.712470] sd 39:0:0:0: [sde] Write Protect is off
[18728741.712472] sd 39:0:0:0: [sde] Mode Sense: 23 00 00 00
[18728741.713592] sd 39:0:0:0: [sde] Write cache: disabled, read cache: enabled, doesn't support DPO or FUA
[18728741.719012]  sde: sde1 sde2
[18728741.722769] sd 39:0:0:0: [sde] Attached SCSI removable disk
[18728742.010920] usb 2-1.5: reset high-speed USB device number 53 using ehci-pci

In the example above, we can see that Linux has allocate /dev/sde to the attached drive. We want the second partition (the rootfs) so we will mount sde2.

mount /dev/sde2 /media/image
ls /media/image/
bin   dev  home  lost+found  mnt  proc	run   selinux  sys	 tmp  var
boot  etc  lib	 media	     opt  root	sbin  srv      tftpboot  usr

...and now we can go ahead and make the changes to the firewall as we did in the first example. Once saved, reinstall the drive into the SARK box and reboot it.

Windows procedure

We used Windows 10 to test this procedure but it's likely any modern Windows release should be OK. Now, out of the box, Windows cannot read a Linux filesystem. However, there is a free tool for Windows which does it pretty well. It is called ext2fsd. You can download it from http://www.ext2fsd.com/?page_id=2. We make no representation for this tool and cannot guarantee its fitness for purpose except insofar as to say it worked for us.

Download ext2fsd and install it. Plug up your external drive and start ex2fsd. You will see a screen like this


Ex2hd shot1.png




Press Apply and ex2fsd will automatically map the linux partitions to your drives and allow you to navigate the Linux system


Ex2hd shot3.png




Now you can open the firewall rules file and make your changes. You may find that notepad does not open the file properly and you need to use wordpad or some other text editor.

Password Lockouts

Password lockouts require a different procedure but it is broadly similar to the 'complete firewall lockout' above. The disk has to be removed and mounted on another computer. SARK passwords are one-way encrypted, they cannot be recovered. However, the database can be reset to the factory default password of 'sarkadmin'. To do this we need to delete and re-create the admin user record in the database. SARK uses the popular SQLite3 database to store its metadata. Therefore, you will need a method of accessing SQLite3 databases.

Linux procedure

There is a good chance your Linux distro will already have SQLite3 installed. If it doesn't then you will need to install it using yum or apt-get, depending upon your flavour of Linux. Once that's done you can use the Linux CLI to manage the SQLite3 database.

Fire up SQLite3 with the SARK db as its target. Let's assume the SARK rootfs is mounted on /media/usbdrive on your Linux box.

sqlite3 /media/usbdrive/opt/sark/db/sark.db

Now, run the following commands at the SQLite3 prompt

DELETE FROM user WHERE pkey='admin';
INSERT INTO User(id,pkey,email,password,salt) values ('1','admin','admin@yourco.com','f9d00b85a314b0ea492159a475a8e9301c9ac579759043ba902f445eb629ad6e','4b78f15c5dbaf8ac');
.exit

That's it. You can unmount the SARK disk, re-install it and power up. When you login, use the default password of 'sarkadmin'. SARK's browser will force you to change the password in the normal way and you will be back on the road.

Windows procedure

The Windows procedure is exactly the same as the Linux procedure but you will need both ex2fsd (see above) and an SQLite3 GUI. There are several available but the one we used for this guide is called 'DB browser for SQLite' and you can get it here http://sqlitebrowser.org/. It is open source and free. Again, we make no representation for it other than to say it works for us.

Connect your SARK drive to the Windows box and start ex2fsd. Now start the SQLite browser and use the file tab to open the SARK DB which will be at \opt\sark\db\sark on the SARK rootfs drive. Select the SQL tab and enter the SQL below (see screenshot)

DELETE FROM user WHERE pkey='admin';
INSERT INTO User(id,pkey,email,password,salt) values ('1','admin','admin@yourco.com','f9d00b85a314b0ea492159a475a8e9301c9ac579759043ba902f445eb629ad6e','4b78f15c5dbaf8ac');


Sqlite shot1.png



Now, click the 'Play" button to execute the SQL. Save the file and you're done. You can re-install the media into the SARK box and power it up. When you login, use the default password of 'sarkadmin'. SARK's browser will force you to change the password in the normal way and you will be back on the road.