Final TODO List for TKL Consideration TKL-Final-RC1

[DocCyblade]

Use this post to keep track of a final TODO list, this TODO list could create one or more issues. Any issues that would be created, just post a link to this issue so it's cross linked. Also tag it with the tkl-final-rc1 tag.

• Update confconsole.txt (remove Samba references)(remove webconsole ref)
• Documentation Approach (separate issue for this (will be focused on DOCS folder)).
• Load Backup of openerp-server.conf in etc/odoo as openerp-server-backup for safety
• Review openerp-server-man.conf (for relavence or usefulness)
• If Connector Left in, update etc/init.d/openerp-server to reflect outlined changes for jobrunner in connector (see citation below - landis has changes built in beta 02 working SERVER)
• Optional but desired Check that ADDONS added actually load and do something (I - LA - have a checklist to go through.. A few hours looking at OCA)
• Check that Logs being Generated and Turned Over for (x time period)
• Put link for odoo "database managment" into Web Console as it is in ConfConsole
• (SHOULD NOT MAKE DEFAULT Got whtmltox (or whtmltopdf) functioning. Check with any "generated document" ie quotation
• (SHOULD NOT MAKE DEFAULTWorkers = 2 (not 0) unless breaking whtmltox (connector wants min 1)
• [x](SHOULD NOT MAKE DEFAULT) Debug Memory Limit Hard Minimum (add to openerp-server.conf) when jobrunners are used.
  Was able to get past this: Documented here:Jobrunner setup kills wkhtmltox (with wkhtmltopdf error -11) OCA/connector-magento#152
  • [x](SHOULD NOT MAKE DEFAULT) Workers = 2 (not 0) unless breaking whtmltox (connector wants min 1)
• Debug Memory Limit Hard Minimum (add to openerp-server.conf) if jobrunners are used.
• Check process security
• Check config file security.
• Final code cleanup / check
• Final build tests CHROOT
• Final build test ISO
• Final build test Full ISO install
• Check "reboot" cycles. From ConfConsole getting 50%. Half say "reached target shutdown" but do not shutdown... Either that or I am impatient. (LA) (subsequent 3: 2 did not reboot. 3rd did) works well enough. Seems not an Odoo issue.
• Other Finals....

Landis Can Edit. Can also see how to make a check Box (Can Check without being in EDIT MODE!)

• test check.... (put an X not a space in there)

[DocCyblade]

@l-arnold I think you should be able to edit the post, I created the check boxes so you can break down a issue in to parts. on the list view of issues it shows how many todo marks are left with a progress bar. Pretty neat!

We can add to this list, would like to have @JedMeister chime in to add to this list so we don't forget anything. After beta 2 is tagged, this is where we can have @JedMeister recommend or let us know of things that need to be changed or improved for consideration.

[l-arnold]

@DocCyblade Sounds good. I will see if I can edit the list. Can we "check the list" I know that
"()"before and after"() will cross things out.
Parenthesis left, tilde, tilde Parenthesis Right text to cross out Parenthesis left, tilde, tilde Parenthesis Right

[l-arnold]

I am moving my general commentary to "communications" issue". Lets have this focus on the punch list.

[l-arnold]

Thanks ken. Deleted finally.
One more try on Dev build also.

[l-arnold]

Was posting this a few days ago. Seems to not have posted:

Probably apparent by now

New "branch" created "RC" based on dev-wip1. This shoold be able to replace purpose of "Dev" branch and should be fed to "master" quite soon. No specific projects other than some security testing seen (at least by me) to be done.

Perhaps some sundry "documentation" files can be moved from "dev" branch but dev-wip1 workin for me. Not in a position to build a new TKLDEV box to get Dev running right now. Could do so next week but it sounds like Dev otherwise is building for folks (just not me).

[JedMeister]

Have you tried rebooting your TKLDev box? Usually that solves issues like this...

[l-arnold]

Tried a few times.

I will look at Ken's merges. Prob will solve.
Not a huge deal to make a new Build if needed. Your fuser -k command in the other thread might be all that is needed also.

fuser -k build/root.patched

[l-arnold]

On a new TKLDEV, b - dev indeed built. Tried one more time today on the old even after the fuser command above but still same failure.

Very strange that every other branch would build but not that one. I guess now I need to see if it "builds in the flesh." Will try a VM.

[JedMeister]

It is really weird... Although sometimes what you've done (started again) is quicker and easier rather than troubleshoot what is actually wrong...

[l-arnold]

Agreed. I just wanted to be sure something was not actually wrong with Dev (which both of you had already confirmed, but anyway).

I've been bombing Odoo with real use today. Pretty amazing system. I do need to find the module that allows me to have multiple images for a product just now. Will add that to the "list". We can work on how to handle options of the sort. Would be really nice if we could have it all be "post install" webmin additions but time is a ticking.

[l-arnold]

DEV (beta 2) report.
Built: Ran Updates:
Did not Start on firstboot into Odoo
Did not "Restart" from ConsConsole command (seemed to hang).

Apache was started on Reboot, but Odoo Service Unavailable still>

service unavailable

Will try again new with same ISO.

DEV-WIP1 is Working. Not clear on the differences between the builds at this juncture.

[JedMeister]

Did you do any troubleshooting? My guess is that there is something not quite right with the Odoo service and that it's not starting... You can check on it with:

service openerp-server status

It's actuall a python app so another route (to see if there is an odoo process running even if the server command reports it's not) would be this:

ps aux | grep python

You will get one result from the grep command; but if you get any others then python is running something...

Also it may be worth seeing if there is anything in the logs. IIRC we configured to log to be in /var/log

[l-arnold]

No troubleshooting as yet. Was going to try again first as I had some long delays on install. Seemed that the "update" post process did not run at the end. That said, it should have run at Reboot... at least it did in the past.

Will test in the AM. Just hit midnight and you are still working sir. You are always working it seems. Do you sleep? 😄

[JedMeister]

It's 4 in the afternoon here so yep I'm working! 😄 I do often work weird hours although I do sleep! 😄

[l-arnold]

I thought that was the calculation for you. Just sometimes it must be 2 AM. Back at it, just barely this AM here.

[l-arnold]

UPDATED
Ran again the Current DEV New Build. More info this time:
I did not load Updates at Install Time this time
It appears that the "restart services" is doing just a short run. (one maybe 2 entries showed up on the console briefly)

Reboot Cycled this time.
Odoo System not running.

Running the Inithook 97 Yo Yo
(OpenERP Service not Locatable). perhaps something with the name as I think we may have changed something there last week. Here is the Shell log)

