Thursday, July 19, 2018

Hi

Hi, Just checking in.
I haven't posted something in a while.
I am still here :)

Monday, February 13, 2017

Layered Process Audit Application

I want to make a quality audit application - Layered process audit - think survey app.

Along these lines:

https://github.com/williej/rails-nested-survey

This one is quite simple and uses cocoon nested forms.
I want to add question types (like harley/surveyor), drop down list of questions to choose from, sort order for questions, answers should have and issues field and corrections field.
Questions could have correct answers.

https://github.com/harley/surveyor

This is close to what I want. BUT.. I don't understand the code he uses. I more understand cocoon nested forms like williej uses.
Proposed changes..
I want to add drop-down question type, drop down list of questions to choose from, sort order for questions,
answers should have and issues field and corrections field.
Questions could have correct answers.

This is what I have built so far..

https://github.com/dgleba/lpa338

Notes:
- I want to use devise with devise-ldap-authenticable, to use our active directory for user/pass like I am using on other apps.

Other examples..

https://github.com/runtimerevolution/survey ( has online demo )

https://github.com/code-mancers/rapidfire ( has online demo, see demo app code and link there )

Sign in. Pick an audit. 7-20 questions are presented based on who you are. Answer the questions and provide comments regarding issues and corrective actions taken.

I have written many apps, but I can't get my head around this one.

_____________

As I think about this more, I have hacked on the williej schema by taking inspriation from harley/surveyor.

These are the scaffolds to create it.

----

rails generate scaffold Answer body:text choice:references question:references response:references issue:string action:text -f

rails generate scaffold Choice name:string question:references -f

rails generate scaffold Question name question_list:references sort:integer qtype:integer survey:references -f

rails generate scaffold QuestionList name:string sort:integer active_status:integer -f

rails generate scaffold Survey name:string -f

rails generate scaffold Response survey:references user:references ip:string -f

----

Previously, I had hacked on this...

Harley schema with proposed changes..

See > symbols below..

ActiveRecord::Schema.define(version: 20160728042324) do

create_table "answers", force: :cascade do |t|
t.integer "choice_id"
t.integer "question_id"
t.integer "response_id"
t.string "content"

> text issue
> text correction

t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["choice_id"], name: "index_answers_on_choice_id"
t.index ["question_id"], name: "index_answers_on_question_id"
t.index ["response_id"], name: "index_answers_on_response_id"
end

create_table "choices", force: :cascade do |t|
t.integer "question_id"
t.string "content"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["question_id"], name: "index_choices_on_question_id"
end

create_table "collaborations", force: :cascade do |t|
t.integer "survey_id"
t.integer "user_id"
t.integer "role"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["survey_id"], name: "index_collaborations_on_survey_id"
t.index ["user_id"], name: "index_collaborations_on_user_id"
end

create_table "questions", force: :cascade do |t|
t.string "title"
t.integer "survey_id"
t.integer "type"

> integer sort
> integer active

t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["survey_id"], name: "index_questions_on_survey_id"
end

create_table "responses", force: :cascade do |t|
t.integer "survey_id"
t.string "ip"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["survey_id"], name: "index_responses_on_survey_id"
end

create_table "surveys", force: :cascade do |t|
t.string "title"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
end

create_table "users", force: :cascade do |t|
t.string "email"
t.string "password_digest"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.boolean "admin", default: false
end

end

Thursday, February 9, 2017

Test to get data from PLC to influxDB

Installing Ignition Server

Conditions:

ubuntu 14.04 server with LXDE running in virtualbox VM

https://inductiveautomation.com/downloads/ignition

install:

If Java 8 is not already installed, run the following commands to install it:

sudo add-apt-repository ppa:webupd8team/javasudo apt-get updatesudo apt-get install oracle-java8-installer

Ignition-7.9.1-linux-x64-installer.run

https://docs.inductiveautomation.com:8443/display/DOC/Installing+Ignition+on+Linux

start the gateway

sudo /etc/init.d/ignition start

Error:

albe@v206c:~/Downloads$ sudo /etc/init.d/ignition start
Starting Ignition Gateway...
Waiting for Ignition Gateway......................
WARNING: Ignition Gateway may have failed to start.

_____________

https://www.influxdata.com/

wget https://dl.influxdata.com/influxdb/releases/influxdb_1.2.0_amd64.deb

sudo dpkg -i influxdb_1.2.0_amd64.deb

Installed OK.

_____________

https://github.com/coussej/node-opcua-logger

_____________

http://www.osboxes.org/ubuntu-mate/

Ubuntu Mate 16.04 Xenial

VirtualBox
VirtualBox (VDI) 64bit Download Size: 1.1GB
MD5: 7f0eb37bfa12d3e7570e2175f4141dc0
Username: osboxes
Password: osboxes.org

