Show Posts

Profile Info

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Stéphane Devouard

Pages: 1 [2]

Language / MySQL on Linux

« on: December 01, 2020, 06:29:13 AM »

Hi all

On Windows, I have to put the libmysql.dll library file in the PxPlus folder to be able to use the [mysql] tag to access a MySQL database

On Linux, I did a copy of libmysqlclient.so in the pxplus directory, but I keep on getting an error 15 when opening a channel to MySQL
I did a chown, chgrp to my user & group and a chmod 777 on the file to make sure it wasn't a permissions issue, did not work either
Also tried adding the PxPlus directory to the PATH variable and exported it before starting pxplus, no more success

Code: [Select]

PxPlus-2020 Web (Ver:17.10/UNIX-Linux-Ubuntu) Serno:1710-664-2130620
(c) Copyright 2005-2020 PVX Plus Technologies Ltd. (All rights reserved)
  Website: http://www.pvxplus.com
->? env("PATH")
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/home/steph/heron/pxplus
->
->open(1)"[mysql]compass_demo;;server=localhost;user=admin;password=password"
Error #15: Operating system command failed
Unable to load libmysqlclient.so (err/ret=2/2)
->

total 43144 -rw------- 1 steph steph 223687 avril 24 2020 ca-bundle.crt drwxrwxr-x 36 steph steph 12288 nov. 30 10:25 lib -rw-r--r-- 1 steph steph 3167132 sept. 23 01:29 libhpls.a -rwxr-xr-x 1 steph steph 1914200 sept. 23 01:29 libhpls.so -rwxr-xr-x 1 steph steph 336072 déc. 1 11:59 libmysqlclient.so -rwxr-xr-x 1 steph steph 2908920 sept. 23 01:33 libpvx.so -rw-rw-rw- 1 steph steph 44 nov. 30 10:25 lic_approval.txt -rw-r--r-- 1 steph steph 12865 sept. 23 01:33 licenses_3rdparty.txt -rw-r--r-- 1 steph steph 10074 sept. 23 01:33 license.txt -rw-r--r-- 1 steph steph 1347 sept. 23 01:33 magic -rwxr-xr-x 1 steph steph 670184 sept. 23 01:31 PxIO.so -rw-rw-r-- 1 steph steph 31469184 nov. 30 10:18 pxp1710-0000-U20-64.taz -rw-r--r-- 1 steph steph 11 sept. 23 01:33 pxp_build -rwxr-xr-x 1 steph steph 2558632 sept. 23 01:32 pxplus -rwxr-xr-x 1 steph steph 36672 sept. 23 01:33 pxpreg -rwxr-xr-x 1 steph steph 804456 sept. 23 01:31 pxserver -rw------- 1 steph steph 1404 sept. 23 01:31 pxserver.conf -rwxr-xr-x 1 steph steph 461 sept. 23 01:33 runconfig -rwxr-xr-x 1 steph steph 584 sept. 23 01:33 runserver -rwxr-xr-x 1 steph steph 1154 sept. 23 01:33 stopserver

What else am I missing ?

TIA

Thin Client/WindX / WindX auto-download and Application Server

« on: November 25, 2020, 03:33:05 AM »

Hi all

Testing the thin-client systems for a client and it's been a while, so I'd like to be sure I'm not mistaken

The PxPlus WindX auto-download / synchronization of images, files and programs happens in the *start.up & *plus/start_up initialization procedure

When connecting to a Simple Client Server host, at the moment the start_up stuff executes, the line_switch has been done, TCB(88) is set and therefore the auto-sync happens
When connecting to an Application Server host, this is not the case, TCB(88) is not set when the start_up procedure executes, and no auto-sync happens at all

Am I missing something ?

This is on PxPlus 2020 (V17.10, 64 bits on W10) using a Software Development license

Thanks for any insight

Wish List / Short-hand syntax for anonymous arrays or objects initialization