root@tkl-odoo-dev ~# systemctl stop apache2.service
root@tkl-odoo-dev ~# systemctl stop openerp-server.service
Failed to stop openerp-server.service: Unit openerp-server.service not loaded.
root@tkl-odoo-dev ~# systemctl stop postgresql.service
root@tkl-odoo-dev ~# systemctl start postgresql.service
root@tkl-odoo-dev ~# systemctl start openerp-server.service
Failed to start openerp-server.service: Unit openerp-server.service failed to load: No such file or directory.
root@tkl-odoo-dev ~# systemctl start apache2.service

[l-arnold]

What the settings in Running Beta 1 look like from Webmin:
python /opt/openerp/odoo/openerp-server --config=/opt/openerp/odoo/openerp-serve ...

[l-arnold]

Placeholder: TESTED TKLBAM on a LAPP APPLIANCE.
Didn't quite work (but old system restore and other subjects (like wrong restore target) so will abandon subject for now)
Good exercise anyway!

[JedMeister]

I would expect restore to PostgreSQL app to fail. LAPP should be close but you may still need to do some tweaks.

If you want to troubleshoot this I suggest that instead of doing a full backup, that you use the --dump=/some/dir switch to dump the backup to a directory (instead of uploading it). Then you can see exactly what is being backed up and tweak includes/excludes for future runs.

[l-arnold]

I am going to delete "todays" thread of mine. Not really part of this issue set.

[l-arnold]

I have set the "default" branch to DEV-WIP1 as I will otherwise put my "github edits" invariably into the wrong branch. I need to work in WIP-DEV1 and then we can move to DEV etc.

We do have some changes in DEV which are stopping the OpenERP Service from Loading, so some focus needed there.

[JedMeister]