VB Guest Additions & VMware Tools: Not Installed

_____________

https://rodandfly.ca/ignition-with-simulated-plc-to-influxdb-with-via-opc-ua/

_____________

Friday, February 3, 2017

Multivariate Analysis - Collecting the Data

Open source Industrial data collection with OPC server:
Or maybe not..

Updated: 2017-02-13 11:49 AM

1.
http://coussej.github.io/2016/04/18/Building-An-Open-Source-Process-Historian/

I’m currently testing this on a production system for monitoring some values in a Siemens S7 PLC, using a Simatic NET v12 server.

2.
OPC to InfluxDB plugin

https://github.com/coussej/node-opcua-logger

3.
I think this is OPC server..

https://en.wikipedia.org/wiki/OPC_Unified_Architecture

https://en.wikipedia.org/wiki/Open_Platform_Communications

4.
Python OPC UA communication to Allen Bradley Modbus

https://github.com/FreeOpcUa/python-opcua/issues/116

https://github.com/zerox1212/python-opcua-modbus-driver

5.
Links:

http://industrial.softing.com/en/news/news-details/article/opc-ua-gateway-for-siemens-s7-plc-connection.html

6.
OPC UA made easy

https://github.com/uaf/uaf

7.
Ignition:

2017-02-06:
We are looking at the Ignition server product.

Example: SQL bridge module, Allen-Bradley Driver Suite, Siemens Driver Suite. This should get the data from PLC to OPC UA server.

https://inductiveautomation.com/

https://inductiveautomation.com/pricing/ignition

Scroll to the bottom and see the individual item prices.

Have a question? We'd love to help! Get in touch by calling us at 1-800-266-7798.

11.
OPC - UA -- Chris has done some testing.

2017-02-13
https://rodandfly.ca/ignition-with-simulated-plc-to-influxdb-with-via-opc-ua/

15.
How to connect to ignition opc-ua anonymous

https://support.inductiveautomation.com/usermanuals/ignition/index.html?connecting_to_opc_ua.htm

see - Message Security Mode
see - Authentication

https://support.inductiveautomation.com/usermanuals/ignition/index.html?troubleshooting_opc_com_connec.htm

see - Allow Anonymous Access

http://www.opcconnect.com/uafree.php

41.
MVA:

ProSensus Inc.: Overview | LinkedIn
Sold to Aspen Technologies

https://en.wikipedia.org/wiki/Multivariate_analysis

Notes:

IOT - protocol is MQTT

plc reading ref...
https://www.raspberrypi.org/forums/viewtopic.php?f=37&t=81551
Most of the PLCs support the Modbus protocol (TCP or RTU).

https://www.raspberrypi.org/forums/viewtopic.php?f=37&t=81551

http://stackoverflow.com/questions/39006884/pymodbus-failed-to-connect-with-plc-slave-and-raspberry-pi-master

Wednesday, January 25, 2017

How to run a Windows RemoteApp on an Ubuntu Client PC

2017-01-25 David Gleba

I used:
Windows 7 ultimate for 'server'
Linux Mint 18 XFCE for 'client' (Based on Ubuntu 16.04)
I am also working with my standard server (as 'client'): see github/dgleba - vamp206a

Ref:

My notes..
https://docs.google.com/document/d/1LwGE6nvIaAgQRHvp07JcLUb5Erc50e40poFw94SLglI/edit?usp=sharing

https://bmullan.wordpress.com/2012/09/17/howto-integrate-windows-apps-into-the-ubuntu-linux-desktop-using-windows-remoteapp/

1. Setup Remote access on Windows machine that will act as the 'server'

Steps to do in Windows (screen shots are from Windows 7)

Create a User account for yourself in Windows

Click on Start
Right-Click on Computer
Select & click on Properties

After clicking on Properties you will see the following menu on which you need to select/click-on “Remote settings” in the upper-left.

On the next screen that is presented click on the Tab labeled Remote.

Then select the option:

 “Allow connections from computers running any version of Remote Desktop (less secure)”

Click on the “Select Users” button and you will see this menu screen.

Next, click the Add button and in this menu enter your Windows 7 UserID.

Click Check Names.

Click OK to return to the previous menu and you should see your Windows UserID now listed as authorized for Remote Desktop.

Click OK to save this UseriD as a user allowed to use Remote Desktop.

Now we can start some of the interesting configuration for Windows.

Note:  The reason why it must be a Windows 7 Ultimate or Enterprise version is that both of those are “capable” of supporting Microsoft’s RemoteApp as a “RemoteApp Server” but unfortunately Microsoft  made the decision to not make that capability readily useable.

Ref: portions copied from..

https://bmullan.wordpress.com/2012/09/17/howto-integrate-windows-apps-into-the-ubuntu-linux-desktop-using-windows-remoteapp/

