It is short description of our approach to fast upgrade of Omnitracker with 800GB database. The initial configuration was not so obvious as you could think: Linux cluster with Oracle DB 11.2 Windows server 2012 – CPU with 1 core and 16GB RAM Omnitracker 10.0.100 It was working fine for almost last 10 years withoutWięcej oOmnitracker upgrade – from antique to modernity[…]
This is continuation of story, which started last year in March. For following months we were fighting, fixing and adjusting this interface. Here are some more issues which should have been considered at the beginning of this project, but everybody knows that the wisest you are after the facts;): there should be a mapping betweenWięcej oOmnitracker – integration with ServiceNow – last words[…]
This year was very bad for me. Lots of fear, uncertainty, overhours, rush. From the work perspective: participtaing in two dead-ends project rare oportunity of work with so called professionals from international companies (many of them with more than 10 years of IT experience): Project manager – her best quotes: „I don’t know”, „I don’tWięcej oYear 2020 – summary[…]
Here is short description of what I was doing at work among other things for last 10 days. The idea was simple – fix Linux cluster, which crashed after switching to other node. This cluster consists only of two nodes with following software running on: Apache webserver postgreSQL ActianX client HVR After reviewing this installationWięcej oCentos cluster with HVR and Actian DB[…]
After installation of HomeAssistant on RaspberryPI Zero using this tutorial: https://www.home-assistant.io/hassio/installation using Virtual appliance, I have installed following Addons: „SSH&Terminal” „Samba share” Afterwards I needed to create my own Addon as it was shown in this Addon for MariaDB: https://github.com/home-assistant/hassio-addons/tree/master/mariadb Following this tutorial : https://developers.home-assistant.io/docs/add-ons/tutorial/ I have created my own Addon for ActianZen. The clueWięcej oSmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant[…]
Our „SmartHome” installation will consist of following software: HomeAssistant as virtual appliance on RaspberryPi ActianZen as database engine with database located on externaly connected hardrive (which was reused from one of our laptops ;)) configuration files of HomeAssistant will be also stored on that external hardrive – just in case backups will be done eitherWięcej oSmartHome – software[…]
A oto wpis autorstwa mojego męża: No cóż, nie jest dla nikogo tajemnicą, że w obecnym czasie rządzi nami na równi z politykami koronawirus. W moim przypadku oznaczało to zesłanie na home office. Pracuję z domu już od połowy marca. Prawdę mówiąc do czasu mojego zesłania miałem możliwość pracy z domu, ale nie korzystałem zWięcej oHome office – pierwsza perspektywa[…]
Robot was built and we were wandering around home thinking what challange could be next to get more familiar with IoT and how to use RaspberryPI. I have watched several webinars about usage of IoT and technologies around that. The most interesting was the one about technologies used in Azure Cloud lead by chmurowisko.pl. ForWięcej oSmartHome – new idea[…]
A to kolejny wpis mojego męża: Zacznijmy od tego – czym jest pi hole? Pi hole to prywatny DNS z opcją filtrowania adresów kojarzonych z reklamami. Po co to komu w czasach AdBlocka? Otóż adblock nie jest niestety doskonały – po pierwsze jest wykrywany przez różne strony, które potem serwują nam żebrozasłonę z tekstem “przecieżWięcej oPi hole – blokowanie reklam w Twoim domu.[…]
Here is magic query to extract all attachments from Omnitracker and their physical storage. select request, 'path_to_your_attachments\’+substring(filename_on_disk,1,2)+’\’+ substring(filename_on_disk,3,2)+’\’+ substring(filename_on_disk,5,2)+’\’+filename_on_disk+’.’+ substring(orig_name,len(orig_name)-2,3) as fileOnDisk, orig_name from ( SELECT [id], CONVERT(varchar(MAX),CONVERT(VARBINARY(8),id),2) as filename_on_disk ,[request] ,[orig_name] FROM [Attachment] where request in (617674,760232,…))a requests_id can be retrieved from this query: select request from UserFields1 where f19_titel=”your title of Incident/RFC/Problem”