home Get a blog for free contact login

Articles in dir: /articles/

toto.bg and timestamping

Posted: Thu, 07 Mar 2019 04:33:36 +0200 (Updated: Sun, 10 Mar 2019 23:17:09 +0200)
Author: Делян Кръстев

Toto.BG и TimeStamp-ing

Някакъв голям джакпот ми се мерна в тотото наскоро и пусках фиш последните два тиража. Не щеш ли обаче джакпота не падна и реших да видя дали може да се пуска фиш OnLine . Оказа се, че може. Може, обаче:

  • Плащането става със зареждане на "сметка" от кредитна карта или ePay.bg
  • Минималната сума за зареждане е 10 лв
  • Регистрираш се, зареждаш си сметката, пускаш си фиша и не получаваш нищо

Няма разписка за направения залог, няма електронен фиш - нищичко. Ако спечелиш - пак нищо. Една мижава нотификациика не получаваш.

Знаейки в каква мафиотска държава живеем лесно мога да си представя как си правиш залога, удряш печалбата и утре тия ти казват, че тоя фиш не е твой, или че никога не е съществувал.

Ако аз я правех тази система щях да изпращам документ подписан със сертификат на БСТ, с данните от фиша и регистрацията на играещия, с което да може да удостовери, че фишът е негов. От там нататък този документ щеше да е по-сигурен от хартиените фишове, на които преносителят се счита за собственик.

Реших лекичко поне да се застраховам, да си сваля фиша и да си TimeStamp-на файла. За целта написах набързо следния кратък скрипт:

#!/bin/bash -x

openssl ts -query -no_nonce -sha512 -data $1 -out $1.tsq

curl -H "Content-Type: application/timestamp-query" \
    --data-binary "@$1.tsq" https://freetsa.org/tsr > $1.freetsa.tsr

openssl ts -reply -text -in $1.freetsa.tsr

Ако решите да ползвате подобна "схема" е важно да имате подписания TimeStamp преди тегленето на тиража. Не е лоша идея и да се ползват подписи с няколко вида хеш суми и различни TimeStampingAuthority-та .

Позачетох се и в общите условия на сайта на тотализатора:

  • 50% от залозите се връщат като печалби
  • 30% отиват за българския спорт ( оставащите 20% явно са им за разходи )
  • Ако удариш джакпота може доста да почакаш докато ти го платят. Давали ти 200 000 лв бързичко, после по 30 000 лв на месец, като разсрочвали плащането за 14 години (ако има остатък ти го плащат чак накрая).

Тук ми изниква въпроса, при положение, че събират залозите предварително а разсрочват печалбите, какво се случва с тия пари междувременно ?

Проверих в търговския регистър и изглежда, че все още "Български спортен тотализатор" е държавна собственост

Уточнение: Не обичам хазарта. Тото играя по изключение и то защото играта е държавна и уж субсидира българския спорт. То не че мога да съм сигурен, че пак не въртят някакви схеми да ги крадат тия пари.

В допълнение: "Националната лотария" е собственост на Васил Божков - Черепа. Купуването на талоните му, освен демонстрация на нисък интелект е и директно спонсорство на мафията.

Полезни връзки:

Posted in dir: /articles/
Tags: FreeTSA timestamping Toto.BG

Passing boot parameters to ScaleWay's baremetal C1 instance Linux kernel

Posted: Mon, 25 Feb 2019 01:16:57 +0200 (Updated: Mon, 25 Feb 2019 01:31:26 +0200)
Author: Делян Кръстев

Passing boot parameters to ScaleWay's baremetal C1 instance Linux kernel

Short story

Add tags like these to your server:

KEXEC_KERNEL=http://mirror.scaleway.com/kernel/armv7l-mainline-lts-4.9-4.9.93-rev1/vmlinuz
KEXEC_INITRD=http://mirror.scaleway.com/initrd/uInitrd-Linux-armv7l-v3.14.6
KEXEC_APPEND=vmalloc=512M

Longer story

The ScaleWay's "BareMetal" "C1" instance is a cheap EUR 3 / month cloud infrastructure instance. It has:

  • 4 32bit armv7l cores
  • 2 GB RAM
  • 50 GB network attached storage
  • 1 public IP included in the price

ScaleWay offers two lines of servers:

  • BareMetal
  • VirtualMachines (KVM based)

One important difference between the two is that:

  • A VM can only be booted with as much storage as included in its offer
  • Bare metal instances support attaching up-to 15x150 GB additional network block device drives ( charged EUR 1/month per 50 GB )

Another important difference is that currently in ScaleWay infrastructure, contra-logically:

  • Only VMs can run custom kernels
  • Bare metal servers come with e pre-build kernels and ScaleWay does not officially support changing these kernels. You can't even run the official kernel that comes with the chosen Linux distro.

Thus a problem arises you need to change something.

My case was that I wanted to use ZFS and it is not included in the official Linux kernel. It is rather build as a module. On standard Debian it is done easily by installing the zfs-dkms package.

It is possible to build the module for the C1 instance kernel by preparing the build env like described here:

The problem was, that ZFS on 32bit Linux:

  • "May encounter stability problems"
  • "May bump up against the virtual memory limit"

which is officially stated here:

I'm stil about to see the former but hit the latter quite fast, and as recommended I had to add the vmalloc=512M boot parameter.

Unfortunately Scaleway does not support passing parameters to their kernels. They however support KEXEC via the KEXEC_KERNEL and KEXEC_INITRD params as documented here:

and they support parameters to the KEXEC-ed kernel via the KEXEC_APPEND param.

So as I just needed to boot the same kernel and pass the parameter. So first I had to find where the current kernel and initrd are. This is done by installing "scaleway-cli":

I've just grabbed the pre-built amd64 deb packages, and then used the "scw" command to get info about the instance:

# list servers
$ scw ps 

# Show instance details 
$ scw inspect SERVER_ID