2. Setup (Publish) Remote apps on 'server'

I used kim knight remote app tool.

A person named Kim Knight built a GUI based application called RemoteAppTool that you can download from here:
http://www.kimknight.net/remoteapptool
Download and Install the RemoteAppTool into your Windows Virtual Machine (VM).
Note: The RemoteAppTool requires .NET .
After installation of the RemoteAppTool you need to start installing your Windows Applications that you will want available on your Ubuntu system.
Create an entry for Windows Write in the remote app tool.

Click the green plus sign and use the file browsing window to locate Write in c:\windows folder.

I read that it may be necessary to use %windir% rather than c:\windows in the path and vpath.

Save it.
Press create client connection ( Its in the bottom right corner)

These next instructions are older and may not be correct or needed (Use the screenshots above).

Right-Click on the Windows Icon for Kim Knight’s RemoteAppTool program and select to start it as an Administrator.
Note: this is why you need to be an Admin or able to log-in as an Admin on the Windows VM
After the RemoteAppTool starts you will see its GUI Menu.
Click on the “New” button
Enter any meaningful name for your RemoteApp
At the next screen (RemoteApp Properties Entry screen) click on the 3 dots (…) to the right of the PATH entry which will bring up Windows Explorer. Use Explorer to search your system for ANY application you want to associate with this RemoteApp “name”.
After you double-click on the .exe name of the Windows program you want to make a RemoteApp… all the rest of the fields in the RemoteAppTool menu should be filled in automatically.
When the form is complete REMEMBER to Click SAVE !
NOTE: Once you click SAVE your application is available from the Windows 7 VM as a Windows RemoteApp !

Registry change may be necessary ..

See:

http://stanev.org/winconn/AllowReamoteAPP.reg

It contains..

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Terminal Services]"fAllowUnlistedRemotePrograms"=dword:00000001

3. Install Freerdp Prerequisites on Linux machine that will act as the 'client'

A: Linux Mint XFCE, based on Ubuntu 16.04:

xfreerdp v1 is installed. It's good to go. Go to step 4.

B: This is on ubuntu 14.04 :

Get dependencies list...

albe@v206c:~$ sudo dpkg -I /home/albe/Downloads/freerdp-nightly_2.0.0+0~20170123165138.331~1.gbpd34291_amd64.deb

new debian package, version 2.0.

...

Package: freerdp-nightly

Version: 2.0.0+0~20170123165138.331~1.gbpd34291

Maintainer: FreeRDP

Depends: libasound2 (>= 1.0.16), libavcodec-ffmpeg56 (>= 7:2.4) | libavcodec-ffmpeg-extra56 (>= 7:2.4), libavutil-ffmpeg54 (>= 7:2.4), libc6 (>= 2.15), libcups2 (>= 1.4.0), libglib2.0-0 (>= 2.41.1), libgsm1 (>= 1.0.13), libgstreamer-plugins-base1.0-0 (>= 1.0.0), libgstreamer1.0-0 (>= 1.4.0), libjpeg8 (>= 8c), libpulse0 (>= 0.99.1), libssl1.0.0 (>= 1.0.0), libudev1 (>= 183), libusb-1.0-0 (>= 2:1.0.8), libx11-6 (>= 2:1.2.99.901), libxcursor1 (>> 1.1.2), libxdamage1 (>= 1:1.1), libxext6, libxfixes3, libxi6 (>= 2:1.2.99.4), libxinerama1, libxkbfile1, libxrender1, libxtst6, libxv1

...

Install Dependencies:

I haven't finished this yet.

4. Install Freerdp Nightly

Visit Pre-builds in freerdp wiki..

https://github.com/FreeRDP/FreeRDP/wiki/PreBuilds

Visit.. https://ci.freerdp.com/job/freerdp-nightly-binaries/architecture=amd64,distribution=xenial,label=pkg-deb/

Open deb with gdebi:

https://ci.freerdp.com/job/freerdp-nightly-binaries/architecture=amd64,distribution=xenial,label=pkg-deb/lastSuccessfulBuild/artifact/freerdp-nightly_2.0.0+0%7E20170123165138.331%7E1.gbpd34291_amd64.deb
install it.

5. Run it.

example command..

/opt/freerdp-nightly/bin/xfreerdp /u:dg /p:x /app:"||Windows Write" /v:192.168.88.60
This starts up Windows Write in a window and you are finished.

You can publish cmd.exe and/or windows explorer and then access many programs with only one or two things published as remoteapp.

Other examples using wfreerdp on a windows client..

wfreerdp /u:andyz /d:stackpole.ca /p:password /app:"||calc" /v:data2
wfreerdp /d:stackpole.ca /w:1890 /h:990 /v:data2