As an aside I think that including the git branch in the command prompt would avoid (or at least minimise) this. If you google you can find how to do this (IIRC it's called 'git-prompt'). I have been meaning to do it on my TKLDev server for a while but never got around to it. I actually think that adding it to TKLDev and making it default would be cool!

[l-arnold]

I have Deleted the "TKLDEV" build issues as I don't think these are subjects for the Odoo App per say. Want to focus only on Odoo App subjects (can also have Ken's Branch Conversation here)

[l-arnold]

I learned today that "there can be problems" if Odoo is "abruptly stopped". It would seem, therefore, worth putting a openerp-close command potentially into /etc/init.d/confconsole

Ideally this would use the ".init" which by my understanding is in the same folder: /etc/init.d/openerp-server (should we perhaps consider renaming to openerp.init again? I actually think the old version of openerp.init was a softlink to openerp-server)

Also, I wonder if the "services" start stop that we use address this file or are they only addressing etc/odoo/openerp-server ?

Enough questions.
Best.

[l-arnold]

Running dev-wip1 just went to Generate a Sales Order. Was

blockedReport (PDF)
Wkhtmltopdf failed (error code: -11). Message:

I was not aware of any changes, but perhaps there was a version change mentioned last week or so? Did that hit the code? Seems unlikely but I will look.

(update) I do not see wkhtmltopdf having been loaded in the dev-wip1 branch at all. Perhaps the new Odoo Code is expecting it to be there.

Prior we had had manually loaded whtmltox in "10-dependencies"

The only real changes I am seeing in this realm on the current build is the removal of SAMBA. There were a few root "calls" that were also removed, but would not expect them to effect wkhtml(etc). Will look at what they are. Perhaps there is a dependency that was removed that should not have been.

[l-arnold]

I've had 5 Permanent Pauses now trying to install wkhtmltopdf
Happening at different points. Basically seems to be with the debian package servers.

I am getting the "Odoo-Init" to work in stopping with the following "down yo-yo" set of commands.

systemctl stop apache2.service
cd /etc/init.d
/bin/bash openerp-server stop
systemctl stop postgresql.service

Unfortunately the After a "Debian pause" I am getting:

root@dev-wip1 ~# apt-get install wkhtmltopdf

E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?

Trying a Restart now, but generally have been moving back to a "just prior" snapshot. Not sure why the pauses in Debian Feeds.

[l-arnold]

Ok, Finally got wkhtmltopdf to build. However, Odoo is more "contrary" still. This is the Error Response:

I will look at the last build to see if I can Print or email a formated Order. (Beta 01)

Odoo Warning

Report (PDF)

Wkhtmltopdf failed (error code: -6). Message: The switch --header-spacing, is not support using unpatched qt, and will be ignored.The switch --header-html, is not support using unpatched qt, and will be ignored.The switch --footer-html, is not support using unpatched qt, and will be ignored.QXcbConnection: Could not connect to display

[DocCyblade]

Is this from a clean build of odoo? Or did you do a restore?

[l-arnold]

It is from a Clean Build of Odoo. I did do a Database Backup from Beta 01. Database Restore (complete database) to Beta 02. Got the error in Beta 02 (my branch dev-wip1 - gen beta01 as was not able the other day to have branch dev open the service).

I did just reverse the Database process back to Beta 01 and was able to both Send Emails (formatted) and to Print, in fact with the same order that was not printing in Beta02.

I have been unable to find the meaning of error code -11 for wkhtmltopdf. I did post on their GitPlace asking for feedback but nothing yet.

[l-arnold]

Only other thing I was working through in Beta 02 was getting magento connector to work. Got that working. Should have nothing to do with wkhtml(anything) however. I will put the few changes made into Beta 01 and be sure I can still print. Expecting I can, but perhaps there is some call that is routing some dependency path out of line there. (BTW the Magento-CONNECTOR started flying. Really great performance w/ the settings update)

[DocCyblade]

You making changes to build code or on the server its self post install? If you are making changes to build code what branch are you working on

[l-arnold]

(UPDATED for PHONE TYPOS)
Server itself post install.

Ran VM snapshot
Installed wkhtmltopdf (which removed wkhtmltox)
Tested. Got second error w column info above.
Went back to snapshot. So got wkhtmltox back.