"bootscript": {
    "bootcmdargs": "LINUX_COMMON scaleway boot=local nbd.max_part=16",
    "initrd": "initrd/uInitrd-Linux-armv7l-v3.14.6",
    "kernel": "kernel/armv7l-mainline-lts-4.9-4.9.93-rev1",
    "dtb": "dtb/c1-armv7l-mainline-lts-4.9-4.9.93-rev1",
    ...

If you inspect a VM instance you will see that the kernel and initrd are referred by IP:

"bootscript": {
    "bootcmdargs": "LINUX_COMMON scaleway boot=local nbd.max_part=16",
    "initrd": "http://169.254.42.24/initrd/initrd-Linux-x86_64-v3.14.6.gz",
    "kernel": "http://169.254.42.24/kernel/x86_64-mainline-lts-4.4-4.4.127-rev1/vmlinuz-4.4.127"

And a google search showed me that the kernel and the initrd were available at:

I've had a problem by trying to use the image referred in the params above:

# DO NOT USE THIS ONE
KEXEC_INITRD=http://mirror.scaleway.com/initrd/uInitrd-Linux-armv7l-v3.14.6

and I've wasted a couple of hours until I realized that this image was in a different format, not usable for the KEXEC_INITRD . Then I've changed it to:

 KEXEC_INITRD=http://mirror.scaleway.com/initrd/initrd-Linux-armv7l-v3.14.6.gz

and this time it worked fine.

The kernel can be found via at least two different URLs:

KEXEC_KERNEL=http://mirror.scaleway.com/kernel/armv7l-mainline-lts-4.9-4.9.93-rev1/vmlinuz
             http://mirror.scaleway.com/kernel/armv7l/4.9.93-mainline-rev1/vmlinuz

And after the successfull boot I've just had to add:

KEXEC_APPEND=vmalloc=512M

And my ZFS module was no longer complaining about lack of virtual memory.

Let me add a few articles that were helpful:

I've wasted about a day while investigating this stuff. If you find it helpful and you think that I might have saved you a couple of hours you can decide to send me a small donation on this PayPal e-mail: krustev-paypal@krustev.net

Posted in dir: /articles/
Tags: BareMetal Debian Linux ScaleWay ZFS

GigaByte T1028M with Debian Buster

Posted: Wed, 26 Dec 2018 01:31:24 +0200 (Updated: Tue, 15 Jan 2019 05:08:51 +0200)
Author: Делян Кръстев

GigaByte T1028M with Debian Buster

I bought this small netbook about 10 years ago(2008) and my grandma was using it for Skype in the last 5+ years. I got her a tablet recently as the netbook was getting unsupported and quite slow (WinXP, 32 bit only).

When I bought it I've installed Debian on it and kept the WinXP available on a small resized partition. It was a pain back then to get some of the hardware working, e.g. the touch screen and the Elantech touchpad.

When I got it back I decided to update it to an up-to date Debian and since Buster was coming in a few months it was the candidate. I expected everything to be working out-of-the box but unfortunately it wasn't. So I've decided to put down this little article as a reminder.

Elantech touchpad not working

The multitouch mouse was not working after default Debian Buster install so:

# Add the following kernel parameter to /etc/default/grub
i8042.noloop=1

Suspends on each 10 seconds before logging-in

# Make sure you have this in /etc/systemd/logind.conf
HandleLidSwitch=ignore

Hardware

  • The processor is very slow - Intel Atom N270, 1.6 GHz, Single core with HyperThreading
  • HDD is very very slow. I will probably change it with a small SSD laying around.
  • Only 1GiB DDR2 RAM . Upgradeable to 2GiB (one DIMM socket only supporting 2GiB)
  • I think the mouse is generating interrupts, so "paste" does not work in the GUI (currently Cinnamon)
  • The touch screen worked with no additional configuration
  • It has BlueTooth, SD CardReader, Internal 3g modem with a SIM card slot, Camera

Keyboard

Bulgarian phonetic keyboard layout does not work with the default keyboard type for a US locale. I had to choose Acer laptop .

BIOS

BIOS update to latest version - May 10th 2010, ver.FD , is supposed to fix some problems, e.g.:

  • Add SSD flash drives support
  • WiFi card On by default (confirmed)

To upgrade the BIOS I've used Grub chainload to FreeDOS .

Desktop environment and software

Desktop environment

I've tried all offered desktop environments to choose what works best.

  • Gnome is very slow and eats too much memory
  • KDE/Plasma is my favorite on the desktop. It mostly works but is sluggish from time to time on this tiny CPU.
  • I've not experimented too much with Cinammon/LXDE

I've stuck with MATE as it works relatively fast and is lightweight. I was also able to set it up to my preferences with very little configuration .

Boot manager

  • I've chosen lightdm as it seems fast and lighweight
  • gdm is sluggish
  • sddm not that much but still slower than lightdm

Web browsers

At the time of install chromium was not available in Buster. So I've set up a mixed Buster/Sid system in order to be able to use it from Sid. It seems that ffmpeg dependencies were blocking its Buster presence.

  • Firefox works but
  • Chromium looks faster. Heavy sites like Facebook are slow. Youtube plays videos in its 360p resolution fine. 480p also works.
Posted in dir: /articles/
Tags: BIOS Buster Debian Elantech GigaByte LightDM MATE netbook t1028 t1028m touchpad

InfoNotary SmartCard config in Firefox and Chrome on Debian Stretch

Posted: Wed, 19 Apr 2017 13:37:10 +0300
Author: Делян Кръстев

InfoNotary maintain a useful wiki on the subject here:

http://wiki.infonotary.com

Configure the reader and the smart card

My reader is:

# lsusb
Bus 006 Device 002: ID 076b:6622 OmniKey AG CardMan 6121

The installation instructions are here:

http://wiki.infonotary.com/index.php/Инсталация_на_драйвери_за_четец_и_смарт_карта_в_Linux

Not all steps described there are needed. Here are mine:

  • Install pcscd and opensc packages
  • Check that openct is not installed (Not found in Debian Stretch when I'm writing this.)

pcscd depends on libccid which should NOT be installed. I've installed the pcsc-omnikey package which has the necessary Provides and purged libccid. pcsc-omnikey is available in the InfoNotary Debian package repository:

http://wiki.infonotary.com/index.php/Използване_на_хранилищата_на_InfoNotary

# wget -qO - http://repository.infonotary.com/install/linux/INotaryCodeSigning.key.asc | sudo apt-key add -
# wget http://repository.infonotary.com/install/linux/infonotary.list -qO /etc/apt/sources.list.d/infonotary.list
# apt-get update

I use aptitude and do the libccid purging and pcsc-omnikey install in one step. Then:

# systemctl stop pcscd.service
# pcscd --foreground

Check the pcscd output for the reader and use Ctrl+C to stop it.

I do NOT install the official OmniKey driver ifdokccid_linux .

Edit the file /etc/opensc/opensc.conf find the following section and set these values:

reader_driver pcsc {
     max_send_size = 0;
     max_recv_size = 0;

Then you can:

# systemctl start pcscd.service

Configure Firefox

The instructions are here:

http://wiki.infonotary.com/index.php/Използване_на_квалифициран_електронен_подпис_в_Mozilla_Firefox_за_Linux

On this page they recommend installation by using a FireFox extension. I do it manually though and it is shown with screens here:

http://wiki.infonotary.com/index.php/Използване_на_квалифициран_електронен_подпис_в_Mozilla_Firefox_за_Windows

Download the InfoNotary certs from here (from the menu - "публичен регистър->удостоверения на ИнфоНотари"):

http://www.infonotary.com/site/?p=doc_g1_3

You can import the individual "cer" files in the Authories section or the entire chain "p12" file. Do not forget to check the trust of individual imported certs.

Then on the same page:

http://wiki.infonotary.com/index.php/Използване_на_квалифициран_електронен_подпис_в_Mozilla_Firefox_за_Windows

it is shown how to activate the reader in Firefox. The path to the lib in Debian Stretch x86_64 is:

/usr/lib/x86_64-linux-gnu/onepin-opensc-pkcs11.so

The signing functionality has been removed from Firefox 35+, so in order to do signing from the browser you need a Firefox extension. There are two which are known to work and you can try them one by one "SignTextJS" and "SignTextJS plus"

Configure Google Chrome

It is well described here:

http://wiki.infonotary.com/index.php/Използване_на_квалифициран_електронен_подпис_в_Google_Chrome/Chromium_за_Linux

Further

I use the SmartCard for access to:

  • epay
  • FiBank
  • НАП

For НАП access these certs should also be imported into Chrome/Firefox:

https://inetdec.nra.bg/eservices.html

Posted in dir: /articles/

Повторна активация на ИТИ-1

Posted: Sat, 05 Mar 2016 16:23:30 +0200
Author: Делян Кръстев

На децата в първи клас в нашето училище им предоставиха учебник с диск, който може да бъде инсталиран и ползван за упражнения вкъщи. Ключа беше на хвърчащо листче и вече беше изчезнал когато Акси поиска да инсталираме диска да може да се упражнява. Учителката любезно ни даде ключ. Софтуера естествено беше само за уиндоус. Не ползвам уиндоус и имах такъв на един стар лаптоп. Инсталирах диска и програмата проработи. Проблема беше, че тоя уиндоус е дошъл от някъде някога и някой си беше мазал по него, поради което се влачеше и стартираше много бавно. Наложи се да направя преинсталация. Ключа за активация на ИТИ-1, както беше посочено, беше за еднократна употреба и програмата не можеше да се активира повторно на преинсталираната машина. Та се наложи леко да подпомогна процеса на активация. Оказа се, че за активация програмата пуска заявки до:

GET /itirequest.php?key=XXXXXXXXXXXX HTTP/1.1
Host: itlearning-bg.com

GET /itiactivate.php?key=XXXXXXXXXXXX HTTP/1.1
Host: itlearning-bg.com

като за втората заявка има и още параметри, които не ни интересуват.

За целта на активацията трябва да се прихванат тези заявки и да се върнат отговори каквито програмата очаква:

# edit c:\windows\system32\drivers\etc\hosts and add custom record which points to a web server which you control
192.168.0.1 itlearning-bg.com www.itlearning-bg.com

след това редактирайте файловете в уеб сървъра да връщат:

# cat itirequest.php 
<?
echo 'AVAILABLE 5 05/03/2017 14:48:36';

## cat itiactivate.php 
<?
echo 'SUCCESS';

5 е номера на потребителите на програмата а датата е до кога ще ви бъде валидна активацията. Ако нямате PHP в уебсървъра може да сложите само стойностите в съответните файлове.

Posted in dir: /articles/

skk dtv list

Posted: Sun, 01 Jul 2012 20:30:00 +0300 (Updated: Fri, 25 Jan 2013 02:34:17 +0200)
Author: Делян Кръстев

Списък с DTV каналите на TVNET.BG / SKKNET.NET

Информацията е актуализирана от сайта tvnet.bg на 24.Януари.2013 г.

От оператора ми препоръчха да избера страна Швеция, Финландия или друга северно европейска и да пусна автоматична настройка. Телевизора ми(LG) обаче нямаше тези държави като опция, и каналите на по-високите честоти (над 800 MHz) не бяха открити автоматично при избор на България/Швейцария. Така че пуснах ръчно сканиране на тези честоти.

Откриват се и 14 радиа.

HDTV по честота

Честота                         | Канал       | Име
---------------------------------------------------------
242.00 Mhz - S/R 6900 - QAM 256 | канал - 114 | Канал 1 HD 
442.00 Mhz - S/R 6900 - QAM 256 | канал -123  | BTV HD
442.00 Mhz - S/R 6900 - QAM 256 | канал -124  | BTV Action HD
442.00 Mhz - S/R 6900 - QAM 256 | канал -125  | Ring bg HD
450.00 Mhz - S/R 6900 - QAM 256 | канал - 109 | Discovery HD 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 110 | MTV live HD 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 111 | NatGeo Wild HD 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 113 | Deluxe Lounge HD 
538.00 Mhz - S/R 6900 - QAM 256 | канал - 27  | Travel HD
843.00 Mhz - S/R 6900 - QAM 256 | канал - 88  | Nova Premier League HD
851.00 Mhz - S/R 6900 - QAM 256 | канал - 101 | NatGeo HD 
851.00 Mhz - S/R 6900 - QAM 256 | канал - 98  | Planeta HD 
851.00 Mhz - S/R 6900 - QAM 256 | канал - 99  | Eurosport HD 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 107 | Viasat Nature HD-Viasat History HD

По честота:

Честота                         | Канал       | Име
242.00 Mhz - S/R 6900 - QAM 256 | канал - 114 | Канал 1 HD 
242.00 Mhz - S/R 6900 - QAM 256 | канал - 94  | Kabel 1 
442.00 Mhz - S/R 6900 - QAM 256 | канал - 123 | BTV HD
442.00 Mhz - S/R 6900 - QAM 256 | канал - 124 | BTV Action HD
442.00 Mhz - S/R 6900 - QAM 256 | канал - 125 | Ring bg HD
442.00 Mhz - S/R 6900 - QAM 256 | канал - 126 | Discovery ID
442.00 Mhz - S/R 6900 - QAM 256 | канал - 127 | Fox channel
450.00 Mhz - S/R 6900 - QAM 256 | канал - 109 | Discovery HD 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 110 | MTV live HD 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 111 | NatGeo Wild HD 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 112 | Auto Motor und Sport 
450.00 Mhz - S/R 6900 - QAM 256 | канал - 113 | Deluxe Lounge HD 
458.00 Mhz - S/R 6900 - QAM 256 | канал - 1   | Planeta TV
458.00 Mhz - S/R 6900 - QAM 256 | канал - 2   | BNT1
458.00 Mhz - S/R 6900 - QAM 256 | канал - 3   | TV7
458.00 Mhz - S/R 6900 - QAM 256 | канал - 4   | BTV
458.00 Mhz - S/R 6900 - QAM 256 | канал - 5   | Nova TV
458.00 Mhz - S/R 6900 - QAM 256 | канал - 6   | Kino Nova
458.00 Mhz - S/R 6900 - QAM 256 | канал - 7   | Discovery Channel
458.00 Mhz - S/R 6900 - QAM 256 | канал - 8   | DIEMA
458.00 Mhz - S/R 6900 - QAM 256 | канал - 9   | 24 kitchen
466.00 Mhz - S/R 6900 - QAM 256 | канал - 10 | NOVASPORT
466.00 Mhz - S/R 6900 - QAM 256 | канал - 11 | DIVA universal
466.00 Mhz - S/R 6900 - QAM 256 | канал - 12 | Канал 3
466.00 Mhz - S/R 6900 - QAM 256 | канал - 13 | Discovery science
466.00 Mhz - S/R 6900 - QAM 256 | канал - 14 | Discovery World
466.00 Mhz - S/R 6900 - QAM 256 | канал - 15 | History channel
466.00 Mhz - S/R 6900 - QAM 256 | канал - 16 | Ring bg
466.00 Mhz - S/R 6900 - QAM 256 | канал - 17 | TV Evropa
466.00 Mhz - S/R 6900 - QAM 256 | канал - 18 | Super 7
538.00 Mhz - S/R 6900 - QAM 256 | канал - 19 | Fox Life
538.00 Mhz - S/R 6900 - QAM 256 | канал - 20 | Fox Crime
538.00 Mhz - S/R 6900 - QAM 256 | канал - 21 | BBT
538.00 Mhz - S/R 6900 - QAM 256 | канал - 22 | The Voice
538.00 Mhz - S/R 6900 - QAM 256 | канал - 23 | Disney Channel
538.00 Mhz - S/R 6900 - QAM 256 | канал - 24 | BNT 2
538.00 Mhz - S/R 6900 - QAM 256 | канал - 25 | Planeta Folk
538.00 Mhz - S/R 6900 - QAM 256 | канал - 26 | NBT
538.00 Mhz - S/R 6900 - QAM 256 | канал - 27 | Travel HD
546.00 Mhz - S/R 6900 - QAM 256 | канал - 28 | Diema Family
546.00 Mhz - S/R 6900 - QAM 256 | канал - 29 | National Geographic
546.00 Mhz - S/R 6900 - QAM 256 | канал - 30 | TV 1000
546.00 Mhz - S/R 6900 - QAM 256 | канал - 31 | Animal Planet
546.00 Mhz - S/R 6900 - QAM 256 | канал - 32 | bTV Cinema
546.00 Mhz - S/R 6900 - QAM 256 | канал - 33 | Eurosport
546.00 Mhz - S/R 6900 - QAM 256 | канал - 34 | bTV Comedy
546.00 Mhz - S/R 6900 - QAM 256 | канал - 35 | Eurosport 2
546.00 Mhz - S/R 6900 - QAM 256 | канал - 36 | bTV Action
690.00 Mhz - S/R 6900 - QAM 256 | канал - 37 | DW - TV
690.00 Mhz - S/R 6900 - QAM 256 | канал - 38 | VTV
690.00 Mhz - S/R 6900 - QAM 256 | канал - 39 | BNT World
690.00 Mhz - S/R 6900 - QAM 256 | канал - 40 | ВТК
690.00 Mhz - S/R 6900 - QAM 256 | канал - 41 | E-Kids
690.00 Mhz - S/R 6900 - QAM 256 | канал - 42 | BGTV
690.00 Mhz - S/R 6900 - QAM 256 | канал - 43 | Boomerang
690.00 Mhz - S/R 6900 - QAM 256 | канал - 44 | Bloomberg Europe
690.00 Mhz - S/R 6900 - QAM 256 | канал - 45 | Охота и рыбалка
690.00 Mhz - S/R 6900 - QAM 256 | канал - 46 | Travel TV
730.00 Mhz - S/R 6900 - QAM 256 | канал - 47 | HBO Comedy
730.00 Mhz - S/R 6900 - QAM 256 | канал - 48 | HBO
730.00 Mhz - S/R 6900 - QAM 256 | канал - 49 | CINEMAX
730.00 Mhz - S/R 6900 - QAM 256 | канал - 50 | CINEMAX 2
730.00 Mhz - S/R 6900 - QAM 256 | канал - 51 | Private Spice
730.00 Mhz - S/R 6900 - QAM 256 | канал - 52 | FreeXTV
730.00 Mhz - S/R 6900 - QAM 256 | канал - 53 | Frenchlover
730.00 Mhz - S/R 6900 - QAM 256 | канал - 54 | Dorcel TV
730.00 Mhz - S/R 6900 - QAM 256 | канал - 55 | Viasat Explorer
730.00 Mhz - S/R 6900 - QAM 256 | канал - 56 | BOX TV
810.00 Mhz - S/R 6900 - QAM 256 | канал - 115 | AB MOTEURS
810.00 Mhz - S/R 6900 - QAM 256 | канал - 117 | BBC World
810.00 Mhz - S/R 6900 - QAM 256 | канал - 118 | ERT 
810.00 Mhz - S/R 6900 - QAM 256 | канал - 119 | ANIMAUX
810.00 Mhz - S/R 6900 - QAM 256 | канал - 120 | Chasse & Peche
810.00 Mhz - S/R 6900 - QAM 256 | канал - 121 | Escales
810.00 Mhz - S/R 6900 - QAM 256 | канал - 122 | Encyclo
810.00 Mhz - S/R 6900 - QAM 256 | канал - 116 | Euronews
819.00 Mhz - S/R 6900 - QAM 256 | канал - 57 | ФЕН TV
819.00 Mhz - S/R 6900 - QAM 256 | канал - 58 | Extreme
819.00 Mhz - S/R 6900 - QAM 256 | канал - 59 | City TV
819.00 Mhz - S/R 6900 - QAM 256 | канал - 60 | Folklor TV
819.00 Mhz - S/R 6900 - QAM 256 | канал - 61 | bTV Lady
819.00 Mhz - S/R 6900 - QAM 256 | канал - 62 | Pink
819.00 Mhz - S/R 6900 - QAM 256 | канал - 63 | MTV Europe
819.00 Mhz - S/R 6900 - QAM 256 | канал - 64 | Balkanika
819.00 Mhz - S/R 6900 - QAM 256 | канал - 65 | Russia Today
819.00 Mhz - S/R 6900 - QAM 256 | канал - 66 | France 24
819.00 Mhz - S/R 6900 - QAM 256 | канал - 67 | DM SAT
827.00 Mhz - S/R 6900 - QAM 256 | канал - 68 | ОРТ - Первый канал 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 69 | Cartoon Network 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 70 | National Geographic Wild 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 71 | CBS Reality 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 72 | AXN 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 73 | AXN sci-fi
827.00 Mhz - S/R 6900 - QAM 256 | канал - 74 | AXN crime
827.00 Mhz - S/R 6900 - QAM 256 | канал - 75 | Viasat History 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 76 | TV5 Monde Europe 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 77 | RTL 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 78 | RTL 2 
827.00 Mhz - S/R 6900 - QAM 256 | канал - 79 | Rai 1 
835.00 Mhz - S/R 6900 - QAM 256 | канал - 80 | Viasat Nature
835.00 Mhz - S/R 6900 - QAM 256 | канал - 81 | Rai 3 
835.00 Mhz - S/R 6900 - QAM 256 | канал - 82 | Rai News
835.00 Mhz - S/R 6900 - QAM 256 | канал - 83 | Crime and investigation network 
835.00 Mhz - S/R 6900 - QAM 256 | канал - 84 | Jim Jam
835.00 Mhz - S/R 6900 - QAM 256 | канал - 85 | RTVi Europe
835.00 Mhz - S/R 6900 - QAM 256 | канал - 86 | RTVI Nashe Kino
835.00 Mhz - S/R 6900 - QAM 256 | канал - 87 | Fine Living Network 
835.00 Mhz - S/R 6900 - QAM 256 | канал - 90 | Fiesta TV 
843.00 Mhz - S/R 6900 - QAM 256 | канал - 88 | Nova Premier League HD
843.00 Mhz - S/R 6900 - QAM 256 | канал - 89 | VH1
843.00 Mhz - S/R 6900 - QAM 256 | канал - 91 | Viva
843.00 Mhz - S/R 6900 - QAM 256 | канал - 92 | Al Jazeera
843.00 Mhz - S/R 6900 - QAM 256 | канал - 93 | Pro 7
843.00 Mhz - S/R 6900 - QAM 256 | канал - 95 | Super RTL
843.00 Mhz - S/R 6900 - QAM 256 | канал - 96 | VOX 
843.00 Mhz - S/R 6900 - QAM 256 | канал - 97 | Bulgaria on air
851.00 Mhz - S/R 6900 - QAM 256 | канал - 100 | TVE International 
851.00 Mhz - S/R 6900 - QAM 256 | канал - 101 | NatGeo HD 
851.00 Mhz - S/R 6900 - QAM 256 | канал - 98 | Planeta HD 
851.00 Mhz - S/R 6900 - QAM 256 | канал - 99 | Eurosport HD 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 102 | PPV 1 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 103 | PPV 2 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 104 | PPV 3 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 105 | PPV 4 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 106 | PPV 5 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 107 | Viasat Nature HD-Viasat History HD 
859.00 Mhz - S/R 6900 - QAM 256 | канал - 108 | Mad TV

По име (имената са взети от tvnet.bg)

Име | Канал | Честота
24 kitchen | канал - 9 | 458.00 Mhz - S/R 6900 - QAM 256
ВТК | канал - 40 | 690.00 Mhz - S/R 6900 - QAM 256
Канал 1 HD  | канал - 114 | 242.00 Mhz - S/R 6900 - QAM 256
Канал 3 | канал - 12 | 466.00 Mhz - S/R 6900 - QAM 256
ОРТ - Первый канал  | канал - 68 | 827.00 Mhz - S/R 6900 - QAM 256
Охота и рыбалка | канал - 45 | 690.00 Mhz - S/R 6900 - QAM 256
ФЕН TV | канал - 57 | 819.00 Mhz - S/R 6900 - QAM 256
AB MOTEURS | канал - 115 | 810.00 Mhz - S/R 6900 - QAM 256
Al Jazeera | канал - 92 | 843.00 Mhz - S/R 6900 - QAM 256
Animal Planet | канал - 31 | 546.00 Mhz - S/R 6900 - QAM 256
ANIMAUX | канал -119 | 810.00 Mhz - S/R 6900 - QAM 256
Auto Motor und Sport  | канал - 112 | 450.00 Mhz - S/R 6900 - QAM 256
AXN  | канал - 72 | 827.00 Mhz - S/R 6900 - QAM 256
AXN crime | канал - 74 | 827.00 Mhz - S/R 6900 - QAM 256
AXN sci-fi | канал - 73 | 827.00 Mhz - S/R 6900 - QAM 256
Balkanika | канал - 64 | 819.00 Mhz - S/R 6900 - QAM 256
BBC World | канал - 117 | 810.00 Mhz - S/R 6900 - QAM 256
BBT | канал - 21 | 538.00 Mhz - S/R 6900 - QAM 256
BGTV | канал - 42 | 690.00 Mhz - S/R 6900 - QAM 256
Bloomberg Europe | канал - 44 | 690.00 Mhz - S/R 6900 - QAM 256
BNT1 | канал -2 | 458.00 Mhz - S/R 6900 - QAM 256
BNT 2 | канал - 24 | 538.00 Mhz - S/R 6900 - QAM 256
BNT World | канал - 39 | 690.00 Mhz - S/R 6900 - QAM 256
Boomerang | канал - 43 | 690.00 Mhz - S/R 6900 - QAM 256
BOX TV | канал - 56 | 730.00 Mhz - S/R 6900 - QAM 256
BTV | канал - 4 | 458.00 Mhz - S/R 6900 - QAM 256
bTV Action | канал - 36 | 546.00 Mhz - S/R 6900 - QAM 256
BTV Action HD | канал -124 | 442.00 Mhz - S/R 6900 - QAM 256
bTV Cinema | канал - 32 | 546.00 Mhz - S/R 6900 - QAM 256
bTV Comedy | канал - 34 | 546.00 Mhz - S/R 6900 - QAM 256
BTV HD | канал -123 | 442.00 Mhz - S/R 6900 - QAM 256
bTV Lady | канал - 61 | 819.00 Mhz - S/R 6900 - QAM 256
Bulgaria on air | канал - 97 | 843.00 Mhz - S/R 6900 - QAM 256
Cartoon Network  | канал - 69 | 827.00 Mhz - S/R 6900 - QAM 256
CBS Reality  | канал - 71 | 827.00 Mhz - S/R 6900 - QAM 256
Chasse & Peche | канал - 120 | 810.00 Mhz - S/R 6900-QAM 256
CINEMAX 2 | канал - 50 | 730.00 Mhz - S/R 6900 - QAM 256
CINEMAX | канал - 49 | 730.00 Mhz - S/R 6900 - QAM 256
City TV | канал - 59 | 819.00 Mhz - S/R 6900 - QAM 256
Crime and investigation network  | канал - 83 | 835.00 Mhz - S/R 6900 - QAM 256
Deluxe Lounge HD  | канал - 113 | 450.00 Mhz - S/R 6900 - QAM 256
DIEMA | канал - 8 | 458.00 Mhz - S/R 6900 - QAM 256
Diema Family | канал - 28 | 546.00 Mhz - S/R 6900 - QAM 256
Discovery Channel | канал - 7 | 458.00 Mhz - S/R 6900 - QAM 256
Discovery HD  | канал - 109 | 450.00 Mhz - S/R 6900 - QAM 256
Discovery ID | канал -126 | 442.00 Mhz - S/R 6900 - QAM 256
Discovery science | канал - 13 | 466.00 Mhz - S/R 6900 - QAM 256
Discovery World | канал - 14 | 466.00 Mhz - S/R 6900 - QAM 256
Disney Channel | канал - 23 | 538.00 Mhz - S/R 6900 - QAM 256
DIVA universal | канал - 11 | 466.00 Mhz - S/R 6900 - QAM 256
DM SAT | канал - 67 | 819.00 Mhz - S/R 6900 - QAM 256
Dorcel TV | канал - 54 | 730.00 Mhz - S/R 6900 - QAM 256
DW - TV | канал - 37 | 690.00 Mhz - S/R 6900 - QAM 256
E-Kids | канал - 41 | 690.00 Mhz - S/R 6900 - QAM 256
Encyclo | канал -122 | 810.00 Mhz - S/R 6900 - QAM 256
ERT  | канал - 118 | 810.00 Mhz - S/R 6900 - QAM 256
Escales | канал -121 | 810.00 Mhz - S/R 6900 - QAM 256
Euronews | програма - 116 | 810.00 Mhz - S/R 6900 - QAM 256
Eurosport 2 | канал - 35 | 546.00 Mhz - S/R 6900 - QAM 256
Eurosport | канал - 33 | 546.00 Mhz - S/R 6900 - QAM 256
Eurosport HD  | канал - 99 | 851.00 Mhz - S/R 6900 - QAM 256
Extreme | канал - 58 | 819.00 Mhz - S/R 6900 - QAM 256
Fiesta TV  | канал - 90 | 835.00 Mhz - S/R 6900 - QAM 256
Fine Living Network  | канал - 87 | 835.00 Mhz - S/R 6900 - QAM 256
Folklor TV | канал - 60 | 819.00 Mhz - S/R 6900 - QAM 256
Fox channel | канал -127 | 442.00 Mhz - S/R 6900 - QAM 256
Fox Crime | канал - 20 | 538.00 Mhz - S/R 6900 - QAM 256
Fox Life | канал - 19 | 538.00 Mhz - S/R 6900 - QAM 256
France 24 | канал - 66 | 819.00 Mhz - S/R 6900 - QAM 256
FreeXTV | канал - 52 | 730.00 Mhz - S/R 6900 - QAM 256
Frenchlover | канал - 53 | 730.00 Mhz - S/R 6900 - QAM 256
HBO | канал - 48 | 730.00 Mhz - S/R 6900 - QAM 256
HBO Comedy | канал - 47 | 730.00 Mhz - S/R 6900 - QAM 256
History channel | канал - 15 | 466.00 Mhz - S/R 6900 - QAM 256
Jim Jam | канал - 84 | 835.00 Mhz - S/R 6900 - QAM 256
Kabel 1  | канал - 94 | 242.00 Mhz - S/R 6900 - QAM 256
Kino Nova | канал - 6 | 458.00 Mhz - S/R 6900 - QAM 256
Mad TV  | канал - 108 | 859.00 Mhz - S/R 6900 - QAM 256
MTV Europe | канал - 63 | 819.00 Mhz - S/R 6900 - QAM 256
MTV live HD  | канал - 110 | 450.00 Mhz - S/R 6900 - QAM 256
NatGeo HD  | канал - 101 | 851.00 Mhz - S/R 6900 - QAM 256
NatGeo Wild HD  | канал - 111 | 450.00 Mhz - S/R 6900 - QAM 256
National Geographic | канал - 29 | 546.00 Mhz - S/R 6900 - QAM 256
National Geographic Wild  | канал - 70 | 827.00 Mhz - S/R 6900 - QAM 256
NBT | канал - 26 | 538.00 Mhz - S/R 6900 - QAM 256
Nova Premier League HD | канал - 88 | 843.00 Mhz - S/R 6900 - QAM 256
NOVASPORT | канал - 10 | 466.00 Mhz - S/R 6900 - QAM 256
Nova TV | канал - 5 | 458.00 Mhz - S/R 6900 - QAM 256
Pink | канал - 62 | 819.00 Mhz - S/R 6900 - QAM 256
Planeta Folk | канал - 25 | 538.00 Mhz - S/R 6900 - QAM 256
Planeta HD  | канал - 98 | 851.00 Mhz - S/R 6900 - QAM 256
Planeta TV | канал -1 | 458.00 Mhz - S/R 6900 - QAM 256
PPV 1  | канал - 102 | 859.00 Mhz - S/R 6900 - QAM 256
PPV 2  | канал - 103 | 859.00 Mhz - S/R 6900 - QAM 256
PPV 3  | канал - 104 | 859.00 Mhz - S/R 6900 - QAM 256
PPV 4  | канал - 105 | 859.00 Mhz - S/R 6900 - QAM 256
PPV 5  | канал - 106 | 859.00 Mhz - S/R 6900 - QAM 256
Private Spice | канал - 51 | 730.00 Mhz - S/R 6900 - QAM 256
Pro 7 | канал - 93 | 843.00 Mhz - S/R 6900 - QAM 256
Rai 1  | канал - 79 | 827.00 Mhz - S/R 6900 - QAM 256
Rai 3  | канал - 81 | 835.00 Mhz - S/R 6900 - QAM 256
Rai News | канал - 82 | 835.00 Mhz - S/R 6900 - QAM 256
Ring bg | канал - 16 | 466.00 Mhz - S/R 6900 - QAM 256
Ring bg HD | канал -125 | 442.00 Mhz - S/R 6900 - QAM 256
RTL 2  | канал - 78 | 827.00 Mhz - S/R 6900 - QAM 256
RTL  | канал - 77 | 827.00 Mhz - S/R 6900 - QAM 256
RTVi Europe | канал - 85 | 835.00 Mhz - S/R 6900 - QAM 256
RTVI Nashe Kino | канал - 86 | 835.00 Mhz - S/R 6900 - QAM 256
Russia Today | канал - 65 | 819.00 Mhz - S/R 6900 - QAM 256
Super 7 | канал - 18 | 466.00 Mhz - S/R 6900 - QAM 256
Super RTL | канал - 95 | 843.00 Mhz - S/R 6900 - QAM 256
The Voice | канал - 22 | 538.00 Mhz - S/R 6900 - QAM 256
Travel HD | канал - 27 | 538.00 Mhz - S/R 6900 - QAM 256
Travel TV | канал - 46 | 690.00 Mhz - S/R 6900 - QAM 256
TV 1000 | канал - 30 | 546.00 Mhz - S/R 6900 - QAM 256
TV5 Monde Europe  | канал - 76 | 827.00 Mhz - S/R 6900 - QAM 256
TV7 | канал -3 | 458.00 Mhz - S/R 6900 - QAM 256
TVE International  | канал - 100 | 851.00 Mhz - S/R 6900 - QAM 256
TV Evropa | канал - 17 | 466.00 Mhz - S/R 6900 - QAM 256
VH1 | канал - 89 | 843.00 Mhz - S/R 6900 - QAM 256
Viasat Explorer | канал - 55 | 730.00 Mhz - S/R 6900 - QAM 256
Viasat History  | канал - 75 | 827.00 Mhz - S/R 6900 - QAM 256
Viasat Nature | канал - 80 | 835.00 Mhz - S/R 6900 - QAM 256
Viasat Nature HD-Viasat History HD  | канал - 107 | 859.00 Mhz - S/R 6900 - QAM 256
Viva | канал - 91 | 843.00 Mhz - S/R 6900 - QAM 256
VOX  | канал - 96 | 843.00 Mhz - S/R 6900 - QAM 256
VTV | канал - 38 | 690.00 Mhz - S/R 6900 - QAM 256
Posted in dir: /articles/tvnet/

Global equalizer for ALSA

Posted: Fri, 17 Feb 2012 02:41:01 +0200 (Updated: Fri, 17 Feb 2012 03:14:22 +0200)
Author: Делян Кръстев

Ever wondered how to have a system global equalizer for ALSA ?! Once I wondered too. Now I know.

1.Non real-time

One option is to use LADSPA:


$ sudo apt-get install caps
$ cat ~/.asoundrc

pcm.!default {
        type plug
        slave.pcm "equalized";
}

pcm.equalized {
        type ladspa
        slave.pcm "plug:dmix";
        path "/usr/lib/ladspa";
        plugins [
        {
                id 1773
                input {
                        controls [ -5 -5 -5 -5 -5 -5 1 3 7 1 ]
                }
        }
        ]
}

Unfortunately this does not allow on-the-fly mixer level adjustments and you have to edit ~/.asoundrc and restart all processes which you want to use the adjusted mixer levels.

2.Real-time !

Recently I found another option though. It supports real-time equalizer adjustments:


$ sudo apt-get install libasound2-plugin-equal
$ cat ~/.asoundrc

pcm.!default {
        type plug
        slave.pcm "plugequal";
}
ctl.equal {
    type equal;
}
pcm.plugequal {
    type equal;
    slave.pcm "plug:dmix";
}

$ alsamixer -D equal
$ alsamixergui -D equal

Just a reminder. The default levels are: 25 for 31HZ(leftmost) and 66 for all the rest.

The levels could be reset by deleting ~/.alsaequal.bin . Doing this manually requires a restart of the processes that used it.

References:

Posted in dir: /articles/

Linux and webcams

Posted: Sun, 30 Oct 2011 03:01:45 +0200 (Updated: Sun, 30 Oct 2011 12:48:25 +0200)
Author: Делян Кръстев

I've recently got a nice webcam - Logitech C600

  • UVC driver
  • Wide angle (about 70 deg)
  • Good video ( capable of 30 fps at 1280x720 when using anything but YUYV camera output format )
  • Good sound

The supported camera outputs are:

  • YUYV
  • MJPEG
  • RGB3
  • BGR3
  • YU12
  • YV12

The best video quality is in the YUYV mode, however it is using less(or no) compression, so the high frame rates are available at 640x480@30 fps, and 800x600@25 fps.

Strangely, the webcam does some cropping when used at high video resolution & high frame rates. The controls pan/tilt are only usable in this crop mode. Skype also does a switch to one of the crop modes after e.g. 30 seconds of the call (I'm using the skype option to capture at 640x480 which it probably uses initially ).

Useful software:

  • guvcview
  • mplayer
  • vlc
  • v4l2ucp (video for linux 2 universal control panel)
  • luvcview

GUVCView

GUVCview is able to show what your webcam can do. You can easily switch resolutions, frame rates, camera output format . It can record video in different formats and capture still images. All of V4L2 settings which your camera supports could be changed. By default it presents a preview screen, so you can see how the switch of settings is affecting the captured video. The actual frames per seconds are also displayed on the video preview window. You can also use it as a camera control application when the capture is done by another app (e.g. skype). Just start it like:

guvcview -o

Another very nice feature is that you can capture video with sound. You can easily choose which mic to use - the camera built in or the one sitting on your desktop.

It is a good idea to keep an eye of the processor load (and on the terminal window) while capturing. Some formats use the CPU heavily and video/audio can easily get out of sync.

MPlayer

MPlayer is usable for fast preview. To play video with mplayer you can just do:

mplayer tv://

or give it some more options:

mplayer -tv driver=v4l2:input=0:width=640:height=480:device=/dev/video0

It appeared hard to get mencoder to capture the video right, especially when it does frame rate switching during the capture. Mine does that when it has the option "Exposure auto priority" checked. I was not able to get mplayer play video and audio at the same time too. But may be I've not tried hard enough. VLC on the other hand can do this.

VLC

VLC needs to know the video and sound devices when you open a capture device. I've specified them as:

/dev/video0 (the webcam)
hw:1 (or hw:1,0) (this was my webcam mic)

You can list your capture devices by:

arecord -l

VLC output is a little laggish in comparison to mplayer or guvcview preview window. I was able to fix this by specifying a smaller buffer time (300ms by default), however at a later try this did not work. I've not played with VLC enough too. As you might know it is quite powerful - may be the most mature video player with a GUI available for Linux. I still use mplayer from the command line for video playing though and haven't found a reason to replace it with anything else :-)

v4l2ucp/luvcview

v4l2ucp is covered by the "Image control" tab of guvcview. Luvcview looks like older version of his G brother. You can get the list of video modes your camera support by doing:

luvcview -L

Another software which I've barely tried is the popular "cheese".

The ultimate webcam software for linux is GUVCView.

Some extra commands to test sound from your webcam mic:

$ arecord -l
**** List of CAPTURE Hardware Devices ****
card 0: Intel [HDA Intel], device 0: ALC883 Analog [ALC883 Analog]
  Subdevices: 1/1
  Subdevice #0: subdevice #0
card 0: Intel [HDA Intel], device 2: ALC883 Analog [ALC883 Analog]
  Subdevices: 1/1
  Subdevice #0: subdevice #0
card 1: U0x46d0x808 [USB Device 0x46d:0x808], device 0: USB Audio [USB Audio]
  Subdevices: 1/1
  Subdevice #0: subdevice #0

# No sound here
$ arecord -D hw:U0x46d0x808,0 | aplay
Recording WAVE 'stdin' : Unsigned 8 bit, Rate 8000 Hz, Mono
arecord: set_params:1065: Sample format non available
Available formats:
- S16_LE
aplay: playback:2467: read error


# This played the sound. Note that some of the times I started a command
# the sound did not show up. Next time I've tried it it did. The same was
# true for VLC sound capture tests. So I guess the device is not
# always initialized right.
$ arecord -D hw:U0x46d0x808,0 -f S16_LE | aplay
Recording WAVE 'stdin' : Signed 16 bit Little Endian, Rate 8000 Hz, Mono
Warning: rate is not accurate (requested = 8000Hz, got = 16000Hz)
         please, try the plug plugin 
Playing WAVE 'stdin' : Signed 16 bit Little Endian, Rate 16000 Hz, Mono
^CAborted by signal Interrupt...
Aborted by signal Interrupt...

# Specify the proper rate
$ arecord -D hw:U0x46d0x808,0 -f S16_LE -r 16 | aplay
Recording WAVE 'stdin' : Signed 16 bit Little Endian, Rate 16000 Hz, Mono
Playing WAVE 'stdin' : Signed 16 bit Little Endian, Rate 16000 Hz, Mono
^CAborted by signal Interrupt...
Aborted by signal Interrupt...

# Use mmap instead of read:
$ arecord -D hw:U0x46d0x808,0 -f S16_LE -r 16 -M | aplay
Recording WAVE 'stdin' : Signed 16 bit Little Endian, Rate 16000 Hz, Mono
Playing WAVE 'stdin' : Signed 16 bit Little Endian, Rate 16000 Hz, Mono
underrun!!! (at least -1900024418,571 ms long)
^CAborted by signal Interrupt...
Aborted by signal Interrupt...
$

Another note here is that kmix was not always showing the webcam mic. Sometimes it showed unplug events without me actually touching the camera. Thus the webcam mic became unmanageble with it. Thus alsamixer was my friend.

Links:

Posted in dir: /articles/
Tags: guvcview Linux webcam

Connecting to IBM Informix database from Linux

Posted: Fri, 29 Apr 2011 16:29:50 +0300
Author: Делян Кръстев

I've needed to connect to an IBM Informix database recently. Informix is not so popular database software and getting a working connection to it did not work right away by simply following the documentation(especially via ODBC). So lets write this down for future reference.

I've got working connections to the database via 3 different ways:

  • Using JDBC
  • Using "Informix Connect" (an Informix client library similar to Oracle OCI)
  • Using ODBC

JDBC

JDBC connection worked flawlessly. It was just a matter of placing the Informix JDBC driver in the classpath and specifying the right connection string and login credentials. The connection string looks like:

jdbc:informix-sqli://10.10.10.10:1526/testdb:INFORMIXSERVER=ol_hostname

Informix Connect

I've got this working from a perl script. This needed perl DBI and libdbd-informix-perl installed. I guess the libdbd-informix-perl is not compiled in a flexible way since the dynamic library contained hard referenced paths:

root@work:/# ldd /usr/lib/perl5/auto/DBD/Informix/Informix.so
    linux-gate.so.1 =>  (0xb776f000)
    /opt/informix/lib/libifsql.so => not found
    /opt/informix/lib/libifasf.so (0xb7713000)
    /opt/informix/lib/libifgen.so => not found
    /opt/informix/lib/libifos.so => not found
    /opt/informix/lib/libifgls.so => not found
    libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb76e4000)
    libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb759e000)
    libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7577000)
    libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb7573000)
    libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb7541000)
    /lib/ld-linux.so.2 (0xb7770000)
    /opt/informix/lib/libifglx.so => not found