Windows nightly..
https://cloudbase.it/freerdp-for-windows-nightly-builds/

see: https://github.com/FreeRDP/FreeRDP/wiki/CommandLineInterface

see: https://github.com/FreeRDP/FreeRDP/wiki/RemoteApp

Saturday, July 25, 2015

Trying out Allcountjs Javascript Web App Framework for Rapid Application Development

allccountjs

2015-07-24 10:52PM -- 7/27 Ver 07

Summary: This is a node.js, mongodb, angular, express, based full stack javascript framework for creating web apps.
Category:
RAD -- Rapid App Develeopment

Purpose: Install on Windows my 'redek' computer to test this out.

See https://github.com/dgleba/toptal-community-allcount for the code.

I followed this article:

http://www.toptal.com/nodejs/rapid-application-development-with-allcountjs

by: Pavel Tiunov @paveltiunov

Install these software

node.js mongodb git

C:\n\01software\mongodb-win32-x86_64-2008plus-ssl-3.0.4-signed.msi
C:\n\01software\node-v0.12.7-x64.msi
C:\Users\dg\Downloads\Git-1.9.5-preview20150319.exe

mkdir toptal-community-allcount  
cd toptal-community-allcount  
npm install allcountjs

cd C:\n\nodeprj\toptal-community-allcount

mkdir toptal-community-repo
cd toptal-community-repo

Create main.js in

C:\n\nodeprj\toptal-community-allcount\toptal-community-repo

start mongodb

C:\p2\MongoDB\Server\3.0\bin\mongod.exe --dbpath C:\n\nodeprj\mongodata

ref:

http://blog.ajduke.in/2013/04/10/install-setup-and-start-mongodb-on-windows/

start the app

cd ..
which is...

cd C:\n\nodeprj\toptal-community-allcount

"C:\n\nodeprj\toptal-community-allcount\node_modules.bin\allcountjs.cmd" --git toptal-community-repo --db mongodb://localhost:27017/toptal-community

http://localhost:9080/

visit this address and sign in with admin admin.

works!

import data

cd C:\n\nodeprj\toptal-community-allcount

run:

npm install xml2js
npm install request
npm install q
npm install moment

The following parts show steps I took that were not what was in the article -- I misunderstood.

Wrong:

create
C:\n\nodeprj\toptal-community-allcount\toptal-community-repo\toptal-community.js

start app again as before.

wrong:

"C:\n\nodeprj\toptal-community-allcount\node_modules.bin\allcountjs.cmd" --git toptal-community-repo --db mongodb://localhost:27017/toptal-community

got error:

This is system is fantastic!!!!

I am getting an error with the import feature.

C:\n\nodeprj\toptal-community-allcount\node_modules\allcountjs\node_modules\q\q.
js:126
throw e;
      ^
Error: toptal-community.js:1
var request = require('request');
              ^
ReferenceError: require is not defined
at toptal-community.js:1:15

The app starts and works before I add the toptal-community.js file. The file to add the import feature.

I am new to js frameworks.
Can someone help?

Answer:

ref: https://groups.google.com/d/msg/allcountjs/9C5A2qrrdHQ/rJxJ1e22jb0J

toptal-community.js was in wrong folder.

create
C:\n\nodeprj\toptal-community-allcount\toptal-community.js

edit main.js to call the import feature.

Start the app with:

cd C:\n\nodeprj\toptal-community-allcount  
node toptal-community.js

Works!

Add cards feature per article.

create events.js

edit main.js to call that view.

Works!

This is a great system!!

David Gleba

Wednesday, July 8, 2015

New.ampp.server.stack

New ampp server stack

2015-07-08Wed06.02-AM - 2015-07-12 rev 9

5. The current way

Use xampp or pre-made stack. I figure it is a stack tested by users actually using it.

Definitions:

Ampp: apache mysql php python [python for us... some use perl]

Stack: a collection of software in a usable combination resulting in a web site/app.

10. Compiler Issue

Windows amp software binaries are compiled with a variety of microsoft compiler versions denoted by vc9 vc10 vc11 etc.

If the versions of each binary don't match well a software binary like php, python, etc. may not run properly.

15. Python binaries, compilers, and others

Python seems to be vc9 or vc10

Apache and PHP are moving on to vc11 and vc14 for later versions. They are dropping vc9 / vc10.

This is creating a situation where it is harder to find binaries that all work together.

ref:
..
need to find web references to this.

20. Needs / Wants

It would be nice to have a newer ampp stack with the software we want.

I looked at ampps, xampp, and others.

see gsheet:
https://docs.google.com/spreadsheets/d/1AFIbGWJuyt01jwmQ9WVD76I1DomrxoDrtdw1MAupcqg/edit?usp=sharing

