Oracle – Linux Instalar instantclient

tar -xzvf oci8–2.1.8.tgz cd oci8–2.1.8 phpize ./configure — with-oci8=shared,instantclient,/usr/lib/oracle/12.2/client64/lib make sudo make install This will build and install the oci8 library which will be located (probably) in /usr/lib/php/20170718/oci8.so Now we should edit both these files… /etc/php/7.0/apache2/php.ini /etc/php/7.0/cli/php.ini Enable the oci8 extension by adding the line to each php.ini extension=/usr/lib/php/20170718/oci8.so /etc/apache2/envvars then add the following lines:
Continue reading Oracle – Linux Instalar instantclient

Python – KIVY Instalação

# Comandos para instalação do KIVY python -m pip install ffpyplayer python -m pip install –upgrade pip wheel setuptools python -m pip install docutils pygments pypiwin32 kivy.deps.sdl2 kivy.deps.glew python -m pip install kivy.deps.gstreamer python -m pip install kivy.deps.angle python -m pip install kivy

AD – Filtros DN

#Filtar usuario por grupo (&(objectClass=organizationalPerson)(|(memberOf=CN=Sistema_GLPI,OU=Sistemas,OU=Pinhais,DC=pinhais,DC=pr,DC=gov,DC=br))) #Filtar Grupo por grupo (&(objectClass=group)(|(memberOf=CN=Sistema_GLPI,OU=Sistemas,OU=Pinhais,DC=pinhais,DC=pr,DC=gov,DC=br)))

Linux – Comando para gerar certificado SSL

openssl req -new -newkey rsa:2048 -nodes -keyout pinhais.pr.gov.br.key -out pinhais.pr.gov.br.csr -subj “/C=BR/ST=PARANA/L=PINHAIS/O=MUNICIPIO PINHAIS/OU=TI/CN=pinhais.pr.gov.br” cat /root/certificados/pinhais.pr.gov.br.key /root/certificados/pinhais.pr.gov.br.crt > /root/certificados/pinhais.pr.gov.br.pem openssl pkcs12 -export -in /root/certificados/pinhais.pr.gov.br.crt -inkey /root/certificados/pinhais.pr.gov.br.key -certfile /root/certificados/pinhais.pr.gov.br.pem -out /root/certificados/pinhais.pr.gov.br.pfx     openssl pkcs12 -export -out /root/srvad01.pinhais.pr.gov.br.pfx -inkey /etc/letsencrypt/live/srvad01.pinhais.pr.gov.br/privkey.pem -in /etc/letsencrypt/live/srvad01.pinhais.pr.gov.br/fullchain.pem -passout pass:pinhais

Oracle – Consultas para verificar as datas

ALTER SESSION SET TIME_ZONE = ‘-03:00′; select to_char(CURRENT_TIMESTAMP,’DD MM YYYY HH24:MI:SS’),1 FROM DUAL union select to_char(SYSDATE ,’DD MM YYYY HH24:MI:SS’),2 from dual; SELECT SESSIONTIMEZONE , TZ_OFFSET(SESSIONTIMEZONE) FROM DUAL; SELECT SESSIONTIMEZONE FROM DUAL; select to_char (dbms_scheduler.stime, ‘DDMonYYYY/HH24:MI:SS @ TZR (TZD) [TZH:TZM]’) from dual; select to_char(sysdate, ‘DD-MM-YYYY HH24:MI:SS’) from dual; select to_char(sysdate, ‘yyyy-mm-dd’) || ‘T’ || to_char(sysdate,
Continue reading Oracle – Consultas para verificar as datas