-
- Preview browser
- Page designer
- DQL editor
- Application wide settings
- Security settings
- Page caching module
- Modules
- Snippets
- Actions
- Context editor
- Task editor
- Scheduler editor
- Search engine editor
- Web server console
- Site layout editor
- Template editor
- Robots editor
- Style definitions
- Database manipulation
- Table designer
- Transfer editor
- Reporter
- Deployment module
- Deployment server settings
- Debugger
- .end
- .form header
- .form trailer
- .items
- assign
- application status
- backup db
- begin transaction
- break
- call menu
- call program
- case
- cluster by
- commit
- connect
- copy all from
- data-entry
- db status
- delete records
- define
- disconnect
- do
- documents
- exec SQL
- else
- end
- enter a record
- error messages off
- error messages on
- exit
- export
- for
- global
- if
- import
- imports
- in
- input using
- install application
- into
- list records
- lock
- lock db
- modify records
- message
- named
- others
- prompt
- query selection
- record entry
- records
- reorganize
- restore db
- rollback
- run procedure
- servers
- temp
- then
- tran off
- tran on
- unclustered
- unlock
- unlock db
- via form
- while
- with
- abs
- acos
- addressof
- ampm
- anylookup
- asin
- atan
- atan2
- ceil
- CHR
- concat
- ConsoleCopy
- ConsoleMemoCopy
- ConsoleShow
- ConsoleWriteToFile
- cos
- cosh
- date
- DatePicker
- day
- DEOS
- DialogOpen
- DialogOpenRelated
- DocumentCloseName
- DoesObjectExist
- ExecDQL
- ExecuteFile
- exp
- FileExecDQL
- firstc
- firstlast
- firstw
- FixedWidth
- floor
- futurevalue
- GetCurrent
- GetVar
- hours
- if
- installment
- jointext
- julian
- lastc
- lastfirst
- lastw
- length
- log
- log10
- lower
- MemoChunk
- MemoCopy
- MemoDecodePair
- MemoExecDQL
- MemoFind
- MemoGetGlobal
- MemoLength
- MemoMemoCopy
- MemoMemoReplace
- MemoReadFromFile
- MemoReplace
- MemoSetGlobal
- MemoStringBetween
- MemoStringFrom
- MemoStringTo
- MemoWordCount
- MemoWriteToFile
- midc
- midw
- minutes
- mod
- month
- OpenForm
- OpenMenu
- OpenProcedure
- OpenReport
- periods
- power
- presentvalue
- proper
- random
- rate
- RefreshForm
- RefreshScreen
- RefreshStatus
- Remote
- Remote authentication
- Remote POP3
- Remote IMAP
- Remote SMTP
- Remote XML
- seconds
- SetColor
- SetCurrent
- SetFocus
- SetLabelText
- SetMemoValue
- SetState
- SetStyle
- SetValue
- SetVar
- sin
- sinh
- spellcurrency
- spelldate
- spellmonth
- spellnumber
- spellweekday
- sqrt
- StringBetween
- StringEscape
- StringFind
- StringFrom
- StringReplace
- StringTo
- tan
- tanh
- textpos
- timeampm
- ToText
- UniqueID
- upper
- Wait
- weekday
- WriteToFile
- year
- yearday
- yearweek
- " (quotation marks)
- () (parentheses)
- + (addition)
- , (comma)
- - (subtraction)
- . (period)
- -- (comment)
- / (division)
- * (multiplication)
- * (asterisk)
- ? (question mark)
- ~ (tilde)
- : (colon)
- := (assignment operator)
- ; (semicolon)
- < (less than)
- <= (less than or equal to)
- = (equals)
- > (greater than)
- >= (greater than or equal to)
- all
- all files
- and
- any
- between
- blank
- count
- count of
- file
- highest of
- in groups
- in groups with group-totals
- in order
- in reverse
- item (Statistical)
- item (Conditional Statistical)
- lock files
- lock nothing
- lock records
- lookup
- lowest of
- max
- mean
- mean of
- min
- not
- number
- numeric string
- or
- pause
- percent
- selected record
- std.dev.
- std.err.
- sum
- sum of
- text
- time
- to
- variance
- window
- Rules for queries
- * (asterisk)
- ? (question mark)
- ~ (tilde)
- and
- or
- not
- ( ) (parentheses)
- Debug querys
- Livetext tags
- xdg3 query
- Sessions
- Pagination
- Free text search
- Intro on fields
- Text
- Hidden
- Date
- Dropdown
- List
- Checkbox
- Radio button
- Text edit
- Redactor (richtext)
- CKEditor
- TinyMCE
- Intro
- hasPrismConnection
- doAction
- doDerivation
- doMenuItem
- doPrismDerivation
- setFormField
- runPrismFunction
- @GetDefinition
- . document
- . listcommands
- . listdocuments
- . listdrives
- . listfiles
- . listfunctions
- . listinternals
- . listoperators
- . listrelated
- . listtables
- . object
- . table
- . testdql
- @SetDefinition
- . document
- . object
- Extra modules intro
- python
- Qt
- wkhtmltopdf
- PySide
- PyXCC
- django
- Apache
- LightTPD
- nginx
- pywin32
- flup
- cssutils
- Pillow
- psutil
- mysqldb
- psycopg2
- pyodbc
- python_dateutil
- requests
- suds-ews
- setuptools
- Whoosh
- wmi
- django-send
- bootstrap
- bootstrapmultiselect
- jquery
- jqueryui
- ckedit
- tinymce
- redactor
- JavaScript EU VAT Number Validation
- feedparser
- beautifulsoup
- appsdir
- six
- pycparser
- pyOpenSSL
- cryptography
- cffi
- enum34
- pyasn1
- idna
- ipaddress
- PyYAML
- coverage
- coveralls
- docopt
- mock
- funcsigs
- pbr
- nose
- paypalrestsdk
- paypal
- libcurl
- 7zipcpp
- cef
- cpp-jwt
SSL certificates converting
Getting the right type of ssl certificates can be a pain. Here are some notes on how to get existing certificates and convert them to types we can use in DG3.
Basically to get a secure http connection, you need a few certificates that will be installed on your server. First you need the private key. This is the one that no other than you should have. Then you need a certificate that validates your domain. This can be for a single sub domain (ex. shop.dataease.com) or for all sub domains (ex. *.dataease.com). The last type is called a star domain and can be used to validate all sub domains (in this case: www.dataease.com, licenses.dataease.com, shop.dataease.com etc.). This certificate must be signed by a CA (Certificate Authority). This can be you (self signed) but then no browser will let you watch the page without displaying warnings that you must make an exception for. The best thing to do is using a recognized CA like Verisign, Comodo, GoDaddy, StartSSL etc. These will usually not use their master key for you signing, but another one that is signed by the master key. This means that for the web browser to recognize your certificate, you must give it a chain back to the recognized key that is installed by default in your browser.
So what we need to install a SSL certificate in your DG3 server is, private key, CA signed certificate and the chain delivered by the CA. These files usually have the names somename.key, somename.crt and comename.pem. The .key are your private key, the .crt are the certificate you got from the CA and the .pem are the chain back to the installed browser root certificate for the CA.
There are several other formats for the certificates as well, but usually you can convert them back to the format needed way or other. To do that you can use the tools delivered with DG3 in the form of the openssl.exe command line tool. This document describes the manual method of doing this.
IIS server certificates
If you have an IIS server where you have used the windows tools to create CSR and private keys, will not be found as files on you server. To get the certificates, you will need to export them. This can be done like described here:
- Open IIS Manager
- In Features View, double click Certificates
- Select certificate en click export
- Give it a name and a password (take notes of this password as you will need it later)
What you got from IIS is a .pfx file. From this file you can extract the .key file by:
openssl pkcs12 -in certificate.pfx -nocerts -nodes -out privatekey.key openssl rsa -in privatekey.key -out privatekey.key
You will be asked for password in the process. The last step decrypts and remove the password for use in the server. Now you have the private key.
If you do not have the public key either, you can extract this form the pfx file as well.
openssl pkcs12 -in certificate.pfx -clcerts -nokeys -out certificate.crt<br>
You will be asked for password in the process. Now you have two of the components needed by our server. The chains can be downloaded from the CA.
Lighttpd ssl sertificates
The lighttpd server sertificates we set up in DG3 are stored in the apllication under ssl and under webserver ssl for the main definition. Ex
C:\inetpub\DeployedDG3Apps4\webserver\lighttpd\ssl for the server and C:\inetpub\DeployedDG3Apps4\MyApp\ssl for the application.
The names of the two needed files are always cert.pem for the combined certificate (private and immediate certificate in one file) and a ca-bundle.crt for the chain from the certifying authority. This mean you have to have our private.key in rsa format and the certificate given from the certifyer and combine them into one file your self.
# convert private key to rsa openssl rsa -in <a href="http://www.example.com.privatekey.key">www.example.com.privatekey.key</a> -out privatekey.key # create the combined file type privatekey.key <a href="http://www.example.com.crt">www.example.com.crt</a> > cert.pem<br>
This is the commands in DOS prompt
$SERVER["socket"] == ":443" { ssl.engine = "enable" ssl.pemfile = cert_dir + "cert.pem" ssl.ca-file = cert_dir + "ca-bundle.crt" #Config for redirecting sites from https $HTTP["host"] == "www.example.com" { server.document-root = "/cygdrive/c/inetpub/DeployedDG3Apps4/MyApp/html" ssl.ca-file = "/cygdrive/c/inetpub/DeployedDG3Apps4/MyApp/ssl/ca-bundle.crt" ssl.pemfile = "/cygdrive/c/inetpub/DeployedDG3Apps4/MyApp/ssl/cert.pem" ...
The lighttpd.conf file part for ssl look something like this