The changes withe the connector were very minor in my running
etc/odoo/Openerp-server.conf
end
etc/init.d/openerp-server. Files.

Have not touched any repository files that I know of this week. Have read some.

(update next Line ADDED)
Will do a "Fresh Install and move Data over to verify. No Changes just the Database.

[l-arnold]

If making changes would do so to dev-wip1 Branch.

I do want to update the "extras" folder a bit but need to get to that. Was holding for a while.

If you have anything you want me to test on your side, let me know.
thanks,

[l-arnold]

OK. Getting print/email etc off of FRESH BUILD Beta 02.

Likely something in the start cycles around the connector broke that. Will have to debug. They are not in the CONFIG FILES right now and can get a generated document (see attached)

[l-arnold]

Not sure if my updates above telegraph through. Got it back on fresh beta 2 build.

[DocCyblade]

If you can type up a brief way to run through a test of Odoo. Maybe creating new demo database with demo data, and doing some adds edited, delete, and some other actions that would need testing, this way I can repeat the same tests. We could use this test matrix to test each release.

[l-arnold]

On wkhtmlrox error got this . seemsbto have been a ram issue. (will test again soon)
:wkhtmltopdf/wkhtmltopdf#2592 (comment)

[l-arnold]

Driving about two hours.
Will send an outline when I arrive.of base tests.

[l-arnold]

Ken, this is my quick process.

(UPDATED)

Missing the Checkbox Format somehow .

-[ ] Build the App
-[ ] Install
-[ ] See that Odoo is running (should land on the Database manager page - URL should be in confconsole I feel)
-[ ] Change Admin Password in Odoo Database Manager (testing control)
-[ ] install new database with new password
worth check that openerp-server.con admin-db variable also changes -- sometimes Odoo can "cache" this but not change it if not writing to openerp-server.conf properly
-[ ] Install CRM Module
-[ ] Install Online Billing
-[ ] Install Sales Management
-[ ] Create a Customer
-[ ] Create a Quotation for the Customer
-[ ] When quotation is saved, Choose Print (or Email)
-[ ] See that a Formatted Doc Shows up
-[ ] Ideally see that an Email goes out (should default to Localhost and might work)
-[ ] Check that Git is applying to opt/openerp/odoo files
-[ ] Check that various addons added in 50-(additional addons) are showing in settings, module
-[ ] ideally we should check those specific addons to see that they install.
-[ ] base Odoo addons should install (deliniate where those go vs outside addons - ie look at the code)
-[ ] in Shell, test the /etc/init.d/openerp-server (initialization) commands
/bin/bash openerp-server stop
/bin/bash openerp-server start
/bin/bash openerp-server restart

