sharepointoscar/vagrant-ansible-packer-spfarm

The source code for the book: DevOps for SharePoint

vagrant-ansible-packer-spfarm's Issues

sqlcmd not installed yet

vagrant-ansible-packer-spfarm/ansible/roles/internal/Database/tasks/mountImg.yml

Line 42 in f85a0a5

win_shell: sqlcmd -S SP2016SQLSERVER -Q "EXEC sp_addsrvrolemember 'SPOSCAR\vagrant', 'sysadmin';"

This command cannot be run until the SQL Server is installed, the sqlcmd binary is not present. Also, the unattend file for the SQL Server install already sets up the vagrant user as sysadmin so this task is not required.

Vagrant Box Missing

Hi,

I'm trying to run this repo but it appears the vagrant boxes you reference are no longer avaialble. Can you please upload them again? I'm struggling to get this to work with other Windows2016 boxes.

vagrant up DomainController1 problems

Hi Oscar,

I am going through your book at the moment but I am not able to get past the Chapter 3 exercise.

I keep getting this error message,

task path: /Users/josephdizon/Documents/lab/vagrant-ansible-packer-spfarm/ansible/plays/domaincontroller.yml:2
Using module file /usr/local/lib/python2.7/site-packages/ansible/modules/windows/setup.ps1
<192.168.2.19> ESTABLISH WINRM CONNECTION FOR USER: vagrant on PORT 5985 TO 192.168.2.19
checking if winrm_host 192.168.2.19 is an IPv6 address
objc[2881]: +[__NSPlaceholderDate initialize] may have been in progress in another thread when fork() was called.
objc[2881]: +[__NSPlaceholderDate initialize] may have been in progress in another thread when fork() was called. We cannot safely call it or ignore it in the fork() child process. Crashing instead. Set a breakpoint on objc_initializeAfterForkError to debug.

I am using a MacBook Pro 2018 running Mojave 10.14.2

It would be good if you can direct me to a working Ubuntu desktop which has all the tools installed as mentioned in the book.

Installing SharePoint 2016 always fails after 5 minute reboot

vagrant-ansible-packer-spfarm/ansible/roles/internal/AppServer/tasks/mount-sp-img.yml

Line 77 in f85a0a5

minutes: 5

This task running within 5 minutes of starting the task to actually install SharePoint causes the install to always fail. You need to find a better way to determine when the previous psexec task has actually completed before randomly restarting the server. For example, what I did was check for the presence of the text 'Press any key' in the output log file.

TLS Version issue

building the box doesn't work anymore.
after running packer fix and continuing with a new file one find that there's a TLS issue during download.
Seems to be described in saltstack issue 56276

this is what you'd see happening:

    virtualbox-iso: C:\Users\vagrant>powershell -NoProfile -ExecutionPolicy unrestricted -Command "iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))"  0<NUL
==> virtualbox-iso: Exception calling "DownloadString" with "1" argument(s): "The request was aborted: Could not create SSL/TLS secure
==> virtualbox-iso: channel."
==> virtualbox-iso: At line:1 char:1
==> virtualbox-iso: + iex ((new-object net.webclient).DownloadString('https://chocolatey.or ...
==> virtualbox-iso: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
==> virtualbox-iso:     + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
==> virtualbox-iso:     + FullyQualifiedErrorId : WebException
==> virtualbox-iso:
==> virtualbox-iso: Provisioning step had errors: Running the cleanup provisioner, if present...
==> virtualbox-iso: Cleaning up floppy disk...
==> virtualbox-iso: Deregistering and deleting VM...
==> virtualbox-iso: Deleting output directory...
Build 'virtualbox-iso' errored after 9 minutes 20 seconds: Script exited with non-zero exit status: 1.Allowed exit codes are: [0]

AppServer port 2016 blocked by firewall. Task failing.

vagrant-ansible-packer-spfarm/ansible/roles/internal/AppServer/tasks/mount-sp-img.yml

Line 83 in f85a0a5

- name: wait until admin port 2016 is available. start checking after 15 minutes.

The firewall is not opened on port 2016 before this task is run so it will never be able to reach port 2016 and the task will always fail. There needs to be a task prior to this one to open the port 2016 in the firewall, similar to the one used earlier to open the port for remote SQL server access.

Port 2016 not opened for WFE Role

vagrant-ansible-packer-spfarm/ansible/roles/internal/WFE/tasks/mount-sp-img.yml

Line 76 in f85a0a5

win_wait_for:

The AutoSPInstaller xml file in the repo states that the Admin Configuration Manager which runs on port 2016 should only be set up for the AppServer so this task always fails with a timeout due to it waiting for port 2016 to be active, which it will never be.