30. Manually installed stack - DAMP

I Manually installed a stack - Let's call it - DAMP by David Gleba

It has many packages in c:\p2\damp and others in c:\p2\python34 and Mysql in c:\Program Files because Mysql allows no other path using the installer.

Some of it is portable in the sense that the damp folder can simply be copied to another computer. Then use installers to install python, mysql, and filezilla FTP server.

Damp req'ts:

These are decisions made. Just follow them and many things will just work with on further setup or configuration.

must be in c:\p2\damp
doc root must be in c:\p2\damp\htdocs
use installer for mysql, it goes in c:\Program Files
use installer for python, it goes in c:\p2\python34
use installer for filezilla FTP server, it goes in c:\p2\damp\filezillaFTPserver

Notes on how I installed it are here:
...

Question posted

I asked the question: Is this setup reliable?

See Here:

...

90. How to test that it all works reliably?

That is the question.

.end.

Wednesday, July 1, 2015

Apache-Mysql-php-python Ampp install -- damp - Windows

Apache php mysql python mod_wsgi install - manually on Windows

2015-07-05 , rev 2015-07-10 Ver 45

1. this document shows several attempts....

This document shows several attempts at finding a combination of packages that works together. See #40. That is where I actually started getting somewhere.

10. see also

stack,web,amp,xampp.gsht - manualinstall tab. sheet1 tab compares software versions. 2015-06-28Sun12.12-PM
https://docs.google.com/spreadsheets/d/1AFIbGWJuyt01jwmQ9WVD76I1DomrxoDrtdw1MAupcqg/edit?usp=sharing

15. Graham posts what to use for mod_wsgi.

https://github.com/GrahamDumpleton/mod_wsgi/blob/develop/win32/README.rst

28. I didn't use this section.... php 5.4.42 vc9 download

"VC9 x86 Thread Safe (2015-Jun-11 01:49:48) Zip [16.47MB] sha1: 7f106152261a04dc3547f0f31b4563cefbe402f4"
http://windows.php.net/download/

29. I didn't use this section.... Struggling to find packages that should work together...

2015-06-28Sun12.56-PM
vc10 w64: py 3.4 ap24 modwsgi php is vc 9 11 or 14
http://www.easyphp.org/easyphp-devserver.php
for Windows 7 and 8 Windows 2012 - EasyPHP DevServer 14.1 VC11 - This version supports : PHP 5.6.x / 5.5.x / 5.4.x / 5.3.x - VC9, VC10 and VC11 VC11 builds don't run on XP and 2003 but load VC9 and VC10 builds. - All PHP versions can be used (VC9, VC10 and VC11). ref. http://www.easyphp.org/easyphp-devserver.php
PHP 5.5 (5.5.26) - VC11 x64 Non Thread Safe (2015-Jun-11 02:03:05) Note: x64 builds are currently experimental
conclusion:

x64 php is experimental
may be able to use php vc11 with apache vc10. - 2015-06-28

40. Use w32 vc10 - for apache python and mod_wsgi

vc10 w32:
- py 3.4, ap24, mod_wsgi vc11: - php 5.6 w32 (w64 is experimental) [Cannot find vc10 binary for php 5.6] mysql: - w64

45. Download..

follow: https://github.com/GrahamDumpleton/mod_wsgi/blob/develop/win32/README.rst
Apache 2.4 win32 VC10 binary http://www.apachelounge.com/download/win32/ http://www.apachelounge.com/download/win32/binaries/httpd-2.4.12-win32.zip
http://www.microsoft.com/en-us/download/details.aspx?id=30679 download: vcredist 2012 update 4 - w32

php 5.6 http://windows.php.net/download/ http://windows.php.net/downloads/releases/php-5.5.26-Win32-VC11-x86.zip thread safe
Somehow i didn't use this one, not sure why. http://windows.php.net/downloads/releases/php-5.6.10-Win32-VC11-x86.zip PHP 5.6 (5.6.10) VC11 x86 Thread Safe (2015-Jun-11 02:33:47)

Python 3.4.3 - 2015-02-25 https://www.python.org/downloads/windows/ https://www.python.org/ftp/python/3.4.3/python-3.4.3.msi w32 vc10

modwsgi https://github.com/GrahamDumpleton/modwsgi/blob/develop/win32/README.rst https://github.com/GrahamDumpleton/mod_wsgi/releases https://github.com/GrahamDumpleton/modwsgi/releases/download/4.4.12/modwsgi-windows-4.4.12.tar.gz

https://dev.mysql.com/downloads/windows/installer/ 5.6.25

phpmyadmin http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.4.10/ http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.4.10/phpMyAdmin-4.4.10-english.zip/download

50. unpack and install

create .gitignore and create git repo to track edits I make to the settings.

