====== paramount.home.art-core.org ======

  * paramount is a 
    * HP ProLiant G7 MicroServer N54L
    * AMD Turion(tm) II Neo N54L Dual-Core Processor (2 cores)
    * running FreeNAS 11.2-U7
    * 8 GB RAM
    * 150W PSU
    * 2x 3 TB WD Red
    * 2x 2 TB WD xx

<file>
# egrep 'da[0-9]|cd[0-9]' /var/run/dmesg.boot

ada0 at ahcich0 bus 0 scbus0 target 0 lun 0
ada0: <WDC WD20EZRX-00DC0B0 80.00A80> ACS-2 ATA SATA 3.x device
ada0: Serial Number WD-WMC300246196
ada0: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada0: Command Queueing enabled
ada0: 1907729MB (3907029168 512 byte sectors)
ada0: quirks=0x1<4K>
ada1 at ahcich1 bus 0 scbus1 target 0 lun 0
ada1: <WDC WD20EARX-00PASB0 51.0AB51> ATA8-ACS SATA 3.x device
ada1: Serial Number WD-WCAZAD828429
ada1: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada1: Command Queueing enabled
ada1: 1907729MB (3907029168 512 byte sectors)
ada1: quirks=0x1<4K>
ada2 at ahcich2 bus 0 scbus2 target 0 lun 0
ada2: <WDC WD30EFRX-68EUZN0 80.00A80> ACS-2 ATA SATA 3.x device
ada2: Serial Number WD-WMC4N2244522
ada2: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada2: Command Queueing enabled
ada2: 2861588MB (5860533168 512 byte sectors)
ada2: quirks=0x1<4K>
ada3 at ahcich3 bus 0 scbus3 target 0 lun 0
ada3: <WDC WD30EFRX-68EUZN0 82.00A82> ACS-2 ATA SATA 3.x device
ada3: Serial Number WD-WCC4N6VD607V
ada3: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada3: Command Queueing enabled
ada3: 2861588MB (5860533168 512 byte sectors)
ada3: quirks=0x1<4K>
da0 at umass-sim0 bus 0 scbus7 target 0 lun 0
da0: <SanDisk Ultra USB 3.0 1.00> Removable Direct Access SPC-4 SCSI device
da0: Serial Number 4C530001241022123341
da0: 40.000MB/s transfers
da0: 29327MB (60062500 512 byte sectors)
da0: quirks=0x2<NO_6_BYTE>
ada0 at ahcich0 bus 0 scbus0 target 0 lun 0
ada0: <WDC WD20EZRX-00DC0B0 80.00A80> ACS-2 ATA SATA 3.x device
ada0: Serial Number WD-WMC300246196
ada0: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada0: Command Queueing enabled
ada0: 1907729MB (3907029168 512 byte sectors)
ada0: quirks=0x1<4K>
ada1 at ahcich1 bus 0 scbus1 target 0 lun 0
ada1: <WDC WD20EARX-00PASB0 51.0AB51> ATA8-ACS SATA 3.x device
ada1: Serial Number WD-WCAZAD828429
ada1: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada1: Command Queueing enabled
ada1: 1907729MB (3907029168 512 byte sectors)
ada1: quirks=0x1<4K>
ada2 at ahcich2 bus 0 scbus2 target 0 lun 0
ada2: <WDC WD30EFRX-68EUZN0 80.00A80> ACS-2 ATA SATA 3.x device
ada2: Serial Number WD-WMC4N2244522
ada2: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada2: Command Queueing enabled
ada2: 2861588MB (5860533168 512 byte sectors)
ada2: quirks=0x1<4K>
ada3 at ahcich3 bus 0 scbus3 target 0 lun 0
ada3: <WDC WD30EFRX-68EUZN0 82.00A82> ACS-2 ATA SATA 3.x device
ada3: Serial Number WD-WCC4N6VD607V
ada3: 300.000MB/s transfers (SATA 2.x, UDMA6, PIO 8192bytes)
ada3: Command Queueing enabled
ada3: 2861588MB (5860533168 512 byte sectors)
ada3: quirks=0x1<4K>
da0 at umass-sim0 bus 0 scbus7 target 0 lun 0
da0: <SanDisk Ultra USB 3.0 1.00> Removable Direct Access SPC-4 SCSI device
da0: Serial Number 4C530001241022123341
da0: 40.000MB/s transfers
da0: 29327MB (60062500 512 byte sectors)
da0: quirks=0x2<NO_6_BYTE>


# camcontrol devlist
<WDC WD20EZRX-00DC0B0 80.00A80>    at scbus0 target 0 lun 0 (pass0,ada0)
<WDC WD20EARX-00PASB0 51.0AB51>    at scbus1 target 0 lun 0 (pass1,ada1)
<WDC WD30EFRX-68EUZN0 80.00A80>    at scbus2 target 0 lun 0 (pass2,ada2)
<WDC WD30EFRX-68EUZN0 82.00A82>    at scbus3 target 0 lun 0 (pass3,ada3)
<SanDisk Ultra USB 3.0 1.00>       at scbus7 target 0 lun 0 (pass4,da0)


# gpart show

=>        40  3907029088  ada0  GPT  (1.8T)
          40          88        - free -  (44K)
         128     4194304     1  freebsd-swap  (2.0G)
     4194432  3902834696     2  freebsd-zfs  (1.8T)

=>        40  3907029088  ada1  GPT  (1.8T)
          40          88        - free -  (44K)
         128     4194304     1  freebsd-swap  (2.0G)
     4194432  3902834696     2  freebsd-zfs  (1.8T)

=>        34  5860533101  ada2  GPT  (2.7T)
          34          94        - free -  (47K)
         128     4194304     1  freebsd-swap  (2.0G)
     4194432  5856338696     2  freebsd-zfs  (2.7T)
  5860533128           7        - free -  (3.5K)

=>        34  5860533101  ada3  GPT  (2.7T)
          34          94        - free -  (47K)
         128     4194304     1  freebsd-swap  (2.0G)
     4194432  5856338696     2  freebsd-zfs  (2.7T)
  5860533128           7        - free -  (3.5K)

=>      40  60062424  da0  GPT  (29G)
        40      1024    1  freebsd-boot  (512K)
      1064  60030976    2  freebsd-zfs  (29G)
  60032040     30424       - free -  (15M)


</file>

<file>
#!/bin/bash
sqlite3 /data/freenas-v1.db ".tables" > table_names.txt

for t in $(cat table_names.txt); do
        if [ "$t" == "auth_permission" ]; then
                continue
        fi
        if [ "$t" == "django_content_type" ]; then
                continue
        fi
        if [ "$t" == "south_migrationhistory" ]; then
                continue
        fi
        echo "===== ${t} =====" >> all.txt ;
        sqlite3 /data/freenas-v1.db "SELECT * FROM ${t};" >> all.txt ;

done
</file>