So if you install the Informix connect client in some other location(as I did) you might need to create the necessary symlinks. It might also be an option to get "DBD Informix" from CPAN and build it yourself.

The test perl script looked like:

#!/usr/bin/perl
use warnings;
use strict;

use DBI;

$ENV{'INFORMIXDIR'} = '/opt/IBM/informix';
$ENV{'INFORMIXSERVER'} = 'ol_hostname';


my $dbh = DBI->connect('dbi:Informix:DS_NAME', 'user', 'password');
my @list = $dbh->func('_tables');
print join("\n", @list);
print "\n";

You also need to describe the "DS_NAME" in /opt/IBM/informix/etc/sqlhosts file. It should look like:

ol_hostname        olsoctcp 10.10.10.10     1526

ODBC

ODBC was hardest to get right since it produced weird error messages and there were no useful recourses on the net which described the errors. In order to get it working you will need the unixodbc package. I've first tried using the graphical configuration tool ODBCConfig provided in unixodbc-bin but this failed miserably. I guess this was due to a missing library in "Informix Connect" with ODBC parameters description.

In order to get ODBC working you have to configure /opt/IBM/informix/etc/sqlhosts as shown above and then edit the files /opt/IBM/informix/etc/odbcinst.ini and /opt/IBM/informix/etc/odbc.ini . I've copied the ini file over the config files of the unixodbc package - /etc/odbcinst.ini and /etc/odbc.init and made the necessary adjustments.

