# 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)
#!/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