MvonSharp Gateway for MVON#,jBASE,D3,QM,Universe,Unidata and mvBase

[Grant H]

As I mentioned yesterday, I have started a new thread where we can track issues, successes and enhancements specifically for members using the MV# Extensions.

Dick Thiot from Maverick Systems has been testing and improving the Gateway and has successfully connected to the above MV Platforms 

Installation:

The install can be found in the path C:\Users\{your user}\.vscode\extensions\ongroup.mvon-1.47.0\gateway.

It is a standard windows service.

Configuring the extensions:

You need to create a workspace with the following settings:

{

    "folders": [

        {

            "uri": "GatewayFS:/",

            "name": "QM Account - PRC",

        }

        

    ],

    "settings": {

        "mvon.Account": "PRC",

        "mvon.AccountPassword": "xxxxxxx",

        "mvon.remoteHost": "127.0.0.1",

        "mvon.UserName": "xxxxxxxx",

        "mvon.Password": "xxxxx",

        "mvon.remoteCompiling": true,

        "files.associations": {

            "*": "mvon"

        },

        "mvon.gatewayType": "qm",

        "mvon.gatewayHost": "localhost",

        "mvon.gatewayPort": "9004",

        "mvon.useGateway": true,

        "mvon.ignoreGotoScope": false,

        "mvon.homePath": "c:\\u2\\ud81",    

    },

}

Each MV platform may need different settings

D3/mvBase

Needs "mvon.AccountPassword": "xxxxxxx", this is the account password as apposed to your windows/Linux credentials


Unidata

Needs "mvon.homePath": "c:\\u2\\ud81", this is the path to where unidata install resides


"mvon.gatewayType": "qm", this can be one of the following

qm - standard tcp port is 4243
d3 and mvBase - standard tcp port is 9003
Universe and Unidata - standard tcp port is 31438
jBase - standard tcp port is 8236

"mvon.UserName": "xxxxxxxx",

 "mvon.Password": "xxxxx", 31438 The above settings are OS credentials

Trobleshooting

I have not added logging on te Gateway YET. (On my todo list) but here are some tips

1. The gateway listens on port 9004. Make sure you can telnet to the Gateway host on port 9004.
2. Using the ports listed above, make sure you can telnet from the machine running the Gateway to the machine running your MV platform on that port
3. Make sure the OS credentials are correct

Or drop a message on this thread.

If anyone is successfully using the Gateway, please let me know

Cheers

[Dave Graham]

Now that things have calmed down a bit on the editing side I thought I'd get back into the gateway side.

I'm still unable to connect to our host server which is odd because I can connect using a variety of other tools (telnet, ftp, UniObjects, etc). I can also telnet to localhost on port 9004. So if anyone else has been able to use the gateway to connect to a Unidata host via UniObjects, I'd certainly like to hear from them,

Here are my user settings:

{

"git.ignoreMissingGitWarning": true,

"mvon.Account": "/devel/ud/FLA9.10",

"mvon.gatewayType": "Unidata",

"mvon.homePath": "/storis/ud/",

"mvon.Password": "xxxxxxxxxx", <--- Masked for security but it really is correct

"mvon.remoteHost": "vette", <--- the system absolutely can resolve this host (tried it by IP too with no joy)

"mvon.gatewayHost": "localhost",

"mvon.gatewayPort": 9004,

"mvon.UserName": "dlg",

"workbench.startupEditor": "newUntitledFile"

}

[Grant H]

Hi David,

I have just published a new version of the extensions and the gateway. I did pick up a bug with connecting on Unidata and I have corrected it.

I also added a new setting "mvon.gatewayDebug", setting this to true will write a log file into c:\Temp call mvonGateway.log

Let me know if I can assist with anything and if you get it to work please let me know

Cheers

[Dave Graham]

Hi Grant,

Excellent news!

I will download and try as soon as possible. 

If it works I promise to raise a glass for you this weekend.

DaveG

[Grant H]

Hi Dave,

Did some more work on the Gateway for Unidata and mvBase. Got tripped up with the Unix vs Windows / and \. Hopefully the new Gateway will enable connectivity.

Let me know if it works

Cheers

[Dave Graham]

Hi Grant,

Looks like I might owe you a beer mate. Here's the string from the log file:

7/31/2018 3:52 PM Logging in connect Unidata vette dlg &^&^&^&^&^& /devel/ud/FLA9.10 /storis/ud/ true

The next step of course is how do I tell the editor what file/item combo I want to edit?

