http://wiki.objclt.ca/wiki/api.php?action=feedcontributions&feedformat=atom&user=Nicolas+Rollin
Objectif Client Inc - User contributions [en]
2026-04-28T10:38:34Z
User contributions
MediaWiki 1.38.2
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=855
3D Printer
2017-08-08T05:48:49Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
<br />
<br />
* Power<br />
** [[https://www.banggood.com/250V-15A-AC-3-in-1-Fuse-Power-Supply-Socket-Connector-Rocker-Switch-p-1145927.html Switch]]<br />
** [[https://www.banggood.com/3D-Printer-Parts-General-Add-on-Heated-Bed-Power-Expansion-Module-High-Power-For-Chitu-Motherboard-p-1086965.html?p=011020874661201411LK Heated Bed Power Expansion Module]]<br />
<br />
* Printing Area<br />
** [[https://www.banggood.com/5pcs-220x220mm-Plastic-Hot-Bed-Stickers-For-3D-Printer-Wanhao-i3-p-1158028.html?p=011020874661201411LK Plastic Hot Bed Sticker]]<br />
*** Or <br />
** [[https://www.banggood.com/3D-Printer-Heating-Bed-Reprap-Toughened-Glass-Plate-200-213mm-p-1003377.html?p=011020874661201411LK Heating Bed Reprap Toughened Glass Plate]]<br />
<br />
<br />
* Spare part <br />
** [[https://www.banggood.com/5M-2GT-6mm-Rubber-Opening-Belt-S2M-GT2-Belt-For-3D-Printer-p-959254.html?p=011020874661201411LK Belt S2M GT2 Belt For 3D Printer]]<br />
<br />
<br />
* Improvement:<br />
** LJ18A3-8-Z/BX-5V Captor Autoleveling <br />
** [[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
** [[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
[[File:Exemple.jpg]]<br />
<br />
==Firmware==<br />
<br />
* Marlin-SkyNet3D-Rel2.3.3<br />
* Arduino IDE 1.8.2<br />
** Board Anet V1.0<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=853
3D Printer
2017-08-08T05:05:05Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
<br />
<br />
* Power<br />
** [[https://www.banggood.com/250V-15A-AC-3-in-1-Fuse-Power-Supply-Socket-Connector-Rocker-Switch-p-1145927.html Switch]]<br />
** [[https://www.banggood.com/3D-Printer-Parts-General-Add-on-Heated-Bed-Power-Expansion-Module-High-Power-For-Chitu-Motherboard-p-1086965.html?p=011020874661201411LK Heated Bed Power Expansion Module]]<br />
<br />
* Printing Area<br />
** [[https://www.banggood.com/5pcs-220x220mm-Plastic-Hot-Bed-Stickers-For-3D-Printer-Wanhao-i3-p-1158028.html?p=011020874661201411LK Plastic Hot Bed Sticker]]<br />
*** Or <br />
** [[https://www.banggood.com/3D-Printer-Heating-Bed-Reprap-Toughened-Glass-Plate-200-213mm-p-1003377.html?p=011020874661201411LK Heating Bed Reprap Toughened Glass Plate]]<br />
*** or<br />
** [[ <br />
<br />
* Spare part <br />
** [[https://www.banggood.com/5M-2GT-6mm-Rubber-Opening-Belt-S2M-GT2-Belt-For-3D-Printer-p-959254.html?p=011020874661201411LK Belt S2M GT2 Belt For 3D Printer]]<br />
<br />
<br />
* Improvement:<br />
** LJ18A3-8-Z/BX-5V Captor Autoleveling <br />
** [[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
** [[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
==Firmware==<br />
<br />
* Marlin-SkyNet3D-Rel2.3.3<br />
* Arduino IDE 1.8.2<br />
** Board Anet V1.0<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=852
3D Printer
2017-08-08T04:58:02Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
<br />
<br />
* Power<br />
** [[https://www.banggood.com/250V-15A-AC-3-in-1-Fuse-Power-Supply-Socket-Connector-Rocker-Switch-p-1145927.html Switch]]<br />
** [[https://www.banggood.com/3D-Printer-Parts-General-Add-on-Heated-Bed-Power-Expansion-Module-High-Power-For-Chitu-Motherboard-p-1086965.html?p=011020874661201411LK Heated Bed Power Expansion Module]]<br />
<br />
* Printing Area<br />
** [[https://www.banggood.com/5pcs-220x220mm-Plastic-Hot-Bed-Stickers-For-3D-Printer-Wanhao-i3-p-1158028.html?p=011020874661201411LK Plastic Hot Bed Sticker]]<br />
*** Or <br />
** [[https://www.banggood.com/3D-Printer-Heating-Bed-Reprap-Toughened-Glass-Plate-200-213mm-p-1003377.html?p=011020874661201411LK Heating Bed Reprap Toughened Glass Plate]]<br />
*** or<br />
** [[ <br />
<br />
* Spare part <br />
** [[https://www.banggood.com/5M-2GT-6mm-Rubber-Opening-Belt-S2M-GT2-Belt-For-3D-Printer-p-959254.html?p=011020874661201411LK Belt S2M GT2 Belt For 3D Printer]]<br />
<br />
<br />
* Improvement:<br />
<br />
* [[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
* [[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
==Firmware==<br />
<br />
* Marlin-SkyNet3D-Rel2.3.3<br />
* Arduino IDE 1.8.2<br />
** Board Anet V1.0<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=851
3D Printer
2017-08-08T04:56:42Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
<br />
* Heated Bed Power Expansion Module<br />
[[https://www.banggood.com/3D-Printer-Parts-General-Add-on-Heated-Bed-Power-Expansion-Module-High-Power-For-Chitu-Motherboard-p-1086965.html?p=011020874661201411LK Protect the Board from Hot Bed]]<br />
<br />
* Power<br />
** [[https://www.banggood.com/250V-15A-AC-3-in-1-Fuse-Power-Supply-Socket-Connector-Rocker-Switch-p-1145927.html Switch]]<br />
<br />
* Printing Area<br />
** [[https://www.banggood.com/5pcs-220x220mm-Plastic-Hot-Bed-Stickers-For-3D-Printer-Wanhao-i3-p-1158028.html?p=011020874661201411LK Plastic Hot Bed Sticker]]<br />
*** Or <br />
** [[https://www.banggood.com/3D-Printer-Heating-Bed-Reprap-Toughened-Glass-Plate-200-213mm-p-1003377.html?p=011020874661201411LK Heating Bed Reprap Toughened Glass Plate]]<br />
*** or<br />
** [[ <br />
<br />
* Spare part <br />
** [[https://www.banggood.com/5M-2GT-6mm-Rubber-Opening-Belt-S2M-GT2-Belt-For-3D-Printer-p-959254.html?p=011020874661201411LK Belt S2M GT2 Belt For 3D Printer]]<br />
<br />
<br />
* Improvement:<br />
<br />
* [[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
* [[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
==Firmware==<br />
<br />
* Marlin-SkyNet3D-Rel2.3.3<br />
* Arduino IDE 1.8.2<br />
** Board Anet V1.0<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=850
3D Printer
2017-08-08T04:56:15Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
<br />
* Heated Bed Power Expansion Module<br />
[[https://www.banggood.com/3D-Printer-Parts-General-Add-on-Heated-Bed-Power-Expansion-Module-High-Power-For-Chitu-Motherboard-p-1086965.html?p=011020874661201411LK Protect the Board from Hot Bed]]<br />
<br />
* Power<br />
** [[https://www.banggood.com/250V-15A-AC-3-in-1-Fuse-Power-Supply-Socket-Connector-Rocker-Switch-p-1145927.html Switch]]<br />
<br />
* Printing Area<br />
** [[https://www.banggood.com/5pcs-220x220mm-Plastic-Hot-Bed-Stickers-For-3D-Printer-Wanhao-i3-p-1158028.html?p=011020874661201411LK Plastic Hot Bed Sticker]]<br />
*** Or <br />
** [[https://www.banggood.com/3D-Printer-Heating-Bed-Reprap-Toughened-Glass-Plate-200-213mm-p-1003377.html?p=011020874661201411LK Heating Bed Reprap Toughened Glass Plate]]<br />
*** or<br />
** [[ <br />
<br />
* Spare part <br />
** [[https://www.banggood.com/5M-2GT-6mm-Rubber-Opening-Belt-S2M-GT2-Belt-For-3D-Printer-p-959254.html?p=011020874661201411LK Belt S2M GT2 Belt For 3D Printer]]<br />
<br />
<br />
* Improvement:<br />
<br />
[[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
[[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
==Firmware==<br />
<br />
* Marlin-SkyNet3D-Rel2.3.3<br />
* Arduino IDE 1.8.2<br />
** Board Anet V1.0<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=849
3D Printer
2017-08-08T04:43:33Z
<p>Nicolas Rollin: </p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
* Improvement:<br />
<br />
[[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
[[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
==Firmware==<br />
<br />
* Marlin-SkyNet3D-Rel2.3.3<br />
* Arduino IDE 1.8.2<br />
** Board Anet V1.0<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=848
3D Printer
2017-08-07T03:52:28Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
* Improvement:<br />
<br />
[[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
[[https://www.thingiverse.com/thing:1672959 Corner]]<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=847
3D Printer
2017-08-07T03:49:26Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
* Improvement:<br />
<br />
[[https://www.thingiverse.com/thing:2045010 Y Axis Rework]]<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=846
3D Printer
2017-08-07T03:41:05Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Overall, an excellent price-performance ratio. Relatively quickly to assemble. Good printing output, tested only with PLA so far. Easy to use software.<br />
* Improvement:<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=845
3D Printer
2017-08-07T03:37:14Z
<p>Nicolas Rollin: /* Hardware */</p>
<hr />
<div>==Hardware==<br />
<br />
Anet A8 Desktop 3D Printer<br />
<br />
* Cheap <br />
* Improvement:<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=MediaWiki:SidebarTree&diff=844
MediaWiki:SidebarTree
2017-08-07T02:35:26Z
<p>Nicolas Rollin: </p>
<hr />
<div>{{#tree:root=Side Barre Menu |<br />
* Media Wiki<br />
** [[Quicklinksmediawiki#Start_with_MediaWiki|Start With Wiki]]<br />
** [[Demo Page|Demo Page]]<br />
** Navigation<br />
*** [[mainpage|mainpage-description]]<br />
*** [[recentchanges-url|recentchanges]]<br />
*** [[randompage-url|randompage]]<br />
*** [[helppage|help]]<br />
<br />
* Business<br />
** [[EntrepreneurShip | EntrepreneurShip]]<br />
<br />
* Office<br />
** [[LibreOffice | Libre and Open Office]]<br />
** [[MSOfficeOnline | Ms Office OnLine]]<br />
<br />
* CMS<br />
** [[Wordpress | Word Press]]<br />
** [[Tiki | Tiki]]<br />
<br />
* Erp<br />
** [[JdEdwards | JD Edwards]]<br />
** [[MSDynamics | Ms Dynamics]]<br />
** [[Odoo | Odoo (OpenErp)]]<br />
<br />
* Database<br />
** [[Mysql | MySql]]<br />
** [[Oracle_Database|Oracle]]<br />
** [[HQL | Hibernate]]<br />
** [[MongoDb | MongoDb]]<br />
** [[MsSql | MsSql]]<br />
<br />
* System Admin.<br />
** [[Linux|Linux]]<br />
** [[Unix Container|Container]]<br />
** [[KVM | KVM]]<br />
** [[Mail Server | Mail Server]]<br />
** [[Web Server | Web Server]]<br />
** [[Windows | Windows]]<br />
<br />
* Ldap<br />
** [[Ldap Server | Ldap Server]]<br />
<br />
* Code<br />
** [[Ruby|Ruby]]<br />
** [[Java_Spring_FrameWork | Spring FrameWork]]<br />
** [[Java_Spring_Roo| Roo]]<br />
** [[Grails_Framework| Grails]]<br />
** [[nodejs | node.js]]<br />
<br />
* IDE<br />
** [[Wavemaker | Wavemaker]]<br />
** [[Eclipse | Eclipse]]<br />
** [[NetBean | NetBean]]<br />
<br />
* Repositories<br />
** [[Githuh | Github]]<br />
** [[npm | npm]]<br />
<br />
* Hobby<br />
** [[Flight Controller | Flight Controller]]<br />
** [[Quad Frame | Quad Frame]]<br />
** [[Gps | Gps]]<br />
** [[OSD | OSD]]<br />
** [[CleanFlight | CleanFlight]]<br />
** [[Raspberrypi | Raspberrypi]]<br />
** [[3D Printer | 3D Printer]]<br />
** [[IOT | Iot]]<br />
<br />
}}</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=3D_Printer&diff=843
3D Printer
2017-08-07T02:33:01Z
<p>Nicolas Rollin: Created page with "==Hardware== ==SoftWare== ===Cura=== ===OctoPrint==="</p>
<hr />
<div>==Hardware==<br />
<br />
==SoftWare==<br />
<br />
===Cura===<br />
<br />
<br />
===OctoPrint===</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Raspberrypi&diff=704
Raspberrypi
2017-03-26T04:04:43Z
<p>Nicolas Rollin: /* Prepare the SD Card */</p>
<hr />
<div>==Download==<br />
Raspberry site [https://www.raspberrypi.org/downloads/ Raspberry]<br />
<br />
==Prepare the SD Card==<br />
<br />
Link [https://www.raspberrypi.org/documentation/installation/installing-images/linux.md linux command line]<br />
<br />
# Check the device name of the card and umount it<br />
<syntaxhighlight lang="bash"><br />
df -h<br />
umount /dev/sdX1<br />
</syntaxhighlight><br />
<br />
# Copy the image from the zip file on the card<br />
<br />
<syntaxhighlight lang="bash"><br />
unzip -p 2017-02-16-raspbian-jessie.zip | sudo dd of=/dev/sdX bs=4096 status=progress<br />
</syntaxhighlight></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Raspberrypi&diff=703
Raspberrypi
2017-03-26T03:02:49Z
<p>Nicolas Rollin: /* Prepare the SD Card */</p>
<hr />
<div>==Download==<br />
Raspberry site [https://www.raspberrypi.org/downloads/ Raspberry]<br />
<br />
==Prepare the SD Card==<br />
<br />
Link [https://www.raspberrypi.org/documentation/installation/installing-images/linux.md linux command line]<br />
<br />
<br />
<syntaxhighlight lang="bash"><br />
df -h<br />
umount /dev/sdX1<br />
unzip -p 2017-02-16-raspbian-jessie.zip | sudo dd of=/dev/sdX bs=4096 status=progress<br />
<br />
</syntaxhighlight></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Raspberrypi&diff=702
Raspberrypi
2017-03-26T02:52:10Z
<p>Nicolas Rollin: Created page with "==Download== Raspberry site [https://www.raspberrypi.org/downloads/ Raspberry] ==Prepare the SD Card== Link [https://www.raspberrypi.org/documentation/installation/installin..."</p>
<hr />
<div>==Download==<br />
Raspberry site [https://www.raspberrypi.org/downloads/ Raspberry]<br />
<br />
==Prepare the SD Card==<br />
<br />
Link [https://www.raspberrypi.org/documentation/installation/installing-images/linux.md linux coomand line]</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=MediaWiki:SidebarTree&diff=701
MediaWiki:SidebarTree
2017-03-26T02:46:45Z
<p>Nicolas Rollin: </p>
<hr />
<div>{{#tree:root=Side Barre Menu |<br />
* Media Wiki<br />
** [[Quicklinksmediawiki#Start_with_MediaWiki|Start With Wiki]]<br />
** [[Demo Page|Demo Page]]<br />
** Navigation<br />
*** [[mainpage|mainpage-description]]<br />
*** [[recentchanges-url|recentchanges]]<br />
*** [[randompage-url|randompage]]<br />
*** [[helppage|help]]<br />
<br />
* Business<br />
** [[EntrepreneurShip | EntrepreneurShip]]<br />
<br />
* Office<br />
** [[LibreOffice | Libre and Open Office]]<br />
** [[MSOfficeOnline | Ms Office OnLine]]<br />
<br />
* CMS<br />
** [[Wordpress | Word Press]]<br />
** [[Tiki | Tiki]]<br />
<br />
* Erp<br />
** [[JdEdwards | JD Edwards]]<br />
** [[MSDynamics | Ms Dynamics]]<br />
** [[Odoo | Odoo (OpenErp)]]<br />
<br />
* Database<br />
** [[Mysql | MySql]]<br />
** [[Oracle_Database|Oracle]]<br />
** [[HQL | Hibernate]]<br />
** [[MongoDb | MongoDb]]<br />
** [[MsSql | MsSql]]<br />
<br />
* System Admin.<br />
** [[Linux|Linux]]<br />
** [[Unix Container|Container]]<br />
** [[KVM | KVM]]<br />
** [[Mail Server | Mail Server]]<br />
** [[Web Server | Web Server]]<br />
** [[Windows | Windows]]<br />
<br />
* Ldap<br />
** [[Ldap Server | Ldap Server]]<br />
<br />
* Code<br />
** [[Ruby|Ruby]]<br />
** [[Java_Spring_FrameWork | Spring FrameWork]]<br />
** [[Java_Spring_Roo| Roo]]<br />
** [[Grails_Framework| Grails]]<br />
** [[nodejs | node.js]]<br />
<br />
* IDE<br />
** [[Wavemaker | Wavemaker]]<br />
** [[Eclipse | Eclipse]]<br />
** [[NetBean | NetBean]]<br />
<br />
* Repositories<br />
** [[Githuh | Github]]<br />
** [[npm | npm]]<br />
<br />
* Hobby<br />
** [[Flight Controller | Flight Controller]]<br />
** [[Quad Frame | Quad Frame]]<br />
** [[Gps | Gps]]<br />
** [[OSD | OSD]]<br />
** [[CleanFlight | CleanFlight]]<br />
** [[Raspberrypi | Raspberrypi]]<br />
<br />
}}</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=MediaWiki:SidebarTree&diff=700
MediaWiki:SidebarTree
2017-03-26T02:17:34Z
<p>Nicolas Rollin: </p>
<hr />
<div>{{#tree:root=Side Barre Menu |<br />
* Media Wiki<br />
** [[Quicklinksmediawiki#Start_with_MediaWiki|Start With Wiki]]<br />
** [[Demo Page|Demo Page]]<br />
** Navigation<br />
*** [[mainpage|mainpage-description]]<br />
*** [[recentchanges-url|recentchanges]]<br />
*** [[randompage-url|randompage]]<br />
*** [[helppage|help]]<br />
<br />
* Business<br />
** [[EntrepreneurShip | EntrepreneurShip]]<br />
<br />
* Office<br />
** [[LibreOffice | Libre and Open Office]]<br />
** [[MSOfficeOnline | Ms Office OnLine]]<br />
<br />
* CMS<br />
** [[Wordpress | Word Press]]<br />
** [[Tiki | Tiki]]<br />
<br />
* Erp<br />
** [[JdEdwards | JD Edwards]]<br />
** [[MSDynamics | Ms Dynamics]]<br />
** [[Odoo | Odoo (OpenErp)]]<br />
<br />
* Database<br />
** [[Mysql | MySql]]<br />
** [[Oracle_Database|Oracle]]<br />
** [[HQL | Hibernate]]<br />
** [[MongoDb | MongoDb]]<br />
** [[MsSql | MsSql]]<br />
<br />
* System Admin.<br />
** [[Linux|Linux]]<br />
** [[Unix Container|Container]]<br />
** [[KVM | KVM]]<br />
** [[Mail Server | Mail Server]]<br />
** [[Web Server | Web Server]]<br />
** [[Windows | Windows]]<br />
<br />
* Ldap<br />
** [[Ldap Server | Ldap Server]]<br />
<br />
* Code<br />
** [[Ruby|Ruby]]<br />
** [[Java_Spring_FrameWork | Spring FrameWork]]<br />
** [[Java_Spring_Roo| Roo]]<br />
** [[Grails_Framework| Grails]]<br />
** [[nodejs | node.js]]<br />
<br />
* IDE<br />
** [[Wavemaker | Wavemaker]]<br />
** [[Eclipse | Eclipse]]<br />
** [[NetBean | NetBean]]<br />
<br />
* Repositories<br />
** [[Githuh | Github]]<br />
** [[npm | npm]]<br />
<br />
* Hobby<br />
** [[Flight Controller | Flight Controller]]<br />
** [[Quad Frame | Quad Frame]]<br />
** [[Gps | Gps]]<br />
** [[OSD | OSD]]<br />
** [[CleanFlight | CleanFlight]]<br />
** [[raspberrypi | raspberrypi]]<br />
<br />
}}</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=699
Wordpress
2017-03-26T00:45:36Z
<p>Nicolas Rollin: /* Special Setup for Multiple Sites */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
# Download the file from: [https://wordpress.org/latest.tar.gz WordPress]<br />
# Uncompress latest file<br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
===Apache Setup===<br />
# Setup apache to access to that directory<br />
# <br />
<br />
===Special Setup for Multiple Sites===<br />
# Add the following lines into wp-config.php<br />
<syntaxhighlight lang="bash"><br />
/* Multisite */<br />
define('WP_ALLOW_MULTISITE', true);<br />
define('MULTISITE', true);<br />
define('SUBDOMAIN_INSTALL', true);<br />
define('DOMAIN_CURRENT_SITE', 'mydomain.com');<br />
define('PATH_CURRENT_SITE', '/');<br />
define('SITE_ID_CURRENT_SITE', 1);<br />
define('BLOG_ID_CURRENT_SITE', 1);<br />
<br />
define('ADMIN_COOKIE_PATH', '/');<br />
define('COOKIE_DOMAIN', '');<br />
define('COOKIEPATH', '');<br />
define('SITECOOKIEPATH', '');<br />
</syntaxhighlight><br />
<br />
# Special instruction configured in Apache or .htaccess<br />
<syntaxhighlight lang="bash"><br />
# BEGIN WordPress<br />
<IfModule mod_rewrite.c><br />
RewriteEngine On<br />
RewriteBase /<br />
RewriteRule ^index\.php$ - [L]<br />
<br />
# add a trailing slash to /wp-admin<br />
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]<br />
<br />
RewriteCond %{REQUEST_FILENAME} -f [OR]<br />
RewriteCond %{REQUEST_FILENAME} -d<br />
RewriteRule ^ - [L]<br />
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]<br />
RewriteRule ^(.*\.php)$ $1 [L]<br />
RewriteRule . index.php [L]<br />
</IfModule><br />
<br />
# END WordPress<br />
<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=698
Wordpress
2017-03-26T00:44:36Z
<p>Nicolas Rollin: /* Special Setup for Multiple Sites */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
# Download the file from: [https://wordpress.org/latest.tar.gz WordPress]<br />
# Uncompress latest file<br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
===Apache Setup===<br />
# Setup apache to access to that directory<br />
# <br />
<br />
===Special Setup for Multiple Sites===<br />
# Add the following line into wp-config.php<br />
<syntaxhighlight lang="bash"><br />
/* Multisite */<br />
define('WP_ALLOW_MULTISITE', true);<br />
define('MULTISITE', true);<br />
define('SUBDOMAIN_INSTALL', true);<br />
define('DOMAIN_CURRENT_SITE', 'mydomain.com');<br />
define('PATH_CURRENT_SITE', '/');<br />
define('SITE_ID_CURRENT_SITE', 1);<br />
define('BLOG_ID_CURRENT_SITE', 1);<br />
<br />
define('ADMIN_COOKIE_PATH', '/');<br />
define('COOKIE_DOMAIN', '');<br />
define('COOKIEPATH', '');<br />
define('SITECOOKIEPATH', '');<br />
</syntaxhighlight><br />
<br />
# Inusre to have the special instruction configured in Apache or .htaccess<br />
<syntaxhighlight lang="bash"><br />
# BEGIN WordPress<br />
<IfModule mod_rewrite.c><br />
RewriteEngine On<br />
RewriteBase /<br />
RewriteRule ^index\.php$ - [L]<br />
<br />
# add a trailing slash to /wp-admin<br />
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]<br />
<br />
RewriteCond %{REQUEST_FILENAME} -f [OR]<br />
RewriteCond %{REQUEST_FILENAME} -d<br />
RewriteRule ^ - [L]<br />
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]<br />
RewriteRule ^(.*\.php)$ $1 [L]<br />
RewriteRule . index.php [L]<br />
</IfModule><br />
<br />
# END WordPress<br />
<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=697
Wordpress
2017-03-26T00:43:46Z
<p>Nicolas Rollin: /* Special Setup for Multiple Site */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
# Download the file from: [https://wordpress.org/latest.tar.gz WordPress]<br />
# Uncompress latest file<br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
===Apache Setup===<br />
# Setup apache to access to that directory<br />
# <br />
<br />
===Special Setup for Multiple Sites===<br />
# Add the following line into wp-config.php<br />
<syntaxhighlight lang="bash"><br />
/* Multisite */<br />
define('WP_ALLOW_MULTISITE', true);<br />
define('MULTISITE', true);<br />
define('SUBDOMAIN_INSTALL', true);<br />
define('DOMAIN_CURRENT_SITE', 'segolenegras.com');<br />
define('PATH_CURRENT_SITE', '/');<br />
define('SITE_ID_CURRENT_SITE', 1);<br />
define('BLOG_ID_CURRENT_SITE', 1);<br />
<br />
define('ADMIN_COOKIE_PATH', '/');<br />
define('COOKIE_DOMAIN', '');<br />
define('COOKIEPATH', '');<br />
define('SITECOOKIEPATH', '');<br />
</syntaxhighlight><br />
<br />
# Inusre to have the special instruction configured in Apache or .htaccess<br />
<syntaxhighlight lang="bash"><br />
# BEGIN WordPress<br />
<IfModule mod_rewrite.c><br />
RewriteEngine On<br />
RewriteBase /<br />
RewriteRule ^index\.php$ - [L]<br />
<br />
# add a trailing slash to /wp-admin<br />
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]<br />
<br />
RewriteCond %{REQUEST_FILENAME} -f [OR]<br />
RewriteCond %{REQUEST_FILENAME} -d<br />
RewriteRule ^ - [L]<br />
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]<br />
RewriteRule ^(.*\.php)$ $1 [L]<br />
RewriteRule . index.php [L]<br />
</IfModule><br />
<br />
# END WordPress<br />
<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=696
Wordpress
2017-03-26T00:43:26Z
<p>Nicolas Rollin: /* Download */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
# Download the file from: [https://wordpress.org/latest.tar.gz WordPress]<br />
# Uncompress latest file<br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
===Apache Setup===<br />
# Setup apache to access to that directory<br />
# <br />
<br />
===Special Setup for Multiple Site===<br />
# Add the following line into wp-config.php<br />
<syntaxhighlight lang="bash"><br />
/* Multisite */<br />
define('WP_ALLOW_MULTISITE', true);<br />
define('MULTISITE', true);<br />
define('SUBDOMAIN_INSTALL', true);<br />
define('DOMAIN_CURRENT_SITE', 'segolenegras.com');<br />
define('PATH_CURRENT_SITE', '/');<br />
define('SITE_ID_CURRENT_SITE', 1);<br />
define('BLOG_ID_CURRENT_SITE', 1);<br />
<br />
define('ADMIN_COOKIE_PATH', '/');<br />
define('COOKIE_DOMAIN', '');<br />
define('COOKIEPATH', '');<br />
define('SITECOOKIEPATH', '');<br />
</syntaxhighlight><br />
<br />
# Inusre to have the special instruction configured in Apache or .htaccess<br />
<syntaxhighlight lang="bash"><br />
# BEGIN WordPress<br />
<IfModule mod_rewrite.c><br />
RewriteEngine On<br />
RewriteBase /<br />
RewriteRule ^index\.php$ - [L]<br />
<br />
# add a trailing slash to /wp-admin<br />
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]<br />
<br />
RewriteCond %{REQUEST_FILENAME} -f [OR]<br />
RewriteCond %{REQUEST_FILENAME} -d<br />
RewriteRule ^ - [L]<br />
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]<br />
RewriteRule ^(.*\.php)$ $1 [L]<br />
RewriteRule . index.php [L]<br />
</IfModule><br />
<br />
# END WordPress<br />
<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=695
Wordpress
2017-03-26T00:38:04Z
<p>Nicolas Rollin: /* Download */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
# Download the file from: [https://wordpress.org/latest.tar.gz WordPress]<br />
# Uncompress latest file<br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=694
Wordpress
2017-03-26T00:37:44Z
<p>Nicolas Rollin: /* Download */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
Download the file from: [https://wordpress.org/latest.tar.gz WordPress]<br />
uncompress latest file<br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=693
Wordpress
2017-03-26T00:37:04Z
<p>Nicolas Rollin: /* Download */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
[https://wordpress.org/latest.tar.gz WordPress]<br />
uncompress <br />
<syntaxhighlight lang="bash"><br />
tar -zxvf latest.tar.gz<br />
</syntaxhighlight><br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=692
Wordpress
2017-03-26T00:35:14Z
<p>Nicolas Rollin: /* Download */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
[https://wordpress.org/latest.tar.gz WordPress]<br />
uncompress tar -zxvf latest.tar.gz<br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Wordpress&diff=691
Wordpress
2017-03-26T00:33:45Z
<p>Nicolas Rollin: /* WorPress */</p>
<hr />
<div>==Installation==<br />
<br />
===Download===<br />
[https://wordpress.org/latest.tar.gz WordPress]<br />
<br />
==Plugin==<br />
===Social===<br />
* Facebook<br />
<br />
===SEO===<br />
* Google Analytics Dashboard for WP<br />
* WordPress SEO<br />
* WP-Piwik<br />
<br />
===Security===<br />
* Contact Form Maker<br />
* Limit Attempts<br />
* Wordfence Security<br />
* WP Security Audit Log<br />
<br />
===Locallization===<br />
* mqTranslate<br />
<br />
===Editor===<br />
* TinyMCE Advanced<br />
<br />
===Contact===<br />
* Contact Form Maker</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=690
Odoo 10
2017-03-26T00:21:17Z
<p>Nicolas Rollin: /* Application Configuration */</p>
<hr />
<div><br />
==Installation==<br />
<br />
===Prerequisite===<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
===Download from Github===<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
===Create log directory===<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
===Config file===<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
===Inti Script===<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Apache Proxy configuration===<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
=== Etherpad ===<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
==Additional Modules==<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
==Other==<br />
<br />
===Account Link===<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
==Application Configuration==<br />
# Enable debug mod (setting and under odoo-10.0 click on "Activate the developer mode") <br />
<br />
===Add Taxes on Invoice Report===<br />
# Setting -> Reports -> Reports and click on invoice in the list<br />
# Click on QWEB Views and select "report_invoice_document"<br />
# Add the following xml after the tag </div> line 115 and before the tag <p t-if="o.comment"><br />
<br />
<syntaxhighlight lang="xml"><br />
<div class="row" t-if="len(o.tax_line_ids) &gt; 1"><br />
<div class="col-xs-6"><br />
<table class="table table-condensed"><br />
<thead><br />
<tr><br />
<th>Tax</th><br />
<th class="text-right">Amount</th><br />
</tr><br />
</thead><br />
<tbody><br />
<tr t-foreach="o.tax_line_ids" t-as="t"><br />
<td><span t-field="t.tax_id.description"/></td><br />
<td class="text-right"><br />
<span t-field="t.amount" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: o.currency_id}"/><br />
</td><br />
</tr><br />
</tbody><br />
</table><br />
</div><br />
</div><br />
</syntaxhighlight><br />
<br />
===Add Taxe Id on invoice===<br />
# Accouting -> Taxe <br />
# Select the taxe applicable for you "GST + QST for sales"<br />
# Click on Edit<br />
# Click on the taxe name in the list "GST/TPS for sales - 5%"<br />
# Click on "Advance Option"<br />
# Update Label print on invoice</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=689
Odoo 10
2017-03-25T23:58:56Z
<p>Nicolas Rollin: /* Adding Taxes in Invoice Report */</p>
<hr />
<div><br />
==Installation==<br />
<br />
===Prerequisite===<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
===Download from Github===<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
===Create log directory===<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
===Config file===<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
===Inti Script===<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Apache Proxy configuration===<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
=== Etherpad ===<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
==Additional Modules==<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
==Other==<br />
<br />
===Account Link===<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
==Application Configuration==<br />
<br />
===Adding Taxes in Invoice Report===<br />
# Enable debug mod (setting and under odoo-10.0 click on "Activate the developer mode") <br />
# Setting -> Reports -> Reports and click on invoice in the list<br />
# Click on QWEB Views and select "report_invoice_document"<br />
# Add the following xml after the tag </div> line 115 and before the tag <p t-if="o.comment"><br />
<br />
<syntaxhighlight lang="xml"><br />
<div class="row" t-if="len(o.tax_line_ids) &gt; 1"><br />
<div class="col-xs-6"><br />
<table class="table table-condensed"><br />
<thead><br />
<tr><br />
<th>Tax</th><br />
<th class="text-right">Amount</th><br />
</tr><br />
</thead><br />
<tbody><br />
<tr t-foreach="o.tax_line_ids" t-as="t"><br />
<td><span t-field="t.tax_id.description"/></td><br />
<td class="text-right"><br />
<span t-field="t.amount" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: o.currency_id}"/><br />
</td><br />
</tr><br />
</tbody><br />
</table><br />
</div><br />
</div><br />
</syntaxhighlight></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=688
Odoo 10
2017-03-25T23:57:44Z
<p>Nicolas Rollin: </p>
<hr />
<div><br />
==Installation==<br />
<br />
===Prerequisite===<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
===Download from Github===<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
===Create log directory===<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
===Config file===<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
===Inti Script===<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Apache Proxy configuration===<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
=== Etherpad ===<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
==Additional Modules==<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
==Other==<br />
<br />
===Account Link===<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
==Application Configuration==<br />
<br />
===Adding Taxes in Invoice Report===<br />
## Enable debug mod (setting and under odoo-10.0 click on "Activate the developer mode") <br />
## Setting -> Reports -> Reports and click on invoice in the list<br />
## Click on QWEB Views and select "report_invoice_document"<br />
## Add the following xml after the tag </div> line 115 and before the tag <p t-if="o.comment"><br />
<br />
<syntaxhighlight lang="xml"><br />
<div class="row" t-if="len(o.tax_line_ids) &gt; 1"><br />
<div class="col-xs-6"><br />
<table class="table table-condensed"><br />
<thead><br />
<tr><br />
<th>Tax</th><br />
<th class="text-right">Amount</th><br />
</tr><br />
</thead><br />
<tbody><br />
<tr t-foreach="o.tax_line_ids" t-as="t"><br />
<td><span t-field="t.tax_id.description"/></td><br />
<td class="text-right"><br />
<span t-field="t.amount" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: o.currency_id}"/><br />
</td><br />
</tr><br />
</tbody><br />
</table><br />
</div><br />
</div><br />
</syntaxhighlight></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo&diff=687
Odoo
2017-03-25T23:55:55Z
<p>Nicolas Rollin: Nicolas Rollin moved page Odoo to Odoo 10: One page per version</p>
<hr />
<div>#REDIRECT [[Odoo 10]]</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=686
Odoo 10
2017-03-25T23:55:55Z
<p>Nicolas Rollin: Nicolas Rollin moved page Odoo to Odoo 10: One page per version</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
===Application Configuration===<br />
<br />
====Adding Taxes in Invoice Report====<br />
## Enable debug mod (setting and under odoo-10.0 click on "Activate the developer mode") <br />
## Setting -> Reports -> Reports and click on invoice in the list<br />
## Click on QWEB Views and select "report_invoice_document"<br />
## Add the following xml after the tag </div> line 115 and before the tag <p t-if="o.comment"><br />
<br />
<syntaxhighlight lang="xml"><br />
<div class="row" t-if="len(o.tax_line_ids) &gt; 1"><br />
<div class="col-xs-6"><br />
<table class="table table-condensed"><br />
<thead><br />
<tr><br />
<th>Tax</th><br />
<th class="text-right">Amount</th><br />
</tr><br />
</thead><br />
<tbody><br />
<tr t-foreach="o.tax_line_ids" t-as="t"><br />
<td><span t-field="t.tax_id.description"/></td><br />
<td class="text-right"><br />
<span t-field="t.amount" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: o.currency_id}"/><br />
</td><br />
</tr><br />
</tbody><br />
</table><br />
</div><br />
</div><br />
</syntaxhighlight></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=685
Odoo 10
2017-03-25T23:51:04Z
<p>Nicolas Rollin: /* Adding Taxes in Invoice Report */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
===Application Configuration===<br />
<br />
====Adding Taxes in Invoice Report====<br />
## Enable debug mod (setting and under odoo-10.0 click on "Activate the developer mode") <br />
## Setting -> Reports -> Reports and click on invoice in the list<br />
## Click on QWEB Views and select "report_invoice_document"<br />
## Add the following xml after the tag </div> line 115 and before the tag <p t-if="o.comment"><br />
<br />
<syntaxhighlight lang="xml"><br />
<div class="row" t-if="len(o.tax_line_ids) &gt; 1"><br />
<div class="col-xs-6"><br />
<table class="table table-condensed"><br />
<thead><br />
<tr><br />
<th>Tax</th><br />
<th class="text-right">Amount</th><br />
</tr><br />
</thead><br />
<tbody><br />
<tr t-foreach="o.tax_line_ids" t-as="t"><br />
<td><span t-field="t.tax_id.description"/></td><br />
<td class="text-right"><br />
<span t-field="t.amount" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: o.currency_id}"/><br />
</td><br />
</tr><br />
</tbody><br />
</table><br />
</div><br />
</div><br />
</syntaxhighlight></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=684
Odoo 10
2017-03-25T23:40:54Z
<p>Nicolas Rollin: /* Application Configuration */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
===Application Configuration===<br />
<br />
====Adding Taxes in Invoice Report====</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=683
Odoo 10
2017-03-25T23:39:49Z
<p>Nicolas Rollin: /* Odoo 10 */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre><br />
<br />
==Application Configuration==</div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=682
Odoo 10
2017-03-25T23:37:22Z
<p>Nicolas Rollin: /* Odoo 10 */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=681
Odoo 10
2017-03-25T23:36:02Z
<p>Nicolas Rollin: /* Prerequisite */</p>
<hr />
<div><br />
==Odoo 11==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-11 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=680
Odoo 10
2017-03-25T23:35:44Z
<p>Nicolas Rollin: /* Odoo 10 */</p>
<hr />
<div><br />
==Odoo 11==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Linux&diff=679
Linux
2017-03-25T04:21:53Z
<p>Nicolas Rollin: /* Install other Software */</p>
<hr />
<div>== Command Line ==<br />
[[Usefull Linux Command]]<br />
<br />
== Vi ==<br />
[[Vi commands]]<br />
<br />
== Work with Disk image ==<br />
Backup <br />
<syntaxhighlight lang="bash"><br />
dd if=/dev/sdd of=~/SDCardBackup.img<br />
</syntaxhighlight><br />
Restore<br />
<syntaxhighlight lang="bash"><br />
dd bs=4M if=~/SDCardBackup.img of=/dev/sdd<br />
sync<br />
</syntaxhighlight><br />
<br />
== Java ==<br />
* in case of error message "wrong ELF class: ELFCLASS64"<br />
* Install 32bit jdk package<br />
<pre>apt-get install openjdk-7-jdk:i386</pre><br />
<br />
== Server Setup ==<br />
=== Template Server ===<br />
==== Install Ubuntu Server ====<br />
# Download ubuntu lts server version<br />
## Only install open ssh sever <br />
# Update package : apt-get update<br />
# Update system : apt-get upgrade<br />
==== Install Minimum Desktop ====<br />
# Install minimal desktop : apt-get install --no-install-recommends xubuntu-desktop<br />
==== Install other Software ====<br />
# Install other tools : apt-get install firefox synaptic gkrellm gkrellmd gnome-terminal nfs-common xdiskusage gparted<br />
# To compile : apt-get install build-essential linux-headers-generic<br />
<br />
==== Install WebMin ====<br />
# Download Webmin : wget http://prdownloads.sourceforge.net/webadmin/webmin_1.791_all.deb<br />
# Install Dependencies : apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python<br />
# Install Webmin : dpkg --install webmin_1.791_all.deb<br />
<br />
=== Mail Server ===<br />
[[Mail Server|Mail Server]]<br />
<br />
=== Fail2Ban ===<br />
[[Fail2Ban|Fail2Ban]]<br />
<br />
==Configuration Notes ==<br />
===SSH===<br />
* Allow root access<br />
** edit /etc/ssh/sshd_config<br />
<pre>PermitRootLogin yes</pre><br />
** restart service<br />
<pre>service ssh restart</pre><br />
===Php===<br />
[[PHP Module]]<br />
<br />
=== VirtualBox ===<br />
* Too display Usb devices<br />
<pre>usermod -aG vboxusers yourusername</pre><br />
* Increase Virtual Disk space<br />
** VBoxManage modifyhd <absolute path to file> --resize <size in MB><br />
<pre>VBoxManage modifyhd wim.vdi --resize 20000</pre><br />
<br />
=== VNC ===<br />
* Fixing the tab key in VNC<br />
<pre>xfconf-query -c xfce4-keyboard-shortcuts -p /xfwm4/custom/'<'Super'>'Tab -r</pre><br />
<br />
=== Container Docker ===<br />
* Web site [https://www.docker.com Docker]<br />
====Install Docker====<br />
* Install<br />
<pre> apt-get install docker.io</pre><br />
<br />
====Network Configuration====<br />
* Configuration to share the same network<br />
* Edit /etc/network/interfaces to add a "bridge" you may have to reconfigure your firewall<br />
* Add br0 to auto<br />
* Remove ip assignement or dhcp of eth0<br />
* Add br0 bridged to eth0 <br />
<br />
=====Ip Address assigned by dhcp=====<br />
<pre><br />
# Interfaces(5) file used by ifup(8) and ifdown(8)<br />
auto lo br0 eth0<br />
iface lo inet loopback<br />
<br />
iface eth0 inet manual<br />
<br />
iface br0 inet dhcp<br />
bridge_ports eth0<br />
</pre><br />
<br />
=====Ip Address Fix=====<br />
<pre><br />
# Interfaces(5) file used by ifup(8) and ifdown(8)<br />
auto lo br0 eth0<br />
iface lo inet loopback<br />
<br />
iface br0 inet static<br />
address 10.1.1.1<br />
netmask 255.255.255.0<br />
broadcast 10.1.1.255<br />
network 10.1.1.0<br />
bridge_ports eth0<br />
</pre><br />
<br />
=====Update Docker Configuration to use the bridge=====<br />
* Edit /etc/default/docker.io<br />
* Add private dns (--dns 192.168.1.1) and bridge (-b br0) to Docker Option line<br />
<pre> DOCKER_OPTS="--dns 8.8.8.8 --dns 10.10.1.1 -b br0"</pre><br />
<br />
=====Howto manage container=====<br />
<br />
See [[Unix Container | Container Howto]] for the usage<br />
<br />
=== Owncloud ===<br />
* Add the repository <br />
<syntaxhighlight lang="bash"><br />
sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_14.04/ /' >> /etc/apt/sources.list.d/owncloud.list"<br />
</syntaxhighlight><br />
* Add Key<br />
<syntaxhighlight lang="bash"><br />
wget http://download.opensuse.org/repositories/isv:ownCloud:community/xUbuntu_14.04/Release.key<br />
sudo apt-key add - < Release.key<br />
</syntaxhighlight><br />
* Install<br />
<syntaxhighlight lang="bash"><br />
sudo apt-get update<br />
sudo apt-get install owncloud<br />
</syntaxhighlight> <br />
=== Apache Svn Server===<br />
<br />
1: Install Apache HTTP server and required modules:<br />
<br />
<syntaxhighlight lang="bash">sudo apt-get install libapache2-svn apache2</syntaxhighlight><br />
<br />
2: Enable SSL<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo a2enmod ssl<br />
sudo vi /etc/apache2/ports.conf<br />
</syntaxhighlight><br />
<br />
Add or check that the following is in the file:<br />
<pre><br />
<IfModule mod_ssl.c><br />
Listen 443<br />
</IfModule><br />
</pre><br />
<br />
3: Generate an SSL certificate:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo apt-get install ssl-cert<br />
sudo mkdir /etc/apache2/ssl<br />
sudo /usr/sbin/make-ssl-cert /usr/share/ssl-cert/ssleay.cnf /etc/apache2/ssl/apache.pem<br />
</syntaxhighlight><br />
4: Create virtual host<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/svnserver<br />
sudo kate /etc/apache2/sites-available/svnserver<br />
</syntaxhighlight><br />
<br />
Change (in ports.conf):<br />
<pre><br />
"NameVirtualHost *" to "NameVirtualHost *:443"<br />
</pre><br />
and (in svnserver)<br />
<pre><br />
<VirtualHost *> to <VirtualHost *:443><br />
</pre><br />
Add, under ServerAdmin (also in file svnserver):<br />
<pre><br />
SSLEngine on<br />
SSLCertificateFile /etc/apache2/ssl/apache.pem<br />
SSLProtocol all<br />
SSLCipherSuite HIGH:MEDIUM<br />
</pre><br />
<br />
5: Enable the site:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo a2ensite svnserver<br />
sudo /etc/init.d/apache2 restart<br />
</syntaxhighlight><br />
<br />
To overcome warnings:<br />
<br />
<syntaxhighlight lang="bash">sudo vi /etc/apache2/apache2.conf</syntaxhighlight><br />
<br />
Add: "ServerName $your_server_name"<br />
<br />
Add, under ServerAdmin (also in file svnserver):<br />
<br />
<pre><br />
SSLEngine on<br />
SSLCertificateFile /etc/apache2/ssl/apache.pem<br />
SSLProtocol all<br />
SSLCipherSuite HIGH:MEDIUM<br />
</pre><br />
<br />
6: Adding repository(ies): The following setup assumes we want to host multiple repositories. Run this for creating the first repository:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo mkdir /var/svn<br />
sudo svnadmin create /var/svn/mysvnrepository<br />
sudo chown -R www-data:www-data /var/svn/mysvnrepository<br />
sudo chmod -R g+ws /var/svn/mysvnrepository<<br />
</syntaxhighlight><br />
<br />
6.a. For more repositories: do step 6 again (changing mysvnrepository Name)<br />
<br />
7: Add an authenticated user<br />
<br />
<syntaxhighlight lang="bash">sudo htpasswd -c -m /etc/apache2/dav_svn.passwd $user_name</syntaxhighlight><br />
<br />
8: Enable and configure WebDAV and SVN:<br />
<br />
<syntaxhighlight lang="bash">sudo vi /etc/apache2/mods-available/dav_svn.conf</syntaxhighlight><br />
<br />
Add or uncomment:<br />
<br />
<pre><br />
<Location /svn><br />
DAV svn<br />
<br />
# for multiple repositories - see comments in file<br />
SVNParentPath /var/svn<br />
<br />
AuthType Basic<br />
AuthName "Subversion Repository"<br />
AuthUserFile /etc/apache2/dav_svn.passwd<br />
Require valid-user<br />
SSLRequireSSL<br />
</Location><br />
</pre><br />
<br />
9: Restart apache server:<br />
<br />
<syntaxhighlight lang="bash">sudo /etc/init.d/apache2 restart</syntaxhighlight><br />
<br />
10: Validation:<br />
<br />
Fired up a browser:<br />
<br />
http://localhost/svn/$REPOS<br />
https://localhost/svn/$REPOS<br />
<br />
Commit something:<br />
<br />
<syntaxhighlight lang="bash">svn import --username $user_name anyfile.txt https://localhost/svn/$REPOS/anyfile.txt -m “Testing”</syntaxhighlight><br />
<br />
Accept the certificate and enter password. Check out what you've just committed:<br />
<br />
<syntaxhighlight lang="bash">svn co --username $user_name https://localhost/svn/$REPOS</syntaxhighlight><br />
<br />
=== XDMCP ===<br />
<pre>vi /etc/lightdm/lightdm.conf</pre><br />
<syntaxhighlight lang="bash"><br />
[SeatDefaults]<br />
greeter-session=lightdm-gtk-greeter<br />
user-session=xubuntu<br />
###Nr001 <br />
allow-guest=false<br />
greeter-show-manual-login=true<br />
greeter-hide-users=true<br />
<br />
###Nr001<br />
[XDMCPServer]<br />
enabled=true<br />
<br />
</syntaxhighlight><br />
<br />
== Video File Manipulation ==<br />
[[video_file_converter |Convert Video file]]<br />
<br />
== Display Remote Screen ==<br />
<br />
===Xephyr / xdmcp===<br />
plugin Xdmcp for remina does not work and since few year noby seams to take care of it !<br />
<br />
Instead use <br />
<pre>Xephyr -query $REMOTE_HOST :1 -screen 1280x1024</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Linux&diff=678
Linux
2017-02-05T18:30:27Z
<p>Nicolas Rollin: </p>
<hr />
<div>== Command Line ==<br />
[[Usefull Linux Command]]<br />
<br />
== Vi ==<br />
[[Vi commands]]<br />
<br />
== Work with Disk image ==<br />
Backup <br />
<syntaxhighlight lang="bash"><br />
dd if=/dev/sdd of=~/SDCardBackup.img<br />
</syntaxhighlight><br />
Restore<br />
<syntaxhighlight lang="bash"><br />
dd bs=4M if=~/SDCardBackup.img of=/dev/sdd<br />
sync<br />
</syntaxhighlight><br />
<br />
== Java ==<br />
* in case of error message "wrong ELF class: ELFCLASS64"<br />
* Install 32bit jdk package<br />
<pre>apt-get install openjdk-7-jdk:i386</pre><br />
<br />
== Server Setup ==<br />
=== Template Server ===<br />
==== Install Ubuntu Server ====<br />
# Download ubuntu lts server version<br />
## Only install open ssh sever <br />
# Update package : apt-get update<br />
# Update system : apt-get upgrade<br />
==== Install Minimum Desktop ====<br />
# Install minimal desktop : apt-get install --no-install-recommends xubuntu-desktop<br />
==== Install other Software ====<br />
# Install other tools : apt-get install firefox synaptic gkrellm gkrellmd gnome-terminal nfs-common xdiskusage gparted<br />
<br />
==== Install WebMin ====<br />
# Download Webmin : wget http://prdownloads.sourceforge.net/webadmin/webmin_1.791_all.deb<br />
# Install Dependencies : apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python<br />
# Install Webmin : dpkg --install webmin_1.791_all.deb<br />
<br />
=== Mail Server ===<br />
[[Mail Server|Mail Server]]<br />
<br />
=== Fail2Ban ===<br />
[[Fail2Ban|Fail2Ban]]<br />
<br />
==Configuration Notes ==<br />
===SSH===<br />
* Allow root access<br />
** edit /etc/ssh/sshd_config<br />
<pre>PermitRootLogin yes</pre><br />
** restart service<br />
<pre>service ssh restart</pre><br />
===Php===<br />
[[PHP Module]]<br />
<br />
=== VirtualBox ===<br />
* Too display Usb devices<br />
<pre>usermod -aG vboxusers yourusername</pre><br />
* Increase Virtual Disk space<br />
** VBoxManage modifyhd <absolute path to file> --resize <size in MB><br />
<pre>VBoxManage modifyhd wim.vdi --resize 20000</pre><br />
<br />
=== VNC ===<br />
* Fixing the tab key in VNC<br />
<pre>xfconf-query -c xfce4-keyboard-shortcuts -p /xfwm4/custom/'<'Super'>'Tab -r</pre><br />
<br />
=== Container Docker ===<br />
* Web site [https://www.docker.com Docker]<br />
====Install Docker====<br />
* Install<br />
<pre> apt-get install docker.io</pre><br />
<br />
====Network Configuration====<br />
* Configuration to share the same network<br />
* Edit /etc/network/interfaces to add a "bridge" you may have to reconfigure your firewall<br />
* Add br0 to auto<br />
* Remove ip assignement or dhcp of eth0<br />
* Add br0 bridged to eth0 <br />
<br />
=====Ip Address assigned by dhcp=====<br />
<pre><br />
# Interfaces(5) file used by ifup(8) and ifdown(8)<br />
auto lo br0 eth0<br />
iface lo inet loopback<br />
<br />
iface eth0 inet manual<br />
<br />
iface br0 inet dhcp<br />
bridge_ports eth0<br />
</pre><br />
<br />
=====Ip Address Fix=====<br />
<pre><br />
# Interfaces(5) file used by ifup(8) and ifdown(8)<br />
auto lo br0 eth0<br />
iface lo inet loopback<br />
<br />
iface br0 inet static<br />
address 10.1.1.1<br />
netmask 255.255.255.0<br />
broadcast 10.1.1.255<br />
network 10.1.1.0<br />
bridge_ports eth0<br />
</pre><br />
<br />
=====Update Docker Configuration to use the bridge=====<br />
* Edit /etc/default/docker.io<br />
* Add private dns (--dns 192.168.1.1) and bridge (-b br0) to Docker Option line<br />
<pre> DOCKER_OPTS="--dns 8.8.8.8 --dns 10.10.1.1 -b br0"</pre><br />
<br />
=====Howto manage container=====<br />
<br />
See [[Unix Container | Container Howto]] for the usage<br />
<br />
=== Owncloud ===<br />
* Add the repository <br />
<syntaxhighlight lang="bash"><br />
sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_14.04/ /' >> /etc/apt/sources.list.d/owncloud.list"<br />
</syntaxhighlight><br />
* Add Key<br />
<syntaxhighlight lang="bash"><br />
wget http://download.opensuse.org/repositories/isv:ownCloud:community/xUbuntu_14.04/Release.key<br />
sudo apt-key add - < Release.key<br />
</syntaxhighlight><br />
* Install<br />
<syntaxhighlight lang="bash"><br />
sudo apt-get update<br />
sudo apt-get install owncloud<br />
</syntaxhighlight> <br />
=== Apache Svn Server===<br />
<br />
1: Install Apache HTTP server and required modules:<br />
<br />
<syntaxhighlight lang="bash">sudo apt-get install libapache2-svn apache2</syntaxhighlight><br />
<br />
2: Enable SSL<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo a2enmod ssl<br />
sudo vi /etc/apache2/ports.conf<br />
</syntaxhighlight><br />
<br />
Add or check that the following is in the file:<br />
<pre><br />
<IfModule mod_ssl.c><br />
Listen 443<br />
</IfModule><br />
</pre><br />
<br />
3: Generate an SSL certificate:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo apt-get install ssl-cert<br />
sudo mkdir /etc/apache2/ssl<br />
sudo /usr/sbin/make-ssl-cert /usr/share/ssl-cert/ssleay.cnf /etc/apache2/ssl/apache.pem<br />
</syntaxhighlight><br />
4: Create virtual host<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/svnserver<br />
sudo kate /etc/apache2/sites-available/svnserver<br />
</syntaxhighlight><br />
<br />
Change (in ports.conf):<br />
<pre><br />
"NameVirtualHost *" to "NameVirtualHost *:443"<br />
</pre><br />
and (in svnserver)<br />
<pre><br />
<VirtualHost *> to <VirtualHost *:443><br />
</pre><br />
Add, under ServerAdmin (also in file svnserver):<br />
<pre><br />
SSLEngine on<br />
SSLCertificateFile /etc/apache2/ssl/apache.pem<br />
SSLProtocol all<br />
SSLCipherSuite HIGH:MEDIUM<br />
</pre><br />
<br />
5: Enable the site:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo a2ensite svnserver<br />
sudo /etc/init.d/apache2 restart<br />
</syntaxhighlight><br />
<br />
To overcome warnings:<br />
<br />
<syntaxhighlight lang="bash">sudo vi /etc/apache2/apache2.conf</syntaxhighlight><br />
<br />
Add: "ServerName $your_server_name"<br />
<br />
Add, under ServerAdmin (also in file svnserver):<br />
<br />
<pre><br />
SSLEngine on<br />
SSLCertificateFile /etc/apache2/ssl/apache.pem<br />
SSLProtocol all<br />
SSLCipherSuite HIGH:MEDIUM<br />
</pre><br />
<br />
6: Adding repository(ies): The following setup assumes we want to host multiple repositories. Run this for creating the first repository:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo mkdir /var/svn<br />
sudo svnadmin create /var/svn/mysvnrepository<br />
sudo chown -R www-data:www-data /var/svn/mysvnrepository<br />
sudo chmod -R g+ws /var/svn/mysvnrepository<<br />
</syntaxhighlight><br />
<br />
6.a. For more repositories: do step 6 again (changing mysvnrepository Name)<br />
<br />
7: Add an authenticated user<br />
<br />
<syntaxhighlight lang="bash">sudo htpasswd -c -m /etc/apache2/dav_svn.passwd $user_name</syntaxhighlight><br />
<br />
8: Enable and configure WebDAV and SVN:<br />
<br />
<syntaxhighlight lang="bash">sudo vi /etc/apache2/mods-available/dav_svn.conf</syntaxhighlight><br />
<br />
Add or uncomment:<br />
<br />
<pre><br />
<Location /svn><br />
DAV svn<br />
<br />
# for multiple repositories - see comments in file<br />
SVNParentPath /var/svn<br />
<br />
AuthType Basic<br />
AuthName "Subversion Repository"<br />
AuthUserFile /etc/apache2/dav_svn.passwd<br />
Require valid-user<br />
SSLRequireSSL<br />
</Location><br />
</pre><br />
<br />
9: Restart apache server:<br />
<br />
<syntaxhighlight lang="bash">sudo /etc/init.d/apache2 restart</syntaxhighlight><br />
<br />
10: Validation:<br />
<br />
Fired up a browser:<br />
<br />
http://localhost/svn/$REPOS<br />
https://localhost/svn/$REPOS<br />
<br />
Commit something:<br />
<br />
<syntaxhighlight lang="bash">svn import --username $user_name anyfile.txt https://localhost/svn/$REPOS/anyfile.txt -m “Testing”</syntaxhighlight><br />
<br />
Accept the certificate and enter password. Check out what you've just committed:<br />
<br />
<syntaxhighlight lang="bash">svn co --username $user_name https://localhost/svn/$REPOS</syntaxhighlight><br />
<br />
=== XDMCP ===<br />
<pre>vi /etc/lightdm/lightdm.conf</pre><br />
<syntaxhighlight lang="bash"><br />
[SeatDefaults]<br />
greeter-session=lightdm-gtk-greeter<br />
user-session=xubuntu<br />
###Nr001 <br />
allow-guest=false<br />
greeter-show-manual-login=true<br />
greeter-hide-users=true<br />
<br />
###Nr001<br />
[XDMCPServer]<br />
enabled=true<br />
<br />
</syntaxhighlight><br />
<br />
== Video File Manipulation ==<br />
[[video_file_converter |Convert Video file]]<br />
<br />
== Display Remote Screen ==<br />
<br />
===Xephyr / xdmcp===<br />
plugin Xdmcp for remina does not work and since few year noby seams to take care of it !<br />
<br />
Instead use <br />
<pre>Xephyr -query $REMOTE_HOST :1 -screen 1280x1024</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Linux&diff=677
Linux
2017-01-30T06:06:21Z
<p>Nicolas Rollin: /* Configuration Notes */</p>
<hr />
<div>== Command Line ==<br />
[[Usefull Linux Command]]<br />
<br />
== Vi ==<br />
[[Vi commands]]<br />
<br />
== Java ==<br />
* in case of error message "wrong ELF class: ELFCLASS64"<br />
* Install 32bit jdk package<br />
<pre>apt-get install openjdk-7-jdk:i386</pre><br />
<br />
== Server Setup ==<br />
=== Template Server ===<br />
==== Install Ubuntu Server ====<br />
# Download ubuntu lts server version<br />
## Only install open ssh sever <br />
# Update package : apt-get update<br />
# Update system : apt-get upgrade<br />
==== Install Minimum Desktop ====<br />
# Install minimal desktop : apt-get install --no-install-recommends xubuntu-desktop<br />
==== Install other Software ====<br />
# Install other tools : apt-get install firefox synaptic gkrellm gkrellmd gnome-terminal nfs-common xdiskusage gparted<br />
<br />
==== Install WebMin ====<br />
# Download Webmin : wget http://prdownloads.sourceforge.net/webadmin/webmin_1.791_all.deb<br />
# Install Dependencies : apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python<br />
# Install Webmin : dpkg --install webmin_1.791_all.deb<br />
<br />
=== Mail Server ===<br />
[[Mail Server|Mail Server]]<br />
<br />
=== Fail2Ban ===<br />
[[Fail2Ban|Fail2Ban]]<br />
<br />
==Configuration Notes ==<br />
===SSH===<br />
* Allow root access<br />
** edit /etc/ssh/sshd_config<br />
<pre>PermitRootLogin yes</pre><br />
** restart service<br />
<pre>service ssh restart</pre><br />
===Php===<br />
[[PHP Module]]<br />
<br />
=== VirtualBox ===<br />
* Too display Usb devices<br />
<pre>usermod -aG vboxusers yourusername</pre><br />
* Increase Virtual Disk space<br />
** VBoxManage modifyhd <absolute path to file> --resize <size in MB><br />
<pre>VBoxManage modifyhd wim.vdi --resize 20000</pre><br />
<br />
=== VNC ===<br />
* Fixing the tab key in VNC<br />
<pre>xfconf-query -c xfce4-keyboard-shortcuts -p /xfwm4/custom/'<'Super'>'Tab -r</pre><br />
<br />
=== Container Docker ===<br />
* Web site [https://www.docker.com Docker]<br />
====Install Docker====<br />
* Install<br />
<pre> apt-get install docker.io</pre><br />
<br />
====Network Configuration====<br />
* Configuration to share the same network<br />
* Edit /etc/network/interfaces to add a "bridge" you may have to reconfigure your firewall<br />
* Add br0 to auto<br />
* Remove ip assignement or dhcp of eth0<br />
* Add br0 bridged to eth0 <br />
<br />
=====Ip Address assigned by dhcp=====<br />
<pre><br />
# Interfaces(5) file used by ifup(8) and ifdown(8)<br />
auto lo br0 eth0<br />
iface lo inet loopback<br />
<br />
iface eth0 inet manual<br />
<br />
iface br0 inet dhcp<br />
bridge_ports eth0<br />
</pre><br />
<br />
=====Ip Address Fix=====<br />
<pre><br />
# Interfaces(5) file used by ifup(8) and ifdown(8)<br />
auto lo br0 eth0<br />
iface lo inet loopback<br />
<br />
iface br0 inet static<br />
address 10.1.1.1<br />
netmask 255.255.255.0<br />
broadcast 10.1.1.255<br />
network 10.1.1.0<br />
bridge_ports eth0<br />
</pre><br />
<br />
=====Update Docker Configuration to use the bridge=====<br />
* Edit /etc/default/docker.io<br />
* Add private dns (--dns 192.168.1.1) and bridge (-b br0) to Docker Option line<br />
<pre> DOCKER_OPTS="--dns 8.8.8.8 --dns 10.10.1.1 -b br0"</pre><br />
<br />
=====Howto manage container=====<br />
<br />
See [[Unix Container | Container Howto]] for the usage<br />
<br />
=== Owncloud ===<br />
* Add the repository <br />
<syntaxhighlight lang="bash"><br />
sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_14.04/ /' >> /etc/apt/sources.list.d/owncloud.list"<br />
</syntaxhighlight><br />
* Add Key<br />
<syntaxhighlight lang="bash"><br />
wget http://download.opensuse.org/repositories/isv:ownCloud:community/xUbuntu_14.04/Release.key<br />
sudo apt-key add - < Release.key<br />
</syntaxhighlight><br />
* Install<br />
<syntaxhighlight lang="bash"><br />
sudo apt-get update<br />
sudo apt-get install owncloud<br />
</syntaxhighlight> <br />
=== Apache Svn Server===<br />
<br />
1: Install Apache HTTP server and required modules:<br />
<br />
<syntaxhighlight lang="bash">sudo apt-get install libapache2-svn apache2</syntaxhighlight><br />
<br />
2: Enable SSL<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo a2enmod ssl<br />
sudo vi /etc/apache2/ports.conf<br />
</syntaxhighlight><br />
<br />
Add or check that the following is in the file:<br />
<pre><br />
<IfModule mod_ssl.c><br />
Listen 443<br />
</IfModule><br />
</pre><br />
<br />
3: Generate an SSL certificate:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo apt-get install ssl-cert<br />
sudo mkdir /etc/apache2/ssl<br />
sudo /usr/sbin/make-ssl-cert /usr/share/ssl-cert/ssleay.cnf /etc/apache2/ssl/apache.pem<br />
</syntaxhighlight><br />
4: Create virtual host<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/svnserver<br />
sudo kate /etc/apache2/sites-available/svnserver<br />
</syntaxhighlight><br />
<br />
Change (in ports.conf):<br />
<pre><br />
"NameVirtualHost *" to "NameVirtualHost *:443"<br />
</pre><br />
and (in svnserver)<br />
<pre><br />
<VirtualHost *> to <VirtualHost *:443><br />
</pre><br />
Add, under ServerAdmin (also in file svnserver):<br />
<pre><br />
SSLEngine on<br />
SSLCertificateFile /etc/apache2/ssl/apache.pem<br />
SSLProtocol all<br />
SSLCipherSuite HIGH:MEDIUM<br />
</pre><br />
<br />
5: Enable the site:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo a2ensite svnserver<br />
sudo /etc/init.d/apache2 restart<br />
</syntaxhighlight><br />
<br />
To overcome warnings:<br />
<br />
<syntaxhighlight lang="bash">sudo vi /etc/apache2/apache2.conf</syntaxhighlight><br />
<br />
Add: "ServerName $your_server_name"<br />
<br />
Add, under ServerAdmin (also in file svnserver):<br />
<br />
<pre><br />
SSLEngine on<br />
SSLCertificateFile /etc/apache2/ssl/apache.pem<br />
SSLProtocol all<br />
SSLCipherSuite HIGH:MEDIUM<br />
</pre><br />
<br />
6: Adding repository(ies): The following setup assumes we want to host multiple repositories. Run this for creating the first repository:<br />
<br />
<syntaxhighlight lang="bash"><br />
sudo mkdir /var/svn<br />
sudo svnadmin create /var/svn/mysvnrepository<br />
sudo chown -R www-data:www-data /var/svn/mysvnrepository<br />
sudo chmod -R g+ws /var/svn/mysvnrepository<<br />
</syntaxhighlight><br />
<br />
6.a. For more repositories: do step 6 again (changing mysvnrepository Name)<br />
<br />
7: Add an authenticated user<br />
<br />
<syntaxhighlight lang="bash">sudo htpasswd -c -m /etc/apache2/dav_svn.passwd $user_name</syntaxhighlight><br />
<br />
8: Enable and configure WebDAV and SVN:<br />
<br />
<syntaxhighlight lang="bash">sudo vi /etc/apache2/mods-available/dav_svn.conf</syntaxhighlight><br />
<br />
Add or uncomment:<br />
<br />
<pre><br />
<Location /svn><br />
DAV svn<br />
<br />
# for multiple repositories - see comments in file<br />
SVNParentPath /var/svn<br />
<br />
AuthType Basic<br />
AuthName "Subversion Repository"<br />
AuthUserFile /etc/apache2/dav_svn.passwd<br />
Require valid-user<br />
SSLRequireSSL<br />
</Location><br />
</pre><br />
<br />
9: Restart apache server:<br />
<br />
<syntaxhighlight lang="bash">sudo /etc/init.d/apache2 restart</syntaxhighlight><br />
<br />
10: Validation:<br />
<br />
Fired up a browser:<br />
<br />
http://localhost/svn/$REPOS<br />
https://localhost/svn/$REPOS<br />
<br />
Commit something:<br />
<br />
<syntaxhighlight lang="bash">svn import --username $user_name anyfile.txt https://localhost/svn/$REPOS/anyfile.txt -m “Testing”</syntaxhighlight><br />
<br />
Accept the certificate and enter password. Check out what you've just committed:<br />
<br />
<syntaxhighlight lang="bash">svn co --username $user_name https://localhost/svn/$REPOS</syntaxhighlight><br />
<br />
=== XDMCP ===<br />
<pre>vi /etc/lightdm/lightdm.conf</pre><br />
<syntaxhighlight lang="bash"><br />
[SeatDefaults]<br />
greeter-session=lightdm-gtk-greeter<br />
user-session=xubuntu<br />
###Nr001 <br />
allow-guest=false<br />
greeter-show-manual-login=true<br />
greeter-hide-users=true<br />
<br />
###Nr001<br />
[XDMCPServer]<br />
enabled=true<br />
<br />
</syntaxhighlight><br />
<br />
== Video File Manipulation ==<br />
[[video_file_converter |Convert Video file]]<br />
<br />
== Display Remote Screen ==<br />
<br />
===Xephyr / xdmcp===<br />
plugin Xdmcp for remina does not work and since few year noby seams to take care of it !<br />
<br />
Instead use <br />
<pre>Xephyr -query $REMOTE_HOST :1 -screen 1280x1024</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=676
Odoo 10
2017-01-16T05:29:36Z
<p>Nicolas Rollin: /* Etherpad */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Enable service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=675
Odoo 10
2017-01-16T05:29:01Z
<p>Nicolas Rollin: /* Etherpad */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
* Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
* Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
* Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<br />
* Create service<br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=674
Odoo 10
2017-01-16T05:27:40Z
<p>Nicolas Rollin: /* Installation */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
==== Etherpad ====<br />
Install Ehterpad<br />
<syntaxhighlight lang="bash"><br />
addgroup etherpad<br />
useradd etherpad etherpad -c "Etherpad Server" -d /opt/etherpad-lite -m -s /bin/bash<br />
cd /opt<br />
git clone git://github.com/ether/etherpad-lite.git<br />
/opt/etherpad-lite/bin/run.sh --root<br />
</syntaxhighlight><br />
<br />
Review Etherpad Setting<br />
<syntaxhighlight lang="bash"><br />
vi /opt/etherpad-lite/settings.json<br />
</syntaxhighlight><br />
<br />
Auto start Etherpad<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/etherpad.service<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Etherpad Server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=etherpad<br />
Group=etherpad<br />
ExecStart=/opt/etherpad-lite/bin/run.sh<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
</syntaxhighlight><br />
<syntaxhighlight lang="bash"><br />
systemctl enable etherpad.service<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=673
Odoo 10
2017-01-16T03:02:20Z
<p>Nicolas Rollin: /* Installation */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
====Apache Proxy configuration====<br />
<syntaxhighlight lang="bash"><br />
ProxyRequests off<br />
SSLProxyEngine on<br />
ProxyErrorOverride off<br />
RequestHeader set "X-Forwarded-Proto" "https"<br />
# Fix IE problem (httpapache proxy dav error 408/409)<br />
SetEnv proxy-nokeepalive 1<br />
<br />
<Proxy *><br />
Order deny,allow<br />
Allow from all<br />
</Proxy><br />
<br />
ProxyPass / http://odooserver:8069/<br />
ProxyPassReverse / http://odooserver:8069<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=672
Odoo 10
2017-01-15T20:16:28Z
<p>Nicolas Rollin: /* Additional Modules */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
<br />
<syntaxhighlight lang="bash"><br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
</syntaxhighlight><br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=671
Odoo 10
2017-01-15T20:15:39Z
<p>Nicolas Rollin: /* Additional Modules */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
Create a folder specific to the additional module to facilitate the identifiacation<br />
mkdir /opt/odoo-10/addons-plus<br />
chown odoo: /opt/odoo-10/addons-plus<br />
<br />
Download modules from<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=670
Odoo 10
2017-01-15T20:12:43Z
<p>Nicolas Rollin: /* Config file */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[options]<br />
; This is the password that allows database operations:<br />
admin_passwd = passowrd<br />
addons_path = /opt/odoo-10/odoo/addons,/opt/odoo-10/addons,/opt/odoo-10/addons-plus<br />
csv_internal_sep = ,<br />
data_dir = /opt/odoo-10/.local/share/Odoo<br />
db_host = False<br />
db_maxconn = 64<br />
db_maxconn = 128<br />
db_name = False<br />
db_password = False<br />
db_port = False<br />
db_template = template1<br />
db_user = False<br />
;###dbfilter = .*<br />
demo = {}<br />
email_from = False<br />
geoip_database = /usr/share/GeoIP/GeoLiteCity.dat<br />
import_partial =<br />
limit_memory_hard = 2684354560<br />
limit_memory_soft = 2147483648<br />
limit_request = 8192<br />
limit_time_cpu = 60<br />
limit_time_real = 120<br />
list_db = True<br />
log_db = False<br />
log_db_level = warning<br />
log_handler = :INFO<br />
;###log_level = info<br />
log_level = error<br />
logfile = /var/log/odoo/odoo-server.log<br />
logrotate = False<br />
longpolling_port = 8072<br />
max_cron_threads = 2<br />
osv_memory_age_limit = 1.0<br />
osv_memory_count_limit = False<br />
pg_path = None<br />
pidfile = None<br />
proxy_mode = False<br />
reportgz = False<br />
server_wide_modules = None<br />
smtp_password = False<br />
smtp_port = 25<br />
smtp_server = smtp.local<br />
smtp_ssl = False<br />
smtp_user = odoo<br />
syslog = False<br />
test_commit = False<br />
test_enable = False<br />
test_file = False<br />
test_report_directory = False<br />
translate_modules = ['all']<br />
unaccent = False<br />
without_demo = False<br />
workers = 0<br />
xmlrpc = True<br />
xmlrpc_interface =<br />
xmlrpc_port = 8069<br />
<br />
</syntaxhighlight><br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=669
Odoo 10
2017-01-15T20:07:46Z
<p>Nicolas Rollin: /* Inti Script */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
</syntaxhighlight><br />
<br />
<syntaxhighlight lang="bash"><br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight><br />
<br />
===Additional Modules===<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=668
Odoo 10
2017-01-15T20:07:14Z
<p>Nicolas Rollin: /* Additional Modules */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
<br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight> <br />
<br />
===Additional Modules===<br />
[https://github.com/OCA OAC on Github]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin
http://wiki.objclt.ca/wiki/index.php?title=Odoo_10&diff=667
Odoo 10
2017-01-15T20:06:48Z
<p>Nicolas Rollin: /* Odoo 10 */</p>
<hr />
<div><br />
==Odoo 10==<br />
<br />
===Installation===<br />
<br />
====Prerequisite====<br />
'''Pyhton'''<br />
<pre><br />
apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils python-pip python-pypdf python-passlib python-decorator gcc python-dev mc bzr python-setuptools python-markupsafe python-reportlab-accel python-zsi python-yaml python-argparse python-openssl python-egenix-mxdatetime python-usb python-serial lptools make python-pydot python-psutil python-paramiko poppler-utils python-pdftools antiword python-requests python-xlsxwriter python-suds python-psycogreen python-ofxparse python-gevent<br />
</pre><br />
<br />
'''Jnodes'''<br />
<pre><br />
apt-get install npm<br />
ln -s /usr/bin/nodejs /usr/bin/node<br />
npm install -g less less-plugin-clean-css<br />
</pre><br />
<br />
'''User odoo'''<br />
<pre><br />
adduser --system --home=/opt/odoo-10 --group odoo<br />
</pre><br />
<br />
'''PostGres Database odoo User'''<br />
<pre><br />
su - postgres<br />
cd<br />
createuser -s odoo<br />
exit<br />
</pre><br />
<br />
'''Gdata'''<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz<br />
tar zxvf gdata-2.0.18.tar.gz<br />
chown -R odoo: gdata-2.0.18<br />
gdata-2.0.18/<br />
python setup.py install<br />
</pre><br />
<br />
====Download from Github====<br />
<pre><br />
cd /opt/odoo-10<br />
wget https://github.com/odoo/odoo/archive/10.0.zip<br />
unzip 10.0.zip<br />
chown -R odoo: odoo-10.0<br />
</pre><br />
<br />
====Create log directory====<br />
<pre><br />
mkdir /var/log/odoo<br />
chown -R odoo:root /var/log/odoo<br />
<br />
</pre><br />
<br />
====Config file====<br />
<syntaxhighlight lang="bash"><br />
mkdir /etc/odoo-10<br />
cp /opt/odoo/odoo-10/debian/odoo.conf /etc/odoo-10/odoo-server.conf<br />
chown -R odoo: /etc/odoo-10<br />
</syntaxhighlight><br />
<br />
<br />
====Inti Script====<br />
<syntaxhighlight lang="bash"><br />
vi /etc/systemd/system/odoo-server.service<br />
<br />
[Unit]<br />
Description=Odoo server<br />
After=syslog.target network.target<br />
<br />
[Service]<br />
Type=simple<br />
User=odoo<br />
Group=odoo<br />
# This line connects the odoo server to the Xvfb virtual display and allows wkhtmltopdf to work<br />
Environment="DISPLAY=:0" "PYTHONPATH=/usr/local/lib/python2.7/dist-packages/:$PYTHONPATH"<br />
ExecStart=/opt/odoo-10/odoo-bin -c /etc/odoo-10/odoo-server.conf --db-filter=MyDemo<br />
<br />
# Give a reasonable amount of time for the server to start up/shut down<br />
TimeoutSec=300<br />
<br />
[Install]<br />
WantedBy=multi-user.target<br />
<br />
</syntaxhighlight> <br />
<br />
===Additional Modules===<br />
[https://github.com/OCA OAC]<br />
<br />
===Other===<br />
<br />
====Account Link====<br />
Account Master<br />
<syntaxhighlight lang="sql">select id, name from account_account where name in ('Product Sales', 'Expenses');</syntaxhighlight><br />
<pre><br />
id | name<br />
-----+---------------<br />
19 | Product Sales<br />
23 | Expenses<br />
(2 rows)<br />
</pre><br />
<br />
Property<br />
<syntaxhighlight lang="sql">select id, name, type, fields_id, value_reference, res_id from ir_property where value_reference like '%23' or value_reference like '%19';</syntaxhighlight><br />
<pre><br />
id | name | type | fields_id | value_reference | res_id<br />
----+--------------------------------+----------+-----------+--------------------+--------<br />
4 | property_account_expense_categ | many2one | 1947 | account.account,23 |<br />
5 | property_account_income_categ | many2one | 1948 | account.account,19 |<br />
(2 rows)<br />
</pre><br />
<br />
Model<br />
<syntaxhighlight lang="sql">select id, model, name, relation, field_description from ir_model_fields where id in (1947, 1948);</syntaxhighlight><br />
<pre><br />
id | model | name | relation | field_description<br />
------+------------------+--------------------------------+-----------------+-------------------<br />
1947 | product.category | property_account_expense_categ | account.account | Expense Account<br />
1948 | product.category | property_account_income_categ | account.account | Income Account<br />
(2 rows)<br />
</pre></div>
Nicolas Rollin