« on: September 11, 2020, 05:16:39 AM »

In PHP you can create and initialize an array with :

Code: [Select]

$myArray = [ "item", "another item", "a third item"];
You can also pass either an indexed or associative anonymous array to a function using :

Code: [Select]

myFunction([
  "key1" => "value 1",
  "key2" => "value 2"
]);

Almost same in C# :

Code: [Select]

string[] myArray = { "value", "another value" }; // declaring and initializing an array
myFunction(new[] {10, 20, 30}); // passing an anonymous array to a function

In Javascript you can create a simple object (and manipulate it with a syntax which is basically that of an associative array)

Code: [Select]

let options = {
  url: "server:port/path/to/resource",
  timeout: 5000,
};
myFunction({
  mailFrom: "me@myisp.com",
  mailTo: "you@yourisp.com",
  message: "Hello there"
}); // passing an anonymous object

Almost the same in C#

Code: [Select]

myFunction(new { TextProperty = "Some Value", NumProperty = 100 });
In summary :

You do not always need to declare a variable -- you can already pass literal string or number values to a subroutine or method in PxPlus.

It would be great if it was possible to do it with other data structures such as arrays, associative arrays and objects -- the latter could be wiped out when not needed anymore using the "FOR OBJECT/PROGRAM/..." housekeeping clauses

Off Topic / Seasoned PxPlus and Web Application Designer and Developer

« on: July 15, 2020, 01:23:55 PM »

I have been programming in ProvideX for Windows since 1998 after 10 years with TBred on SCO and AIX
I was instrumental in migrating my first employer's apps from CHUI to GUI, then migrating Explorer Software's WindX-only based ERP to the web using iNomads

I have re-skilled myself in mainstream web development and am also proficient in PHP 7, Javascript/jQuery, Java, C#, VB.Net, Android mobile development, MySQL, Postgres, MS SQL Server and MongoDB databases, and various frameworks (PHP Symfony 4, Microsoft .Net ASP MVC5 & Winforms, IONIC 4 for hybrid mobile apps, Express for NodeJS)

You can read more about me and my work with ProvideX and PxPlus on my resume and professional websites

I am looking for any type of work related to the topics above :

PxPlus training and consulting
Legacy applications conversion to Nomads & iNomads GUI
Legacy applications migration to SQL back-end databases
Web applications and Web services
Desktop applications

If you know of anyone who would be interested or are interested yourself, please contact me by private message here, or via email, or via my LinkedIn account.

Regards,

Language / MySQL

« on: June 22, 2019, 05:37:20 AM »

Hello

It looks like the libmysql.dll that comes with the latest MySQL 8.0.xx version is 64-bits only and does not work with PxPlus 2019.

I kept on getting an "Unable to load libmySQL.dll" message when trying to open a [mysql] channel
It finally worked when I grabbed a 5.7.25-win32.zip from mysql website, extracted the .dll from and overwrote the 64-bits one I had put in the pxplus folder.

Is it the way this is supposed to work ?
Any plan to update PxPlus to be compatible with the latest MySQL version ?

Thanks

Off Topic / Seasoned ProvideX developer seeking remote position

« on: January 09, 2019, 03:43:07 AM »

Hi all

I have been recently let go by Explorer Software Inc. for whom I have been working for over 10 years remotely from my home office near Paris, France.
I have been programming in ProvideX for Windows since 1998 after 10 years with TBred on SCO and AIX
I was instrumental in migrating my first employer's apps from CHUI to GUI, then migrating Explorer's WindX-only based ERP to the web using iNomads
I also know some C# and VB.Net and I am currently self-learning PHP, Javascript and Python
You can read more about me and my work with ProvideX and PxPlus on my personal resume website (see my e-signature)

I am looking for a remote, full-time position. If you know of anything or are interested, please contact me here, or on my personal email, the contact form on my web resume or my LinkedIn account

TIA

Pages: 1 [2]