odbcinst.ini:

[ODBC Drivers]
Informix=Installed

[Informix]
Driver=/opt/IBM/informix/lib/cli/iclit09b.so
Setup=/opt/IBM/informix/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y

odbc.ini:

[ODBC Data Sources]
DSN_NAME=Informix

[DSN_NAME]
Description=Informix
Driver=/opt/informix/lib/cli/iclit09b.so
Database=DBNAME
LogonID=USERNAME
pwd=PASSWORD
Servername=ol_HOSTNAME
CursorBehavior=0
CLIENT_LOCALE=en_US.8859-1
DB_LOCALE=en_US.819
TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so
;
; UNICODE connection Section
;

[ODBC]
;uncomment the below line for UNICODE connection
UNICODE=UCS-4
;
; Trace file Section
;
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/opt/IBM/informix
TRACEDLL=idmrs09a.so

At first the config files were not actually picked up. This was not obvious at all from the error messages, so I had to do a good amount of strace-ing until I was able to figure it out. So the solution was to have:

export ODBCINI=/etc/odbc.ini

May be you will not have this problem if you place the settings in ~/.odbc.ini as this was searched too.

The next problem I had was that I was trying to get the CLIENT_LOCALE to be as my terminal to en_US.UTF-8. The error message was still ridiculous:

