Nick Fenwick

Wonderful, thank you Gerd. I can stop having to paste the script into an editor and Replace All to get rid of the quotes :) Apologies for the noise.

Wonderful, thank you Gerd. I can stop having to paste the script into an editor and Replace All to get rid of the quotes :) Apologies for the noise. On 23/05/2023 01:54, Gerd Wagner wrote: Nick, quoting is configurable (though not to use backticks, yet) and does not depend on the database you are connected to. See menu File --> Global Preferences --> tab SQL Scripts --> First and second check box. [bugs:#1506] https://sourceforge.net/p/squirrel-sql/bugs/1506/ Copy as SQL INSERT-VALUES statement wont...

SquirrelSQL 4.5.1 (latest release): Was this Bug raised when working against Oracle database? I think it's what has been causing me grief for the last 8 months :) When working against MySQL, quoted column names causes syntax errors, e.g. selecting a single field of results and choosing 'Copy as SQL INSERT-VALUES' creates the SQL: INSERT INTO my_table ("style") VALUES ('whatever'); And running against MySQL (actually MariaDB 10.5.19): Error: (conn=291) You have an error in your SQL syntax; check the...

Was this Bug raised when working against Oracle database? I think it's what has been causing me grief for the last 8 months :) When working against MySQL, quoted column names causes syntax errors, e.g. selecting a single field of results and choosing 'Copy as SQL INSERT-VALUES' creates the SQL: INSERT INTO my_table ("style") VALUES ('whatever'); And running against MySQL (actually MariaDB 10.5.19): Error: (conn=291) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB...

I ran into a solution that I think does "the right thing" to solve this problem, which is to change the whole app's DPI scaling instead of trying to configure fonts to specific sizes. https://superuser.com/a/1194728/212637 java -Dsun.java2d.uiScale=2.5 -jar ~/jars/NearInfinity.jar I'm not familiar with modifying SquirrelSQL's params but I found in squirrel-sql.sh there is use of $SQUIRREL_SQL_OPTS just after the classpath on the Java command line, so I set: export SQUIRREL_SQL_OPTS=-Dsun.java2d.uiScale=2.5...

I ran into a solution that I think does "the right thing" to solve this problem, which is to change the whole app's DPI scaling instead of trying to configure fonts to specific sizes. https://superuser.com/a/1194728/212637 java -Dsun.java2d.uiScale=2.5 -jar ~/jars/NearInfinity.jar I'm not familiar with modifying SquirrelSQL's params but I found in squirrel-sql.sh there is use of $SQUIRREL_SQL_OPTS just after the classpath on the Java command line, so I set: export SQUIRREL_SQL_OPTS=-Dsun.java2d.uiScale=2.5...

I guessed at changing this line of config, swapping SHA256 for MD5: <attribute name="as2_mdn_options" value="signed-receipt-protocol=optional, pkcs7-signature; signed-receipt-micalg=optional, MD5"/> the new 'MD5' on that line results in this response: 2018-02-16 06:45:47.678 ERROR AS2Util: MIC not matched, original MIC: L2QPPqKrGkoAAu+nChygpA==, MD5 return MIC: t9mKn1FHYAa+jLIVHl2diA==, md5 [OPENAS2-16022018064546+0000-0f602d6a-bad3-41a7-bd3f-719c92dfb0d4@OURCOMPANY_SE328SM1HWT6FFO] Amazon do say...

Sorry for bumping an old thread, but this is on topc as it's the same error message and configuration question. I'm new to OpenAS2 .. where exactly do you configure the MIC algorithm, to set it to MD5? It doesn't seem to be specified in the OpenAS2HowTo.pdf. I don't actually think that's my problem, I seem to be using SHA256 everywhere as expected, but I'm getting something wrong and want to try changing my MIC algorithm to something else. When I drop a file into the outbox for my connection, the...