I am following this: http://superuser.com/questions/748117/how-to-manually-install-apache-php-and-mysql-on-windows

I unpack apache into c:\p2\damp\apache
run httpd.exe from command prompt
need msvcr100.dll -- install 2012 vcredist x86
set paths in httpd.conf
win10: no error but httpd just sits there. localhost will not work.
win10: didn't get firewall request to add httpd to the allowed list.
win7: asked to add to firewall. it works.
copy php.ini-'dev' to php.ini
enable php in httpd.conf
test it. it works.
apache and php are working.
This will print a text file of the last 1 changes. >>> git format-patch -1 head --stdout > patch5630a.txt

Install apache as a service.

C:\p2\damp\apache\bin\httpd.exe -k install

C:\Windows\system32>C:\p2\damp\apache\bin\httpd.exe -k install Installing the 'Apache2.4' service The 'Apache2.4' service is successfully installed. Testing httpd.conf....

Mysql

From: C:\p2\damp\,this,\mysql-installer-community-5.6.25.0.msi

install mysql. it would only go in program files. No other choice was offered.
I installed win64, 64bit.
(next time do this later) made user dg417 passwd
root
done. ok.

55. Phpmyadmin:

https://wiki.phpmyadmin.net/pma/Quick_Install

cd phpMyAdmin mkdir config # create directory for saving http://localhost/phpMyAdmin/setup/ ## run setup

had to edit php.ini for mbstring ext. lots of edits. see git commit

Testing my 'prodrpt' app

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" --user=root -p -e "create database prodrptdb";
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" --user=root -p prodrptdb < C:\p2\damp\htdocs\2test\prodrpt\documents\bkups\prodrptexp.sql

Set default collation in mysql.
This didn't do it: SET NAMES 'utf8';
The following worked. It's in my.ini

David Gleba set default collation...
collationserver=utf8unicode_ci
charactersetserver=utf8

Try this next time:

CREATE USER 'dg417'@'localhost' IDENTIFIED BY '**';
CREATE USER 'dg417'@'%';
GRANT USAGE ON . TO 'dg417'@'localhost' ;
GRANT ALL PRIVILEGES ON prodrptdb. TO 'dg417'@'%';

60. Install python mod_wsgi module

C:\p2\Python34\

install wsgi module, w32 vc10 ap24 py34.
edit httpd.conf
install python 3.4 w32

cd C:\p2\Python34\Scripts
pip install Django
django get-pip.py
pip install Django

Successfully installed django-1.8.2

pip install django-admin-bootstrapped

Successfully installed django-admin-bootstrapped-2.5.2

I got error on trakberry app but the other two apps work.

Request Method: GET
Request URL: http://localhost:8986/trakberry/admin/
Django Version: 1.8.2
Exception Type: ImportError
Exception Value:
No module named 'views'

90. Summary

Working - per my basic testing by starting them up in a web page: Apache, mysql, php, python, django, xataface, codeigniter, yii, 2015-07-01Wed18.49-PM
I think the damp folder is portable. Install mysql and python using the installers. Everything except for mysql and python are in the c:\p2\damp folder.
files used:

httpd-2.4.12-win32-vc10(apache).zip
modwsgi-4.4.12-ap24-py34-VC10-w32.so
Graham Dumpleton's modwsgi-windows-4.4.12.tar.gz
mysql-installer-community-5.6.25.0,win32-and-win64.msi
php-5.5.26-Win32-VC11-x86.zip
phpMyAdmin-4.4.10-english.zip
python-3.4.3.msi (w32, all python windows is vc10 )
vcredist_x86-2012update4.exe

100. Question

I manually installed apache, python, modwsgi, mysql and php. I matched the compiler version -VC10, for python, apache, and modwsgi. I couldn't find a VC10 binary for PHP 5.5 so I used vc11. Mysql is the 64bit community binary.
Everything seems to be working OK.
Will the combination of vc10/11 compiler and 32/64 bit versions I used work ok, or will it lead to problems? Is there a way to test it other than just using it?

Windows	version	bits	vc
Apache	2.4.12	w32	vc10
Python	3.4.3	w32	vc10
MySQL	5.6.24	w64	?
PHP	5.5.26	w32	vc11

More detailed notes of my installation are at: http://davidgleba.blogspot.ca/2015/07/apache-install-2015-06-28-2md.html

Note: made the installation on st-dgleba machine. 2015-07-01.

105.

I added filezilla server. 2015-07-07 May be best to install over top using installer when installing this on another machine. It will install the service.

110. Compatibility

"although some docuentation suggests that VC10 and VC11 are compatible with each other, I make no guarantee of this." http://forum.wampserver.com/read.php?2,128113,128268

115. Mysql users.