kernel@work:~$ isql DS_NAME
[ISQL]ERROR: Could not SQLConnect

I had to use strace once again, and saw that the referred resource files were not found. The solution was to change the client locale to something supported:

CLIENT_LOCALE=en_US.8859-1

Then I was able to use isql to connect to the Informix DB host and issue queries.

Posted in dir: /articles/
Tags: Informix

Как да проверим дали работи добре климатика вкъщи

Posted: Thu, 19 Aug 2010 15:53:55 +0300
Author: Делян Кръстев

Наскоро си монтирах климатика, и виках да го заредят с фреон. Реших да проверя дали работи добре, и се зачетох по темата.

Климатика се пуска да работи на най-висока / най-ниска температура и вентилатора се пуска на най-силна степен.

Измерва се входящата температурата на въздуха във вътрешното тяло (Твх). Измерва се изходящата температурата на въздуха от вътрешното тяло (Тизх). Взима се максималния въздушен дебит(Д) на вътрешното тяло в м3/час (може да се види от етикета отстрани на тялото, или от спесификацията на климатика).

Капацитета на охлаждане/отопление на климатика във ватове е:

0,34 * Д * abs(Твх - Тизх)

Ако искате да го получите в BTU (british termal units):

1 watt = 3.41 BTU

Добре е да имате предвид, че за да работи на пълна мощност един инверторен климатик трябва да има достатъчна температурна разлика м/у зададената и температурата в помещението.