DaveG

[Grant H]

Hi Graham,

After connecting to the Gateway you get 3 message boxes on the bottom right, the final one saying connected.

If you then move you mouse into the Workspace on the left, a refresh button is available. Press this and all your files are displayed. You can select an item by expanding the files and selecting an item.

Send me a screenshot if you are still battling

[Dave Graham]

Hiya Grant,

Yep - I'm getting the 3 messages. Including the last one saying that the Gateway is connected. But no joy on the refresh button that I can see (unless I'm missing the blatantly obvious that is). Here's a screennshot:

[Grant H]

Hi Graham

Can you show me the Workspace settings, I think the GatewayFS file system is not being initialized

Cheers

[Dave Graham]

Here you go!

{

"folders":[

{"uri":"GatewayFS:/",

"name":"Local D3"

}

],

"settings":{

"mvon.Account": "/devel/ud/FLA9.10",

"mvon.gatewayType": "Unidata",

"mvon.homePath": "/storis/ud/",

"mvon.Password": "&&&&&&&&&&&",

"mvon.remoteHost": "vette",

"mvon.gatewayHost": "localhost",

"mvon.gatewayPort": 9004,

"mvon.UserName": "dlg",

"files.associations": {

"*": "mvon"

},

"mvon.gatewayDebug": true,

"mvon.remoteCompiling": false

},

"git.ignoreMissingGitWarning": true

}

[Grant H]

Hi Graham,

What version of VSCODE are you running, the File System API was only introduced in 1.25.1

Cheers

[Dave Graham]

Hi Grant,

Looks like 1.25.1 according to Help --> About

[Dave Graham]

Just curious if anything has been uncovered on this. We'd love to give it a try but without the database connectivity, its pretty much a non-starter for us.

DaveG

[Ian McGowan]

Dave, are you using vscode anyway?  There's a couple of plugins that will give you some of the functionality of the MVON gateway.

https://marketplace.visualstudio.com/items?itemName=TravisHaley.pick gives basic syntax highlighting (without the excellent MVON tool-tips and jump to definition)

https://marketplace.visualstudio.com/items?itemName=liximomo.sftp has a remote explorer over sftp to allow somewhat seamless editing (especially with download-on-open and upload-on-save).

I need a local copy of programs anyway (can't install git on customer servers), so having a local edit option that's somewhat transparent actually works better for my use case than 100% remote editing.

[Grant H]

Hi Graham

I just published a new version of the extension with a new Gateway. Please uninstall the current one and install the new one.

Basically my tests with Unidata on Windows worked because C# manages paths with both \ and / as the same. Unix however not so.

Make sure you have a c:\Temp directory created on the windows machine where the Gateway is running.

If you cant connect, there will be a log file created in C:\Temp\mvonGateway.log. Please send that to me.

Cheers

[Gysie de Bruyn]

Hi Grant,

You have done an awesome job on this!! Some niggles I have encountered:

• If a line starts with REM it always treats it as a comment eg.:
• REMOVE THE.ID FROM THE.LIST SETTING A.MARK
• VS Code displays this line as a comment, same goes for using REM as the first 3 letters of variable, when assigning it the same happens eg.:
• REM.ID = THE.ID
• It seems to ignore the camel case setting when not selected, our code base is a uppercase
• The formatting does not play well when you used a WRITE with just an ELSE statement:

When formatted this:

  IF A = 2 THEN
    CRT "SOME TEXT"
  END
  WRITE THE.RECORD ON THE.FILE,THE.KEY ELSE
    ERR.MESS = "Could not write"
    GOSUB EXITERR
    RETURN
  END
 
  WRITE THE.RECORD ON THE.FILE,THE.KEY ELSE
    ERR.MESS = "Could not write"
    GOSUB EXITERR
    RETURN
  END

Ends up as:

  IF A = 2 THEN
    CRT "SOME TEXT"
  END
  WRITE THE.RECORD ON THE.FILE,THE.KEY ELSE
  ERR.MESS = "Could not write"
  GOSUB EXITERR
  RETURN
END
 
WRITE THE.RECORD ON THE.FILE,THE.KEY ELSE
ERR.MESS = "Could not write"
GOSUB EXITERR
RETURN
END

[Gysie de Bruyn]

Forgot to add I am using VS Code version 1.27.1 and MVON version 1.67.0

[Grant H]

Hi Gysie

Many thanks for the feedback. I have fixed both issues and published a new version.

Cheers