Removed 'any' user see screenshots in dropbox. ver7 2015-07-10Fri12.22-PM C:\n\Dropbox\csd\computer\damp-2015-07-01\mysqlinstallnotes

120. enable mod_rewrite

uncomment this line in httpd.conf:

LoadModule rewrite_module modules/mod_rewrite.so

This won't display correctly. don't copy and paste this...
AllowOverride none Require all denied
DocumentRoot "c:/p2/damp/htdocs" <Directory "c:/p2/damp/htdocs"> Options Indexes FollowSymLinks Includes ExecCGI AllowOverride All Require all granted
Find any additional occurrences of the line “AllowOverride None” and change it to “AllowOverride All”.
Used some info of this link below and other info copied from xampp httd.conf. http://www.webdevdoor.com/php/mod_rewrite-windows-apache-url-rewriting/
ver 8 of damp, 2015-07-10Fri19.13-PM no zip/7z file made.

.end.

-

lenovop500redekfreshwin8.1-cute.md

Redek, Lenovo p500 corei7 install fresh win8.1

2015-07-01Wed11.30-pm -- 7/8 Ver 29

Note. fresh install - not upgrade.

this mentions the bios:

https://www.lenovo.com/shop/americas/content/userguides/zug_en.pdf

On Jul 1, 2015, at 7:22 AM, d gleba dgleba@gmail.com wrote: I am using that win81 image you recommended for me. I am getting the following error. See attached image.

It says windows cannot be installed on drive 0 partition 5. Windows cannot be installed on this disk. The selected disk is of the GPT partition style.

Can you help?

boot bios

fn f2 when powering up.

http://tipsandtricksforum.com/thread-245.html

These instructions are to make a gpt uefi bootable usb disk. It worked.

I used rufus:

Device: select your USB flash drive Partition scheme and target system type: select GPT partition scheme for UEFI computer File system: select FAT32 Cluster size: select Default Format Options: Quick format: checked Create a bootable disk using: select ISO Image then click on icon and select your ISO file. Create extended label and icon files: checked took over 50 min to make it.

This worked. it boots and allows me to install windows.
I had to let lenovo startup routine happen.
It wants to repair the computer.
Then select advanced options.
Boot from efi usb device.
Install windows.

Problem

I discovered that the computer will not shut down properly. the screen goes black the keyboard light is on, and the fans are running. it just sits there like that.

I installed most of the drivers on the lenovo site. Still won't shutdown.

updated bluetooth driver from device manager. 2015-07-06 7am.

unchecked a bunch of items in device manager like bluetooth intel properties / power management / allow the computer to turn off this device to save power.

mouse/ allow this device to wake the computer.

706 559pm

installed audio driver from lenovo drivers site.

turned on windows update, later set to automatic updates.

got message about power management conflict with windows. see screen shots. no idea to to deal with it.

"C:\n\Dropbox\,0,drp,dg\lenovowillnotshutdownredek\redek lenovo power problem Screenshot - 762015 , 70604 PM (1).png"

got message from action center re card reader driver. I acted by clicking the link. dl the driver. installed.

I think it still didn't shutdown after all this.

2015-07-07 - 7am this morning -- it works. it shuts down.

.end.

Thursday, December 19, 2013

Welcome document

Welcome to StackEdit!

Hello, I am your first Markdown document within StackEdit1. Don’t delete me, I can be helpful. I can be recovered anyway in the Utils tab of the Settings dialog.

Documents

StackEdit stores your documents in your browser local storage, which means all your documents are automatically saved locally and are accessible offline.

NOTE: This also means that your documents are not shared between different browsers or computers and that clearing your browser’s data may delete all of them!

Create a document

You can create a new document by clicking the button in the navigation bar. This will switch from the current document to the new one.

Switch to another document

You can list all your local documents and switch from one to another by clicking the button in the navigation bar.

Rename a document

You can rename the current document by clicking the document title in the navigation bar.

Delete a document

You can delete the current document by clicking the button in the navigation bar.

Save a document

You can save the current document to a file using the Save as... sub-menu.

NOTE: See Publish a document section for a description of the different outputs.

Synchronization

StackEdit can be combined with Google Drive and Dropbox to have your documents centralized in the Cloud. The synchronization mechanism will take care of uploading your modifications or downloading the latest version of your documents.

NOTE:

Full access to Google Drive or Dropbox is required to be able to import any document in StackEdit.

Imported documents are downloaded in your browser and are not transmitted to a server.

If you experience problems exporting documents to Google Drive, check and optionally disable browser extensions, such as Disconnect.

Import a document

You can import a document from the Cloud by going to the Google Drive or the Dropbox sub-menu and by clicking Import from.... Once imported, your document will be automatically synchronized with the Google Drive / Dropbox file.

Export a document