*   (make sure system is actually running in browser.  if an issue will return "service unavailable"
*  best to try some of the -u  -d variables outlined earlier.
*  worth looking at the actua file to see how it is structured.  Not sure if that is an odoo creation of something of our legacy here to be honest.  (used to have a "softlink" called openero.init that would instagate that file and did not require the /bin/bash call.  That I found convenient.  Might be good to bring back somehow and leave it in /opt/openerp/  folder

-[ ]

-[ ] At this point lots of settings need to be made to be sure the system is working on a customized basis.

Other Tests to perform include migrating Data via "backup and restore" commands in the Odoo Database Manager. I find this better than tklbam for the time being as tklbam is restoring virutually the full system (including the old git).

Worth moving some data files between machines. Need to use "whole database option on the restore" command (not the "backup-restore" option)

wkhtmltox:
Need to run this dependency and not wkhtmltopdf debian package.

wkhtmltox (for emails, quotations, reports) is working in my base dev-wip1 branch (same as the jobrunner problem)

Unfortunately, my wkhtmltox is not working on the system that I configured "jobrunners" for in the Magento Connector. I even reduced the number of workers to 1 (from 4). running on 1 Gb of Ram. Will briefly test 2 Gb but expecting it is not actually a Ram issue at this point.

incoming mail (in my docs). Should not really be an issue in the install. User needs to config their MX files etc.

ssl: Also. I can give you the template of how I install basic ssl with specific certs and not tkl certs

a2ensite odoo-12325 (web console post install). I highly encourage this being kept in /etc/apached2/sites-available)
(it does not have to be loaded by default but would encourage it on every app personally)

OK, all for now.

[l-arnold]

50-external-modules
come from
https://github.com/OCA

I have added descriptions of the repositories being pulled.

Have an unwieldy "Addons" line in openerp-server.conf

Would be good if we could break it into multiple lines. Perhaps one for each addon.

Curretly reads like this (perhaps we can use semicolons to break the line

addons_path = /opt/openerp/odoo/addons,/opt/openerp/oca/oca_server_tools,/opt/openerp/oca/connector,/opt/openerp/oca/connector-ecommerce,/opt/openerp/oca/connector-magento,/opt/openerp/oca/e-commerce,/opt/openerp/oca/product-attribute,/opt/openerp/oca/sale-workflow,/opt/openerp/oca/account-financial-tools,/opt/openerp/oca/connector-interfaces,/opt/openerp/oca/web,/opt/openerp/oca/website,/opt/openerp/oca/donation,/opt/openerp/oca/commission

[l-arnold]

Semicolons do not seem to work. Applying Word Wrap will allow the line to be properly edited. There may be another trick as well go having multiple entries in the addons path line above.

[JedMeister]

Hi guys,

I have been away the last few days and just had a really quick scan through the conversation. It seems to me that you guys are hard at it and getting closer and don't require anything specific from me at this point...!? Great work so far BTW!

If there is anything you need from me (and I have missed it) please feel free to give me another ping!

@l-arnold

Have an unwieldy "Addons" line in openerp-server.conf

All of your addons seem to be in /opt/openerp/oca/. From my very quick googling it seems to me that you should not need to actually include each path individually and that they should all get included automatically if you just reduced it to that base path (i.e. /opt/openerp/oca/). From what I have read many others seem to just have a single "add-ons" path which they then put all their addon subdirectories in and they all get picked up by Odoo (although it seems that you also need to enable them in the UI). There may be some subtlety that I have missed though....

[l-arnold]

RE whtmltox and jobrunner got the comment from Guewen pointing to "memory" configs. Should test and document:
OCA/connector-magento#152 (comment)

[l-arnold]

Worked through the wkhtmltox vs jobrunner memory issue. Settings Documented Here
Updated on Checklist above:

(THIS SHOULD NOT BE OUR DEFAULT BUILD)!
OCA/connector-magento#152

Moved the VM to 2 GB Ram (was running at 1gb and could run at 512mb)

Gave Odoo on openerp-server.conf

workers = 2 (was workers = 1)
limit_memory_hard = 1730150400

was 805306368

limit_memory_soft = 943718400
was 671088640

[l-arnold]

SO, How Do we bring these together?

The only variation we need are the Extra-Addons Branch

I will find my spreadsheets that outline the OCA Addons so we can perhaps make them Options.
Elstwise we can give instructions on how to integrate.

Wold be really cool if we became the Gateway for Odoo Addons. Might get everyone to get their act together actually.

[l-arnold]

I realize there are instructions @DocCyblade I just need to "absorb" a bit.
Thinking it will be "Copy Paste" to a large degree.

[l-arnold]

@JedMeister and @DocCyblade
Jeremy had written "Have an unwieldy "Addons" line in openerp-server.conf
All of your addons seem to be in /opt/openerp/oca/. From my very quick googling it seems to me that you should not need to actually include each path individually and that they should all get included automatically if you just reduced it to that base path (i.e. /opt/openerp/oca/). From what I have read many others seem to just have a single "add-ons" path which they then put all their addon subdirectories in and they all get picked up by Odoo (although it seems that you also need to enable them in the UI). There may be some subtlety that I have missed though...."

---

So
I just tested this approach to addons and it wants to work but but it doesn't fully work. Icons for one for all the OCA (addl) Modules and Apps are not showing ujp.

Debugging some more. I will put in all the "individual folders" and see if I get a different resu

It seems your approach though should work Jeremy. Seems to work in the normal "Odoo/addons/ folder otherwise.

[l-arnold]

This is a Module after normal install.

What I am getting with shorter Addons folder call (see the incomplete Install)

How it shouild generally be looking:

These are the missing Icons (visible among others)

[l-arnold]

Basically complete. Closing this now.
Closed up on TKL-Odoo @DocCyblade