Firebird News

Wednesday, December 28, 2011

My FSocial Network

Here is how my FNetwork looks like bellow The only observation I'm mostly strongly connected with coworkers , that means that i use the network for coworker notifications or maybe i'm workaholic :) I wish the visualisation was made with webgl

Tuesday, December 27, 2011

One way to run firebird pdo tests

Just to not forget how to run them i write here


TEST_PHP_EXECUTABLE=auto php -n ./run-tests.php ext/pdo_firebird
of course you can add username/password , db path
PDO_FIREBIRD_TEST_DSN='firebird:dbname=/var/lib/firebird/2.5/data/employee.fdb'
PDO_FIREBIRD_TEST_USER='SYSDBA' PDO_FIREBIRD_TEST_PASS='masterkey'
TEST_PHP_EXECUTABLE=auto php -n ./run-tests.php ext/pdo_firebird
Saw it via comment section from pdo firebird driver documentation

Saturday, December 10, 2011

php doc team docbook editor is pretty cool

We want something like this for firebird doc team :) Here is one shot with the documentation writing online, no need for other xml editors

Thursday, December 08, 2011

wodim saved my day and wrote the xubuntu 64 bit iso at last

I had problems with burning dvds both with xfburn and with brasero too

One of the errors  was
SCSI error on write(0,16): [3 73 03] Power calibration area error

Another problem was that burn completed the writing in xfburn but when reading and checking the md5 for the dvd

dd bs=1M if=/dev/sr0 of=/tmp/iso


[  349.397899] sr 0:0:1:0: [sr0]  Add. Sense: No seek complete
[  349.397906] sr 0:0:1:0: [sr0] CDB: Read(10): 28 00 00 05 49 df 00 00 01 00
[  349.397925] end_request: I/O error, dev sr0, sector 1386364
[  349.397933] Buffer I/O error on device sr0, logical block 346591
[  373.127873] sr 0:0:1:0: [sr0] Unhandled sense code
[  373.127880] sr 0:0:1:0: [sr0]  Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
[  373.127887] sr 0:0:1:0: [sr0]  Sense Key : Medium Error [current]
[  373.127896] Info fld=0x5299c
[  373.127899] sr 0:0:1:0: [sr0]  Add. Sense: No seek complete
[  373.127907] sr 0:0:1:0: [sr0] CDB: Read(10): 28 00 00 05 29 9c 00 00 20 00
[  373.127926] end_request: I/O error, dev sr0, sector 1353328
[  373.127933] Buffer I/O error on device sr0, logical block 338332
[  373.127939] Buffer I/O error on device sr0, logical block 338333
[  373.127954] Buffer I/O error on device sr0, logical block 338334
[  373.127957] Buffer I/O error on device sr0, logical block 338335
[  373.127961] Buffer I/O error on device sr0, logical block 338336
[  373.127964] Buffer I/O error on device sr0, logical block 338337
[  373.127967] Buffer I/O error on device sr0, logical block 338338
[  373.127970] Buffer I/O error on device sr0, logical block 338339
[  373.127974] Buffer I/O error on device sr0, logical block 338340
[  373.127977] Buffer I/O error on device sr0, logical block 338341
[  379.137046] sr 0:0:1:0: [sr0] Unhandled sense code
[  379.137053] sr 0:0:1:0: [sr0]  Result: hostbyte=DID_OK driverbyte=DRIVER_SENSE
[  379.137060] sr 0:0:1:0: [sr0]  Sense Key : Medium Error [current]
[  379.137069] Info fld=0x5299c



and it damaged every dvd i have throwed to it

Solution was to use the command line tools (saw it on a forum or in a bug tracker )



wodim -v dev=/dev/sr0 speed=4 xubuntu-11.10-desktop-amd64.iso
wodim: No write mode specified.
wodim: Assuming -tao mode.
wodim: Future versions of wodim may have different drive dependent defaults.
TOC Type: 1 = CD-ROM
scsidev: '/dev/sr0'
devname: '/dev/sr0'
scsibus: -2 target: -2 lun: -2
Linux sg driver version: 3.5.27
Wodim version: 1.1.11
SCSI buffer size: 64512
Device type    : Removable CD-ROM
Version        : 5
Response Format: 2
Capabilities   :
Vendor_info    : 'Optiarc '
Identification : 'DVD RW AD-7200A '
Revision       : '1.06'
Device seems to be: Generic mmc2 DVD-R/DVD-RW.
Current: 0x001B (DVD+R)
Profile: 0x002B (DVD+R/DL)
Profile: 0x001B (DVD+R) (current)
Profile: 0x001A (DVD+RW)
Profile: 0x0016 (DVD-R/DL layer jump recording)
Profile: 0x0015 (DVD-R/DL sequential recording)
Profile: 0x0014 (DVD-RW sequential recording)
Profile: 0x0013 (DVD-RW restricted overwrite)
Profile: 0x0012 (DVD-RAM)
Profile: 0x0011 (DVD-R sequential recording)
Profile: 0x0010 (DVD-ROM)
Profile: 0x000A (CD-RW)
Profile: 0x0009 (CD-R)
Profile: 0x0008 (CD-ROM)
Profile: 0x0002 (Removable disk)
Using generic SCSI-3/mmc DVD-R(W) driver (mmc_mdvd).
Driver flags   : SWABAUDIO BURNFREE
Supported modes: PACKET SAO
Drive buf size : 1310720 = 1280 KB
Beginning DMA speed test. Set CDR_NODMATEST environment variable if device
communication breaks or freezes immediately after that.
FIFO size      : 12582912 = 12288 KB
Track 01: data   693 MB      
Total size:      796 MB (78:52.88) = 354966 sectors
Lout start:      796 MB (78:54/66) = 354966 sectors
Current Secsize: 2048
HINT: use dvd+rw-mediainfo from dvd+rw-tools for information extraction.
Blocks total: 2295104 Blocks current: 2295104 Blocks remaining: 1940138
Speed set to 5540 KB/s
Starting to write CD/DVD at speed   4.0 in real unknown mode for single session.
Last chance to quit, starting real write in    0 seconds. Operation starts.
Waiting for reader process to fill input buffer ... input buffer ready.
Performing OPC...
Starting new track at sector: 0
Track 01:    1 of  693 MB written (fifo  97%) [buf  62%]   0.5x.




after that everything went fine


dd bs=1M if=/dev/sr0 of=/tmp/iso
693+1 records in
693+1 records out
726990848 bytes (727 MB) copied, 139.896 s, 5.2 MB/s