You can export any document by going to the Google Drive or the Dropbox sub-menu and by clicking Export to.... Even if your document is already synchronized with Google Drive or Dropbox, you can export it to a another location. StackEdit can synchronize one document with multiple locations.

Synchronize a document

Once your document is linked to a Google Drive or a Dropbox file, StackEdit will periodically (every 3 minutes) synchronize it by downloading/uploading any modification. Any conflict will be detected, and a local copy of your document will be created as a backup if necessary.

If you just have modified your document and you want to force the synchronization, click the button in the navigation bar.

NOTE: The button is disabled when:

you are offline,

or the document is not synchronized with any location,

or the document has not been modified since the last synchronization.

Manage document synchronization

Since one document can be synchronized with multiple locations, you can list and manage synchronized locations by clicking Manage synchronization in the menu. This will open a dialog box allowing you to add or remove synchronization links that are associated to your document.

NOTE: If you delete the file from Google Drive or from Dropbox, the document will no longer be synchronized with that location.

Publication

Once you are happy with your document, you can publish it on different websites directly from StackEdit. As for now, StackEdit can publish on Blogger, Dropbox, Gist, GitHub, Google Drive, Tumblr, WordPress and on any SSH server.

Publish a document

You can publish your document by going to the Publish on sub-menu and by choosing a website. In the dialog box, you can choose the publication format:

Markdown, to publish the Markdown text on a website that can interpret it (GitHub for instance),
HTML, to publish the document converted into HTML (on a blog for instance),
Template, to have a full control of the output.

NOTE: The default template is a simple webpage wrapping your document in HTML format. You can customize it in the Services tab of the Settings dialog.

Update a publication

After publishing, StackEdit will keep your document linked to that publish location so that you can update it easily. Once you have modified your document and you want to update your publication, click on the button in the navigation bar.

NOTE: The button is disabled when:

you are offline,

or the document has not been published anywhere.

Manage document publication

Since one document can be published on multiple locations, you can list and manage publish locations by clicking Manage publication in the menu. This will open a dialog box allowing you to remove publication links that are associated to your document.

NOTE: In some cases, if you remove the file from the website or the post from the blog, the document will no longer be published on that location.

Markdown Extra

StackEdit supports Markdown Extra, which extends Markdown syntax with some nice features.

NOTE: You can disable any Markdown Extra feature in the Extensions tab of the Settings dialog.

Tables

Markdown Extra has a special syntax for tables:

Item	Value
Computer	$1600
Phone	$12
Pipe	$1

You can specify column alignment with one or two colons:

Item	Value	Qty
Computer	$1600	5
Phone	$12	12
Pipe	$1	234

Definition Lists

Markdown Extra has a special syntax for definition lists too:

Term 1
Term 2: Definition A; Definition B
Term 3: Definition C; Definition D

part of definition D

Fenced code blocks

GitHub’s fenced code blocks are also supported with Prettify syntax highlighting:

// Foo
var bar = 0;

NOTE: To use Highlight.js instead of Prettify, just configure the Markdown Extra extension in the Settings dialog.

Special Attributes

With Markdown Extra, you can specify class and id attributes on headers and fenced code blocks just like this:

Header example

var foo = bar;

Then you can create cross-references like this: beginning of the document.

Footnotes

You can create footnotes like this2.

SmartyPants

SmartyPants converts ASCII punctuation characters into “smart” typographic punctuation HTML entities. For example:

	ASCII	HTML
Single backticks	`'Isn't this fun?'`	‘Isn’t this fun?’
Quotes	`"Isn't this fun?"`	“Isn’t this fun?”
Dashes	`-- is an en-dash and --- is an em-dash`	– is an en-dash and — is an em-dash

You can insert a table of contents using the marker [TOC]:

MathJax

You can render LaTeX mathematical expressions using MathJax, as on math.stackexchange.com:

The Gamma function satisfying $\Gamma(n) = (n-1)!\quad\forall n\in\mathbb N$ is via the Euler integral

Γ (z) = \int \infty 0 t z - 1 e - t d t .

$\Gamma(z) = \int_0^\infty t^{z-1}e^{-t}dt\,.$

NOTE: When exporting, make sure you include MathJax to render mathematical expression correctly. Your page/template should include something like:

<script type="text/javascript" src="https://stackedit.io/libs/MathJax/MathJax.js?config=TeX-AMS_HTML"></script>

NOTE: You can find more information:

about Markdown syntax here,

about Markdown Extra extension here,

about LaTeX mathematical expressions here,

about Prettify syntax highlighting here,

about Highlight.js syntax highlighting here.

Written with StackEdit.

StackEdit is a free, open-source Markdown editor based on PageDown, the Markdown library used by Stack Overflow and the other Stack Exchange sites. ↩
Here is the text of the footnote. ↩