jeti

OK

besten Dank

LG

Hallo,

die Verbindung zur MySQL DB (Data Report) funktioniert.

Es funktionieren auch die bestehenden RDM Einträge zu dieser DB.

Problem tritt "nur" auf wenn ein neuer RDM Data Report Eintrag erstellt wird oder ein bestehender (funktionierender) ohne Änderung einfach nur gespeichert wird.

D.h. die aktuell verwendete, neuere Version dürfte im Hintergrund einen anderen Verbindungsaufbau zur MySQL aufbauen (Connection String Syntax).

Was ist mit funktionierender Sitzung gemeint? Es handelt sich leider zur Gänze um sensible Daten die ich auch nicht entfernen kann.

LG Klaus

Ich verwende das Data Report Objekt zur Abfrage auf eine externe MySQL Datenbank (Abfrage und Darstellung von Verträgen zu einem Kunden).

Dazu wurde ein Template mit einem MySQL Connection String und SQL Query angelegt.

Seit der aktuell verwendeten Version 2020.2.20.0 (ca. genau kann ich es nicht sagen, da der Fehler nur bei neu angelegten auftritt) kommt es zu einer Fehlermeldung -> "Unable to execute the query. Please verify the connection string and the query. Keyword not supportet: dsn"

Wenn ich einen bestehenden Data Report aufrufe funktioniert es.

Wenn ich einen neuen Data Report aus dem Template (oder neu) anlege oder einen bestehenden ohne Veränderung wieder speichere - kommt es zu diesem Fehler?

Hat sich seit einer bestimmten Version der Syntax für den Connection String zu MySQL DBs geändert?

zB Connection String: Dsn=dsnname;server=x.x.x.x;pwd={password};database=dbname;port=3306;multi_statements=1

Ich sehe in der GUI keinen Unterschied zu den "alten" funktionierenden und den "neuen" die nicht mehr funktionieren?

hi

yes, works fine

the only thing is: when i disable "open as hidden" it works fine now but the ipsec.exe comman start in a extra commandline window

it would be better when the commandline window is integrated (embedded) in rdm (it shows also logs and errors from the tunnel -> helpful)

i must use this option "deactivated 'Open as hidden'" because otherwise i can not close the tunnel with rdm "close session"

additionally it would be good when the vpn tunnel is shown as active (green) in rdm when it is open

klaus

Ok

Thank you

Klaus

Ok

Tanks for your help

Klaus

ok

thank you

and how ist the easyiest way to copy or move a sub-Connection to another entry?

klaus

hi

window reset layout does not help - see pic att

i found out that when i start as rdm Administrator then i see the menu

my user has all rights except Administrator is not checked

is this a user rights setting?

klaus

hi

im searching for the refactoring menue - see screenshot from help

i dont found this menue on my Version (rdm 12.0.8.0)?

i am looking for a solution to copy/duplicate/move subconnections!?

klaus

hi

thanks

looking Forward to a new release supporting this Feature

klaus

another question too

in the rdm help at data Report ther is the info:

This supports multiple queries in the statement and will display the results in different tab pages.

but i Can not do this with an ODBC mysql query

klaus

another question

can i use variables in data report Connection string?

klaus

hi

how can i use variables in a data report query

how can i set the default value from a data report parameter with a value from a variable

it works when i set a static default value in a Parameter and use this parameter in a query

but i need the value for the query from a parent custom field

klaus

%3Cp%3Ehi%3C/p%3E%3Cp%3Ehow%20can%20i%20use%20variables%20in%20a%20data%20report%20query%3F%3C/p%3E%3Cp%3Ehow%20can%20i%26nbsp%3Bset%20the%20default%20value%20from%20a%20data%20report%20parameter%20with%20a%20value%20from%20a%20variable%3F%3C/p%3E%3Cp%3Eit%20works%20when%20i%20set%20a%20static%20default%20value%20in%20a%20Parameter%20and%20use%20this%20parameter%20in%20a%20query%2C%20but%20i%20need%20the%20value%20for%20the%20query%20from%20a%20parent%20custom%20field%21%3C/p%3E%3Cp%3Eklaus%3C/p%3E

Ok thanks

Would be great if the embedding works too

Klaus

hi

tested from outside

works now fine

the command execute in a new window

is it possible to embed the ipsec.exe command box in rdm and shown as actice/closed session (green) ?

klaus

Ok thank you

Im out off office now and try it tommorow

The plugin error is fixed, it was the original dll with different suffix in the same folder

Br klaus

hi

another Problem now

when i start rdm i became many add in erros (already replaced the dll with the origimal)

?

hi, thank you

does not work at the Moment because when deactivate "open as hidden" then rdm start only ..\ipsec.exe (without any Parameter)

-> new dos box -> start empty ipsec session

we need Minium one parameter -> the Tunnel-Name -> ..\ipsec.exe TunnelName

another Thing ist that the dos box is external and the session is not shown as active

ist it possible to "embed" the "dos-box" and set the session active (green - open session until it is closed)?

klaus

hi

is this function (recuring tasks) working ?

seems to be okay

hi

when i activate "Show Command" i see that rdm send "[path-to-exe]\ipsec.exe -k -b VPNTunelName"

this open the tunnel in silent mode and it works, but in this case the command "[path-to-exe]\ipsec.exe quit" does not work anyway

when i start manually the tunnel with "[path-to-exe]\ipsec.exe VPNTunelName" (withou -k -b), then i can Close the tunnel with "[path-to-exe]\ipsec.exe quit"

the different between starting with or without the Parameter is:

with -k -b -> silent

without Parameters -> see the ipsec Connection in the dos box

so, when i create a new entry "command line" with run:

for example:

"C:\Program Files (x86)\Fortinet\FortiClient\ipsec.exe" "1536_Wechselberger"

and set the "Event" "after disconnect" to

"C:\Program Files (x86)\Fortinet\FortiClient\ipsec.exe" quit

it works

so what means the -k -b exactly (Can not find anything about it at fortinet)

http://kb.fortinet.com/kb/documentLink.do?externalID=FD30811

klaus

hi

both (quit and disconnect) does not work anymore (since Version 4 forticlient)

legacy disconnect on rdm not working

what means legacy disconnect outside rdm?

klaus

hi

have still the same Problem

can not close forticlient session (ipsex.exe)

legay disconnect does not solve the Problem

also tried to Change the vpnaddon.dll from above - same Problem

rdm 12.0.8.0

forticlient 4.2.7 (also not works with newer or older Versions)

br klaus