Tuesday, July 4, 2017

How To Install Aeroo Report Odoo 8


Ubuntu 14.04 Aeroo Reports installation script:

To install Aeroo Reports and all related dependencies please do the following at a terminal in Ubuntu 14.04:

#0 cd /tmp
#1 sudo wget https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh
#2 sudo sh aeroo_install.sh

#3 Follow steps #31-37 in the "Ubuntu 14.04 Aeroo Reports installation method:" section below for installation instructions inside Odoo.

This script has a yes/no option for installing Odoo 8.0, and the Aeroo reports Odoo modules. If you have a pre-existing Odoo installation you can choose no when you get to the prompt for installing Odoo 8, and choose yes when you get to the option for installing the Aeroo Reports (aeroo_reports) modules for Odoo 8.

For installing the Aeroo Reports (aeroo_reports) modules this script assumes you already have the following directory:

/opt/odoo/custom

and

/opt/odoo/custom/addons


and it also assumes that your /etc/odoo-server.conf file includes the following directory in your addons_path line, for example:

addons_path = /opt/odoo/odoo-server/addons,/opt/odoo/custom/addons




Ubuntu 14.04 Aeroo Reports installation method:



Install Git:

#0 sudo apt-get install git



Install AerooLib:



#1 sudo apt-get install python-setuptools
#2 sudo apt-get install python-genshi python-cairo python-lxml
#3 sudo apt-get install libreoffice-script-provider-python
#4 sudo mkdir /opt/aeroo
#5 cd /opt/aeroo
#6 sudo git clone https://github.com/aeroo/aeroolib.git
#7 cd /opt/aeroo/aeroolib
#8 sudo python setup.py install

