windows 10 annoyance and the state of linux

- 6 month into the lifespan of windows 10
- a lot of justified and unjustified bashing from the world
- for me only minor annoyance but looking into the future

any linux distro with 5 or 10 years support ?

checking the OOBE of some linux distros on a HP 350 G2 K9K08EA,
a laptop released/available since 2015-06 with a Broadwell CPU.

Fedore 23 (released 2015-11)
- network (LAN) not working

Mint 17.3 Mate (released 2015-12)
- all ok


passing null-terminated string from 3rd party DLL to Microsoft Access 2003

target audience:
    people w/ no control over the DLL-source, unable to change behavior of DLL

    people who don't want to pass an input-parameter to the DLL, which will be filled w/ the result in most other cases

    people who want to call a callback-function/sub inside Access

recommended reading:
http://msdn.microsoft.com/en-us/library/ms811463 or

more reading:

my working sample:
Option Compare Database
Option Explicit

Declare Sub WebGISConn_init Lib "P:\doswin\LDA\IPFLink\20110920\IPFLink.dll" Alias "IPFLink_init" (ByVal WebGISConn_CallBack As Long)
Declare Sub WebGISConn_showFeaturesInIMS Lib "P:\doswin\LDA\IPFLink\20110920\IPFLink.dll" Alias "IPFLink_showFeatureIDStringWithInterfaceInIMS" (ByVal feats As String, ByVal interf As String)

Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (pDst As Any, pSrc As Any, ByVal ByteLen As Long)
Declare Function lstrlenA Lib "kernel32" (ByVal lpString As Long) As Long
' testwrapper for easy call from "immediate window"
Public Sub testWebGIS()
Call initWebGIS
Call openWebGIS(428300001)
End Sub
' this SUB will be called from an external DLL
' e.g. clicked on a button in firefox w/ webgis
Public Sub WebGISConn_CallBack(ByVal interf As Long, ByVal feats As Long)

Dim idList As String
Dim layerInterface As String

On Error Resume Next

Debug.Print "dll is calling ... " & LPSTRtoBSTR(interf) & LPSTRtoBSTR(feats)
' TODO: open form w/ data
End Sub
' open object in browser w/ webgis
Public Sub openWebGIS(ByRef Id As Variant)
Dim idList As String
Dim layerInterface As String

idList = CStr(Id)
layerInterface = "LDA_obertaegigeDenkmale"

Call WebGISConn_showFeaturesInIMS(idList, layerInterface)
End Sub
' init DLL
' register access-callbackfunction
Public Sub initWebGIS()
Call WebGISConn_init(AddressOf WebGISConn_CallBack)
End Sub

' convert C-null-terminated string from DLL to vba BSTR string
Function LPSTRtoBSTR(ByVal lpsz As Long) As String

' Input: a valid LPSTR pointer lpsz
' Output: a sBSTR with the same character array

Dim cChars As Long

' Get number of characters in lpsz
cChars = lstrlenA(lpsz)

' Initialize string
LPSTRtoBSTR = String$(cChars, 0)

' Copy string
CopyMemory ByVal StrPtr(LPSTRtoBSTR), ByVal lpsz, cChars

' Convert to Unicode
LPSTRtoBSTR = Trim0(StrConv(LPSTRtoBSTR, vbUnicode))

End Function

Public Function Trim0(sName As String) As String
' Right trim string at first null.
Dim x As Integer
x = InStr(sName, vbNullChar)
If x > 0 Then Trim0 = Left$(sName, x - 1) Else Trim0 = sName
End Function


Symfony2 on XAMPP (Windows) minor tweaks

w/ XAMPP 1.7.4, Symfony 2.0.1

http://localhost/Symfony/web/config.php gives us:

1 .Install and enable a PHP accelerator like APC (highly recommended).
2. Install and enable the intl extension.
3. Set short_open_tag to off in php.ini*.

(1) install corresponding php_apc.dll, add extension=php_apc.dll to php.ini
(2) mod_intl.dll exist, enable it in php.ini, but you need to have to copy all icu*36.dll files from your-xampp-path\php to your-xampp-path\apache\bin
(3) bad default-xampp-php.ini, "short_open_tag" is set twice - once "off" and once "on" two lines later, comment the latter out

http://localhost/Symfony/web/config.php is still not satisfied:

1. Upgrade your intl extension with a newer ICU version (4+).

damn ... I'm just one minute away from deinstalling xampp and take full control

Bugzilla 4.0.2 on XAMPP (Windows)

after switching to ActivePerl on XAMPP (Windows) I thought the server was ready for a simple Bugzilla:Win32Install

but after updating all perl-modules and installing the required and optional modules (if available for win32) checksetup.pl failed
#perl checksetup.pl
Invalid version format (negative version number) at Bugzilla/Install/Requirements.pm line ...

it's a known bug and it's already fixed and committed and should be included in future version (> 4.0.2).
until then you have to patch it yourself with: patch, v1 (925 bytes, patch)


use ActivePerl with XAMPP (Windows)

- tested with xampp 1.7.4
- install activeperl (e.g. to c:\usr
- open a shell c:\usr\bin
- add corresponding repo and install corresponding mod_perl.so (only needed to run as module)

#ppm repo add UWinnipeg http://cpan.uwinnipeg.ca/PPMPackages/12xx/
#ppm install mod_perl

- if running as module copy new mod_perl.so to your-xampp-apache-path\modules
- edit apache.conf add "ScriptInterpreterSource Registry-Strict"

# Possible values for the Options directive are "None", "All",
# or any combination of:
# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
# Note that "MultiViews" must be named *explicitly* --- "Options All"
# doesn't give it to you.
# The Options directive is both complicated and important. Please see
# http://httpd.apache.org/docs/2.2/mod/core.html#options
# for more information.
Options Indexes FollowSymLinks Includes ExecCGI

# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
AllowOverride All

# Controls who can get stuff from this server.
Order allow,deny
Allow from all

ScriptInterpreterSource Registry-Strict

- edit your-xammp-apache-path\extra\httpd_perl.conf
- comment out "PerlPostConfigRequire"-line
- if running as non-module comment out LoadFile ... n' LoadModule ... lines
- if running as module correct path/filename

LoadFile "C:/usr/bin/perl512.dll"
LoadModule perl_module modules/mod_perl.so
#PerlPostConfigRequire "C:/dev/xampp/apache/conf/extra/startup.pl"

- add following registry entry (you may use apache_cgi.reg):

Windows Registry Editor Version 5.00

@="C:\\usr\\bin\\perl.exe -T"

- restart apache
- test perl via your fav. www-browser and a file w/ following content

print "Content-type:text/html\n\n";
print "hello world";

- optional install HTML::Perlinfo

#ppm install HTML-Perlinfo

- test with your fav. www-browser and a file w/ following content


use HTML::Perlinfo;
use CGI qw(header);

$q = new CGI;
print $q->header;

$p = new HTML::Perlinfo;

wow ... 2 years, 3 months, x days no post


Cypress EZ-USB FX2 - se7en RC 7100

  • tested w/ windows 7 RC 7100 x64

  • longer "readme.txt" w/ advice for v64, se7en64 (see below)

  • see download section

and remember for all 64-versions of vista and se7en:

- turn off  "digital driver signature enforcement" in bootmenu, every time you boot, se7en still complains (first) time with a popup "unsigned driver could not be loaded ... blabla" but driver is loaded and running

- or use Driver Signature Enforcement Overrider (http://www.ngohq.com/home.php?page=dseo)