(How to) Install URL Logger on mySQL

prashant
Topic Author
Offline
Platinum Member

More

2 years 6 months ago #23204 by prashant

Replied by prashant on topic (How to) Install URL Logger on mySQL

Peter.Jonson wrote:
Please try version 1.0.5 and let us know if it works

Hi Peter,
I am able to install and login to URL Logger

BUT
clicking on URL/EVENT Log/Users , gives me the spinning window

In Background URL Logger throws the error
Error: Invalid usage of the option NEXT in the FETCH statement.

File Attachment:

File Name: untitledtext37.txt
File Size:21 KB

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

2 years 6 months ago #23207 by admin

Replied by admin on topic (How to) Install URL Logger on mySQL

Can you tell us which version of SQL Server have you got?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

2 years 6 months ago #23208 by prashant

Replied by prashant on topic (How to) Install URL Logger on mySQL

Sadly we are stuck on SQL 2005 due to our ERP

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

2 years 6 months ago #23210 by admin

Replied by admin on topic (How to) Install URL Logger on mySQL

We use third party library here and it does not support such an old version of SQL server.

As alternative you can try using MS SQL Server Express 2019 or MySQL as you originally wanted.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

2 years 6 months ago #23211 by prashant

Replied by prashant on topic (How to) Install URL Logger on mySQL

I installed mySQL 8.3

Now URL logger gives me

Code:

2024-02-20 19:40:12.837 error:  uncaughtException: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have tried logging with the root user too but same result.

I am attaching the logs

File Attachment:

File Name: abc.txt
File Size:2 KB

Please Log in or Create an account to join the conversation.

Peter.Jonson
Offline
Administrator

More

2 years 6 months ago #23212 by Peter.Jonson

Replied by Peter.Jonson on topic (How to) Install URL Logger on mySQL

Can you try latest version please.

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

ETL Forum