Data not visible on Sal website

[Scott]

Hello all.

I went with installing the docker version per Nick McSpadden's walkthrough here:

https://osxdominion.wordpress.com/2015/01/29/setting-up-sal-for-munki-reporting/

Everything appears to be in order server and client side. When viewing the site however the data is not available for the business unit/ key combo.

Given my docker knowledge isn't even whitebelt fu worthy I am pretty much at a loss as to where or what to look for..

What I have done is managed to root around the containers and cat the various files looking for a culprit.  Here's where it get's interesting! I can see the data collected for the Mac client that was set up. And... a few errors which I discovered in the container for macadmins/sal for /run.sh

Here's what's running
# docker ps -a

CONTAINER ID      IMAGE                            COMMAND                 CREATED            STATUS                   PORTS                       NAMES

5e9ec8aea488        macadmins/sal                 "/run.sh"                      5 hours ago          Up 5 hours               0.0.0.0:80->8000/tcp   sal

17d246bc3394        grahamgilbert/postgres   "/docker-entrypoint.s"   5 hours ago         Up 5 hours                5432/tcp                      postgres-sal

e688c361206d        grahamgilbert/postgres   "/bin/echo Data-only "   5 hours ago         Exited (0) 5 hours ago                                  sal-db-data

# docker images

REPOSITORY                TAG                 IMAGE ID               CREATED              VIRTUAL SIZE

grahamgilbert/postgres   latest              c5508b15b113        11 hours ago       290.1 MB

macadmins/sal                latest                  f4c4b117d651        16 hours ago        532.5 MB

#docker info

Containers: 3

Images: 58

Storage Driver: devicemapper

 Pool Name: docker-252:3-789694-pool

 Pool Blocksize: 65.54 kB

 Backing Filesystem: extfs

 Data file: /dev/loop0

 Metadata file: /dev/loop1

 Data Space Used: 2.974 GB

 Data Space Total: 107.4 GB

 Data Space Available: 30.48 GB

 Metadata Space Used: 4.166 MB

 Metadata Space Total: 2.147 GB

 Metadata Space Available: 2.143 GB

 Udev Sync Supported: true

 Deferred Removal Enabled: false

 Data loop file: /var/lib/docker/devicemapper/devicemapper/data

 Metadata loop file: /var/lib/docker/devicemapper/devicemapper/metadata

 Library Version: 1.02.93-RHEL7 (2015-01-28)

Execution Driver: native-0.2

Logging Driver: json-file

Kernel Version: 3.10.0-229.20.1.el7.x86_64

Operating System: CentOS Linux 7 (Core)

CPUs: 1

Total Memory: 1.797 GiB

Name: munki-sal.np.wc1.yellowpages.com

ID: X64U:OX3U:RBEM:LRVP:4UD5:L335:VVSM:APE2:3KA7:5ZJ5:KTNT:JXDE

Here's a few errors in the macadmins/sal container:

{"log":"IntegrityError: null value in column \"machine_group_id\" violates not-null constraint\n","stream":"stdout","time":"2016-02-25T04:05:05.897348024Z"} SEVERAL OF THESE

{"log":"[24/Feb/2016 20:06:37] ERROR [django.request:256] Internal Server Error: /checkin/\n","stream":"stdout","time":"2016-02-25T04:06:37.114527794Z"} SEVERAL OF THESE

{"log":"IntegrityError: null value in column \"machine_group_id\" violates not-null constraint\n","stream":"stdout","time":"2016-02-25T04:06:37.114886641Z"} SEVERAL OF THESE

{"log":"DETAIL:  Failing row contains (2, C07GL1GBDJD1, CA02MDEUILAB-02, 10.11.3, 16 GB, 16777216, 2.3.1.2535, redacted_client, 206692536, 233460384, 11, redacted, Macmini5,2, Intel Core i5, 2.5 GHz, Darwin, 2016-02-25 04:06:37.031389+00, \u003c?xml version=\"1.0\" encoding=\"UTF-8\"?\u003e\n","stream":"stdout","time":"2016-02-25T04:06:37.114896753Z"} SEVERAL OF THESE

What can I do from here? And yes I rebooted my "computer" hehe. Any help is much appreciated and thanks in advance!

Scott

[Graham Gilbert]

What tag did you pull down? It'd likely you got a broken version of Master. The article on Nicks site is a little out of date now and I suggest you follow the official instructions which includes installing a tagged release so you know exactly what version you're running. 

https://github.com/salopensource/sal/wiki/Docker

Sent from my iPhone

--
You received this message because you are subscribed to the Google Groups "sal-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sal-discuss...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Scott]

Wow! Thanks for the quick response. I will follow your link and report back. I'm fairly certain what is provided in your link will put me on track. I did notice in the url provided that the db is linked as -v /usr/local/sal_data/db:/var/lib/postgresql/data. On our self service vm's we do not have /var/lib/postgresql available. Is it to be assumed that postgresql is already installed? Sorry for the inconvenience.

[Graham Gilbert]

Postgres is not installed at all. That's why the setup doc takes you through setting up a separate postgres container and linking it to your Sal container. 

Sent from my iPhone

[Scott]

That did it! I followed the new link you sent and I am now looking at my first shiny new Mac report in Sal OpenSource.

You just made my week. Now I can present this as our new reporting solution after I dig around some more. 

Thanks so very much Graham! Keep up the great work.