{"id":128,"date":"2005-07-23T19:20:14","date_gmt":"2005-07-23T19:20:14","guid":{"rendered":"https:\/\/143-42-55-146.ip.linodeusercontent.com\/?p=128"},"modified":"2005-07-23T19:20:14","modified_gmt":"2005-07-23T19:20:14","slug":"ucetnictvi-pro-linux","status":"publish","type":"post","link":"https:\/\/nax.cz\/?p=128","title":{"rendered":"\u0102\u009a\u00c4\u008cETNICTV\u0102\u008d PRO LINUX"},"content":{"rendered":"

Tak mne tu po velmi dlouh\u0102\u0160 dob\u00c4\u009b zase m\u0102\u0104te. Kone\u00c4\u008dn\u00c4\u009b jsem se zase dostal k tomu si sem n\u00c4\u009bco mal\u0102\u0160ho poznamenat. Nejd\u0139\u0099\u0102\u00adv jsem m\u00c4\u009bl spoustu povinnost\u0102\u00ad ve \u0139\u0104kole, pak jsem zase m\u00c4\u009bl spoustu povinnost\u0102\u00ad v pr\u0102\u0104ci a p\u0139\u0099i tom mi nefungovala ve FreeBSD (po upgradu na nestabiln\u0102\u00ad v\u00c4\u009btev 6-CURRENT) a tak jsem si sem netroufl d\u0102\u0104t nic, co bych alespo\u0139\u0088 neprojel n\u00c4\u009bjak\u0102\u02ddm spell\u00c4\u008dekrem (zdrav\u0102\u00adm kipa \ud83d\ude09<\/p>\n

Nicm\u0102\u0160n\u00c4\u009b te\u00c4\u008f jsem byl okolnostmi donucen rozb\u00c4\u009bhnout n\u00c4\u009bjak\u0102\u0160 \u0102\u015f\u00c4\u008detnictv\u0102\u00ad (na p\u0139\u0099\u0102\u0104n\u0102\u00ad sv\u0102\u0160ho \u0139\u0104\u0102\u0160fa jsem se stal pl\u0102\u0104tem DPH a tedy u\u0139\u017e se neobejdu s pouh\u0102\u02ddm web vystavova\u00c4\u008dem faktur) a jedin\u0102\u0160 pou\u0139\u017eiteln\u0102\u0160 \u0102\u015f\u00c4\u008detnictv\u0102\u00ad pro linux je honeycalc<\/a>. Samoz\u0139\u0099ejm\u00c4\u009b jsem ne\u00c4\u008dekal, \u0139\u017ee bych nalezl n\u00c4\u009bco opensource (i kdy\u0139\u017e mo\u0139\u017en\u0102\u02dd kdybychom \u0139\u017eili ve v\u00c4\u009bt\u0139\u0104\u0102\u00ad zemi, kdo v\u0102\u00ad), ale \u00c4\u008dekal jsem \u0139\u017ee alespo\u0139\u0088 najdu pro linux n\u00c4\u009bco co bude zvl\u0102\u0104dat jednoduchou da\u0139\u0088ovou evidenci a p\u0139\u0099itom to bude um\u00c4\u009bt tisknout formul\u0102\u0104\u0139\u0099e pro finan\u00c4\u008d\u0102\u0104k.<\/p>\n

HoneyCalc je bohu\u0139\u017eel, ale podvojn\u0102\u0160 \u0102\u015f\u00c4\u008detnict\u0102\u00ad, co\u0139\u017e n\u00c4\u009bkte\u0139\u0099\u0102\u00ad tvrd\u0102\u00ad, \u0139\u017ee je zbyte\u00c4\u008dn\u00c4\u009b slo\u0139\u017eit\u0102\u0160. No nev\u0102\u00adm, asi v tom chv\u0102\u00adli zkus\u0102\u00adm \u0102\u015f\u00c4\u008dtovat a pak se uvid\u0102\u00ad. Nicm\u0102\u0160n\u00c4\u009b to, \u0139\u017ee se jedn\u0102\u0104 o komer\u00c4\u008dn\u0102\u00ad software sebou nese jist\u0102\u0104 \u0102\u015fskal\u0102\u00ad, kter\u0102\u0160 jsem musel vy\u0139\u0099e\u0139\u0104it. T\u0102\u00adm prvn\u0102\u00adm byla \u0139\u0099ekl bych docela nedostate\u00c4\u008dn\u0102\u0104 dokumentace. Na webu maj\u0102\u00ad m\u0102\u00adsto instalace p\u0102\u0104r screenshot\u0139\u017b a velice jednoduchou\u00c4\u008dk\u0102\u02dd koment\u0102\u0104\u0139\u0099. Nav\u0102\u00adc se vztahuj\u0102\u00adc\u0102\u00ad jen k ur\u00c4\u008dit\u0102\u0160 verzi (nikde jsem ale nena\u0139\u0104el ke kter\u0102\u0160!) postgresu<\/a>, kterou tohle \u0102\u015f\u00c4\u008detnictv\u0102\u00ad pou\u0139\u017e\u0102\u00adv\u0102\u0104 pro ukl\u0102\u0104d\u0102\u0104n\u0102\u00ad dat. <\/p>\n

To \u0139\u017ee data jsou ulo\u0139\u017eena v postgresu je bezesporu kladn\u0102\u0104 vlastnost, u\u0139\u017e k\u0139\u017bli t\u0139\u0099eba import\u0139\u017bm a export\u0139\u017bm dat, stabilit\u00c4\u009b a z\u0102\u0104lohovatelnosti (puls je\u0139\u0104t\u00c4\u009b distributivita a multiu\u0139\u017eivatelskost klient\/server architektury, kterou ale j\u0102\u0104 asi p\u0139\u0099\u0102\u00adli\u0139\u0104 nevyu\u0139\u017eiju). Probl\u0102\u0160m ale byl v tom, \u0139\u017ee jsem nikdy postgres nepou\u0139\u017e\u0102\u00adval (v\u0139\u017edy jsem si a\u0139\u017e do te\u00c4\u008f vysta\u00c4\u008dil s mysql) a tak jsem se docela na dlouho zarazil u hl\u0102\u0104\u0139\u0104ky honeycalcu, \u0139\u017ee „Datab\u0102\u0104ze nen\u0102\u00ad spu\u0139\u0104t\u00c4\u009bna!“ i kdy\u0139\u017e ve skute\u00c4\u008dnosti na serveru b\u00c4\u009b\u0139\u017eela, v konfigu jsem nastavil v\u0139\u0104e jak m\u00c4\u009blo b\u0102\u02ddt (podle t\u00c4\u009bch screenshot\u0139\u017b z dokumentace honeycalcku) a ostatn\u0102\u00ad potenci\u0102\u0104ln\u0102\u00ad probl\u0102\u0160my jsem tak\u0102\u0160 vy\u0139\u0099e\u0139\u0104il (te\u00c4\u008f m\u0102\u0104m na mysli firewall a tak).<\/p>\n

Nakonec jsem se za\u00c4\u008detl do dokumentace postgresu a zkusil jsme se p\u0139\u0099ipojit a vytvo\u0139\u0099it datab\u0102\u0104zi ru\u00c4\u008dn\u00c4\u009b a kdy\u0139\u017e jsem dostal hl\u0102\u0104\u0139\u0104ku:<\/p>\n

createdb: could not connect to database template1: FATAL:  user \"nax\" does not exist<\/pre>\n
bylo jasn\u0102\u0160, \u0139\u017ee nejd\u0139\u0099\u0102\u00adv mus\u0102\u00adm vytvo\u0139\u0099it usera, kter\u0102\u02dd se bude jmenovat stejn\u00c4\u009b jako user na stroji kde pust\u0102\u00adm GUI HoneyCalcu. Podle dokumentace postgresu<\/a> jsem tak u\u00c4\u008dinil a r\u0102\u0104zem bylo po probl\u0102\u0160mu s p\u0139\u0099ipojen\u0102\u00adm na datab\u0102\u0104zi.<\/p>\n
Jen\u0139\u017ee se vyskytl je\u0139\u0104t\u00c4\u009b dal\u0139\u0104\u0102\u00ad probl\u0102\u0160m. Kdy\u0139\u017e u\u0139\u017e jsem cht\u00c4\u009bl vystavit svoj\u0102\u00ad prvn\u0102\u00ad fakturu v HoneyCalcu, tak jsem zjistil, \u0139\u017ee kdy\u0139\u017e chci napsat \u00c4\u008desk\u0102\u02dd znak, tak se prost\u00c4\u009b nic nenap\u0102\u00ad\u0139\u0104e. Dal\u0139\u0104\u0102\u00adm experimentov\u0102\u0104n\u0102\u00ad jsem zjistil, \u0139\u017ee kdy\u0139\u017e vlo\u0139\u017e\u0102\u00adm n\u00c4\u009bjak\u0102\u02dd text p\u0139\u0099es schr\u0102\u0104nku, tak to m\u0102\u0104 probl\u0102\u0160my jen s h\u0102\u0104\u00c4\u008dky a vypad\u0102\u0104 to asi n\u0102\u0104sledovn\u00c4\u009b:<\/p>\n
m\u0102\u00adsto „\u0139\u00a0i\u0139\u0104lav\u0102\u02dd kon\u0102\u00ad\u00c4\u008dek“ se v kolonce programu kam jsem ten text pastnul objev\u0102\u00ad „\\u0160i\\u0161lav\u0102\u02dd kon\u0102\u00ad\\u010dek“.<\/p>\n
Docela dost se to podob\u0102\u0104 probl\u0102\u0160mu s LOCALES a po chv\u0102\u00adli b\u0102\u0104d\u0102\u0104n\u0102\u00ad jsem p\u0139\u0099i\u0139\u0104el na to, \u0139\u017ee kdy\u0139\u017e aplikaci neprovozuji s nastaven\u0102\u00adm LC_ALL=“cs_CZ.iso88592″, kter\u0102\u0160 norm\u0102\u0104ln\u00c4\u009b funguje pro zbytek syst\u0102\u0160mu a d\u0102\u00adky kter\u0102\u0160mu mimo jin\u0102\u0160 te\u00c4\u008f mohu te\u00c4\u008f \u00c4\u008desky ps\u0102\u0104t tenhle z\u0102\u0104znam, ale pust\u0102\u00adm to n\u0102\u0104sledovn\u00c4\u009b:<\/p>\n
LC_ALL=\"cs_CZ.utf8\" \/opt\/HoneyCalc2-Xft\/honeycalc<\/pre>\n
tak u\u0139\u017e \u00c4\u008de\u0139\u0104tina v HoneyCalcu funguje. BTW ne\u0139\u017e jsem na to dnes p\u0139\u0099i\u0139\u0104el, tak jsem se rozhodl otestovat jak\u0102\u02dd z\u0102\u0104jem maj\u0102\u00ad u X-Tronics o nov\u0102\u0160 z\u0102\u0104kazn\u0102\u00adky a napsal jsem jim email s podrobn\u0102\u02ddm popisem probl\u0102\u0160mu s \u00c4\u008de\u0139\u0104tinou. Dnes mi p\u0139\u0099i\u0139\u0104el email, \u0139\u017ee d\u0139\u017bvodem je, \u0139\u017ee jsem nainstaloval verzi pro SUSE a \u0139\u017ee moje gentoo nen\u0102\u00ad podporovan\u0102\u0160. Odpov\u00c4\u009b\u00c4\u008f jist\u00c4\u009b v komer\u00c4\u008dn\u0102\u00adm sv\u00c4\u009bt\u00c4\u009b akceptovateln\u0102\u0104, ale nejsem si jist\u0102\u02dd jestli v tom linuxov\u0102\u0160m.<\/p>\n","protected":false},"excerpt":{"rendered":"
Tak mne tu po velmi dlouh\u0102\u0160 dob\u00c4\u009b zase m\u0102\u0104te. Kone\u00c4\u008dn\u00c4\u009b jsem se zase dostal k tomu si sem n\u00c4\u009bco mal\u0102\u0160ho poznamenat. Nejd\u0139\u0099\u0102\u00adv jsem m\u00c4\u009bl spoustu povinnost\u0102\u00ad ve \u0139\u0104kole, pak jsem zase m\u00c4\u009bl spoustu povinnost\u0102\u00ad v pr\u0102\u0104ci a p\u0139\u0099i tom mi nefungovala ve FreeBSD (po upgradu na nestabiln\u0102\u00ad v\u00c4\u009btev 6-CURRENT) a tak jsem si sem netroufl […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-unix"],"_links":{"self":[{"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=128"}],"version-history":[{"count":0,"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/posts\/128\/revisions"}],"wp:attachment":[{"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}