събота, 1 август 2020 г.

Disconnected: No Supported Authentication methods available(Server sent: publickey,gssapi-keyex,gssapi-with-mic). when connecting to ORACLE Cloud Instance with PuTTY or MobaXterm.

The problem.

The downloaded private key is not in RSA format. Open the file in notepad.You should see something like

-----BEGIN PRIVATE KEY-----
MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgw
.....
cC8HzXh8lbx9iPgYP4i3dsGH
-----END PRIVATE KEY-----


The solution.

Convert the key.

openssl rsa -in ora_cloud.key -out ora_cloud_rsa.key

Result.

-----BEGIN RSA PRIVATE KEY-----
MIIEpAIBAAKCAQEAsCELMYDk8VCo0tAs4dG9vr5w
.....
cVdJXikv+d6JpSQAB3g4o/hyERO/v3AvB814fJW8
-----END RSA PRIVATE KEY-----


Use the new rsa key file.

сряда, 9 юли 2008 г.

Excel export from APEX + Cocoon

Carl Backstrom has posted nice howto Print in PDF and RTF from APEX without the BI Publisher.

However from time to time you (just like me) need to export to Excel. First you try the easy way - google for "fo2xls" and other to_xls converter. Then you ask or you read other asking in one or two forums.
The things are even worst if you are not so familiar whit fo and xsl.

As I didn't found a solution for generating Excel files I had to spend some time to do it. Now the export to Excel is working, alltgough very basic functionality, and I want to help other APEX developer with little to no knowledge of XSL Transformers get it done.

So follow Carl Backstrom's howto and then replace the content of fop_post directory whit this one.
In addition to Excel you get export to XML and HTML, too.

Hope this helps.