Формулата е валидна при температура в помещението около 20 градуса, и влажност 40%. При по-ниски температури коефициента (0,34) расте, а при по-високи пада.

Вземете предвид, и че мощността обикновено се дава като минимална, номинална и максимална. В зависимост от температурите, влажност, надморска височина и редица други фактори климатика не винаги ще успее да работи да работи на "пълна" мощност.

Добре е термометъра, който използвате да е с достатъчно бързодействие. Аз се спрях на спиртен такъв. Имам и два аналогови със стрелки, но отчитат твърде бавно.

Тестовета на моя климатик показаха: При външна температура 31 градуса, измерих 27 градуса Твх и 14 градуса Тизх. Дебита му е 570 м3/ч, и се получава:

0,34 * 570 * 13 = 2519,4 W
3.41 * 2.519,4 = 8591,154 BTU

което е близко до номиналната мощност. Изчислението ми е грубо, и не отчита промяната на коефициента.

Температурата отчетох като поставих термометъра в/у вътрешното тяло, и непосредствено пред изходящия въздух.

Оставете и време 5-10 минути след включване на климатика за навлизане в норамлен работен режим.

Ето и спесификациите на моя климатик - Hitachi RAS/RAC E10H2:

Величина                                               | Стойност
----------------------------------------------------------------------
Капацитет на охлаждане (мин./номинален/макс.) - BTU    | 3071 / 8533 / 10587
Капацитет на отопление (мин./номинален/макс.) - BTU    | 3071 / 11608 / 15020
Капацитет на охлаждане (мин./номинален/макс.) - KW     | 0,900 / 2,501 / 3,103
Капацитет на отопление (мин./номинален/макс.) - KW     | 0,900 / 3,402 / 4,402
Консумирана енергия при охлаждане - KW                 | 0,155 / 0,700 / 1,290
Консумирана енергия при отопление - KW                 | 0,115 / 0,880 / 1,250
EER - Коефициент на енергийна ефективност (охлаждане)  | 3.57
COP - Коефициент на производителност (отопление)       | 3.87
Клас на енергийна ефективност (охлаждане/отопление)    | A/A
Ниво на шум вътрешно тяло - dB                         | 20 / 26 / 32 / 38
Ниво на шум външно тяло - dB                           | 46
Ниво на изсушаване на въздуха - L/h                    | 1.4
Въздушен поток вътрешно тяло - m3/min                  | 9.5
Фреон                                                  | R410a
Размери вътрешно тяло (В/Ш/Д) - mm                     | 780x280x215
Размери външно тяло (В/Ш/Д) - mm                       | 700x505x258
Тегло вътрешно тяло - kg                               | 9.5
Тегло външно тяло - kg                                 | 27

Източници:

Posted in dir: /articles/
Page 1 of 2 (13 articles found)
1 2
All tags SiteMap Owner Cookies policy [Atom Feed]