Create Init Script for OpenOffice (Headless Mode) - (see: https://www.odoo.com/forum/help-1/question/how-to-install-aeroo-reports-2780 for original post from Ahmet):

#9 sudo pico -w /etc/init.d/office
#10 Copy and paste this:

#!/bin/sh

/usr/bin/soffice --nologo --nofirststartwizard --headless --norestore --invisible "--accept=socket,host=localhost,port=8100,tcpNoDelay=1;urp;" &

#11 sudo chmod +x /etc/init.d/office
#12 sudo update-rc.d office defaults
#13 sudo /etc/init.d/office
#14 telnet localhost 8100
#15 You should see something like the following message (this means it has established a connection successfully):

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
e--'com.sun.star.bridge.XProtocolPropertiesUrpProtocolProperties.UrpProtocolPropertiesTidE--L


Install AerooDOCS (see: https://github.com/aeroo/aeroo_docs/wiki/Installation-example-for-Ubuntu-14.04-LTS for original post):

#16 sudo apt-get install python3-pip
#17 sudo pip3 install jsonrpc2 daemonize
#18 cd /opt/aeroo
#19 sudo git clone https://github.com/aeroo/aeroo_docs.git
#20 sudo python3 /opt/aeroo/aeroo_docs/aeroo-docs start -c /etc/aeroo-docs.conf
#21 sudo ln -s /opt/aeroo/aeroo_docs/aeroo-docs /etc/init.d/aeroo-docs
#22 sudo update-rc.d aeroo-docs defaults
#23 sudo service aeroo-docs start
[ ! ] If you encounter and error "Unable to lock on the pidfile while trying #16 just restart your server (sudo shutdown -r now) and try #16 again after reboot.


Install Odoo from Source:

#24 cd /tmp
#25 sudo wget https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh
#26 sudo sh odoo_install.sh
#27 restart the server (sudo shutdown -r now)


Install Aeroo Reports:

#28 sudo apt-get install python-cups
#29 cd /opt/odoo/custom
#30 sudo git clone -b master https://github.com/aeroo/aeroo_reports.git

After following the (above) steps in this guide you should have Aeroo Reports installed correctly on your server for Ubuntu 14.04 and Odoo 8.0. You'll just need to create a database and install the required Aeroo reports modules you need for that database.

[ ! ] Do not have aeroo_report_sample in your addons directory or you will get an error message when updating module list:
Warning! Unmet python dependencies! No module named cups

Install report_aeroo module in Odoo database:

#31 Go to Settings >> Users >> Administrator in the backend of Odoo
#32 Tick the box next to 'Technical Features' and Save, then refresh your browser window.
#33 Go to Settings >> Update Modules List > Update
#34 Go to Settings >> Local Modules > Search for: Aeroo
#35 Install report_aeroo
#36 You'll be confronted with an installation wizard, click: Continue >> Choose Simple Authentication from the Authentication dropdown list, and add username and password: anonymous
[ ! ] You can change the username and password in: /etc/aeroo-docs.conf if required.
#37 Click Apply and Test. You should see the following message if it was successful:


Success! Connection to the DOCS service was successfully established and PDF convertion is working.

You now have a fully operational Aeroo Reports installation in Ubuntu 14.04. If for any reason this is not working for you please post back in the comments and explain the error message you are seeing.


Source : https://www.odoo.com/forum/help-1/question/8-0-how-can-i-install-the-official-aeroo-reports-alistek-for-odoo-version-8-solved-installation-script-76044
Read More

Monday, May 15, 2017

Cara Mengantisipasi dan Mencegah Penyebaran Virus Ransomware Wannacry dari Mikrotik

Tampilan Virus pada komputer


Salah satu kabar terheboh di dunia IT kali ini adalah beredarnya virus ransomware jenis Wannacry yang menyebar hampir ke 99 Negara termasuk Indonesia. Saking hebohnya Kominfo merilis Siaran Pers Tentang ini pada Tanggal 13 Mei 2017.





Apa sich sebenarnya Ransomware ini? Ransomware adalah salah satu jenis Malware (malicious software) yang masuk ke dalam sistem komputer dan melakukan penguncian/enkripsi pada seluruh file sehingga user komputer tidak bisa membuka file-file tersebut. 



Untuk mencegah terjadinya penyebaran virus ini, berikut ini beberapa langkah berikut:
  1. Cabut Kabel LAN/Wifi sehingga tidak terkoneksi ke Internet.
  2. Lakukan Backup Data. Data-data yang penting di backup ke penyimpan lain misalnya hardisk external.
  3. Update AntiVirus. Pastikan Anda menggunakan Antivirus yang paling update.
  4. Update security pada windows anda dengan install Patch MS17-010 yang dikeluarkan oleh microsoct. Lihat : https://technet.microsoft.com/en-us/library/security/ms17-010.aspx
  5. Jangan mengaktifkan fungsi macros
  6. Non aktifkan fungsi SMB v1
  7. Block 139/445 & 3389 Ports

Sesuai Judul posting, Antisipasi Virus Ransomware ini juga bisa dilakukan dari Mikrotik.
Pada dasarnya pencegahan dari mikrotik ini untuk melakukan pencegahan pada poin 7 yaitu dengan melakukan Block pada port 139,445 dan 3389


Caranya adalah sebagai berikut:


1. Setelah Login mikrotik via Winbox, Pilih IP>Firewall


2. Pada Tab Filter Rules tambah kan Rule Baru, Seperti gambar berikut


3. pada Tab Action Pilih seperti berikut, kemudian klik Apply.


4. Ulangi poin 2 dan 3 dengan protokol UDP 
5 Selesai

Semoga Komputer Anda Aman dari Serangan Virus Ransomware Wannacry ini.

Terima kasih dan semoga Cara Mengantisipasi dan Mencegah Penyebaran Virus Ransomeware Wannacry dari Mikrotik bermanfaat :)
Read More

Tuesday, September 20, 2016

Infografik Dimensi dan Spesifikasi Gambar Facebook Page dan Facebook Ads



Agar halaman facebook Anda terlihat cantik dan profesional, infografik dibawah ini mungkin bermanfaat bagi Anda. Berikut ini Dimensi gambar untuk Facebook Page dan Facebook Ads terbaru 2016.
source jonloomer.com

Read More

Wednesday, July 27, 2016

(NOTES) Menganalisis Performance Posgresql

Ini catatan berupa Query yang untuk menganalisis performa database Postgresql


## LONGEST TABLES


SELECT schemaname || '.' || relname as table, n_live_tup as num_rows
from pg_stat_user_tables
ORDER by n_live_tup DESC limit 10;


# BIGGEST TABLES

select nspname || '.' || relname as "table", pg_size_pretty(pg_total_relation_size(C.oid)) as "total_size"
from pg_class C left join pg_namespace N ON (N.oid = C.relnamespace)where nspname not in ('pg_catalog','information_schema')
and C.relkind <> 'i' and nspname !~ '^pg_toast'order by pg_total_relation_size(C.oid) desc limit 10;

# MOST READ TABLES

select schemaname || '.' || relname as table, heap_blks_read as disk_reads,heap_blks_hit as cache_reads,
heap_blks_read + heap_blks_hit as total_reads
from pg_statio_user_tables
order by heap_blks_read + heap_blks_hit DESC limit 15;



# MOST WRITTEN TABLES
select schemaname || '.' || relname as table,
seq_scan, idx_scan, idx_tup_fetch+seq_tup_read lines_read_total, n_tup_ins as num_insert, n_tup_upd as num_update,
n_tup_del as num_delete from pg_stat_user_tables order by n_tup_upd desc limit 10;
Read More

Tuesday, February 9, 2016

Cara membuat Multiple Account di Instagram

Cara membuat Multiple Account di Instagram
Multiple Account Instagram

Bagi Anda yang memiliki beberapa akun instagram, sekarang tidak perlu repot bolak-balik log in dan log out untuk bergantian menggunakan beberapa akun Instagram. Karena pada tanggal 8 Februari 2016, Instagram merilis fitur "Account Switching" pada blognya. Fitur ini memungkinkan anda yang memiliki beberapa akun instagram dapat mengelola beberapa akun sekaligus dalam 1 gadget. Ini sangat menguntungkan juga bagi anda yang berbisnis online melalui instagram.Fitur ini dapat digunakan pada gadget bersistem operasi Android dan iOS.

Untuk dapat menggunakan fitur ini sangat mudah sekali. 

Berikut ini cara membuat membuat multiple account di instagram:

1.Silahkan menuju menu profile setting (Tap pada pojok kanan atas). Lihat gambar berikut pada kotak merah.

Cara membuat Multiple Account di Instagram - Profile Setting

2.lalu silahkan pilih Add Account untuk menambah akun lainnya.
Cara membuat Multiple Account di Instagram - Add Account

3.kemudian masukkan username dan password akun instagram lain Anda.
4. Selesai. Anda telah berhasil membuat multiple account di instagram Anda.

Untuk beralih ke akun lainnya silahkan tap pada pojok kiri atas, disitu ada pilihan akun-akun anda, Anda juga dapat menambahkan lagi beberapa akun Anda.

Cara membuat Multiple Account di Instagram - Switch Account

Sekian sharing tentang membuat multiple account di Instagram.
Semoga bermanfaat. :)
Read More