(How to) Install URL Logger on mySQL

prashant
Topic Author
Offline
Platinum Member

More

2 years 6 months ago #23183 by prashant

(How to) Install URL Logger on mySQL was created by prashant

I tried changing my URL Logger instance from using sqlite to mySQL but whenever I do so , URL logger page refused to open

I can confirm mysql is working , username / password/port are right ,

I can also confirm mySQL is not being initialised as the database is empty with no tables inside

Code:

    "RUN_SQL_SCRIPTS": 0,
    "WEB_SERVER_PORT": 3333,
    "ENVIRONMENT_NAME": "DEV",
    "ENABLE_SECURITY": 1,
    "ENABLE_PREFERENCES_SCREEN": 1,
    "JWT_KEY": "01cc2a94-ee70-4707-bf61-xxxxxxxxxx",
    "JWT_EXPIRES_IN": "30d",
    "DEFAULT_USER_PAGE": "frontpage",
    "NODE_ENV": "production",
    "CONNECTION_TYPE": "mysql",
    "DB_USER": "myawesomeuser",
    "DB_PASS": "myawesomepassword",
    "DB_NAME": "logger",
    "DB_HOST": "localhost",
    "DB_PORT": "3306",
    "DB_INSTANCE": "",
    "ENABLE_LOGGING": 1,
    "SQL_LOGGING": 0,
    "USE_CLUSTER": 0,
    "USE_SSL": 0,
    "TOOLBAR_CLASS": "navbar border card-header rounded bg-light",
    "SMTP_USE_TLS": 0,
    "SMTP_HOST": "",
    "SMTP_PORT": "",
    "SMTP_USER": "",
    "SMTP_PASS": "",
    "ADMIN_EMAIL": "",
    "SMTP_FROM": ""
}

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

admin
Offline
Administrator
Deeds not Words

More

2 years 6 months ago #23188 by admin

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

Good morning

The process is described here:

www.etl-tools.com/wiki/url-logger/repository/

Set RUN_SQL_SCRIPTS=1
Set Set CONNECTION_TYPE, DB_USER, DB_PASS, DB_NAME, DB_HOST, DB_PORT, DB_INSTANCE to appropriate values
Restart URL Logger
Follow setup procedure and create ADMIN user
Restart URL Logger

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 - 2 years 6 months ago #23189 by prashant

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

HI Mike,

I am unfortunately stuck, I cannot access the setup/login page. Similarly to my earlier post

Here the problem is
1. I fresh install URL Logger, it defaults to sqlite in 1st run
2. I edit the settings , provide it sql settings
3. I change config to Run SQL scripts = 1
4. I am now not able to login or access URL logger unless I re-install , If I re-install I m back to #1

Cheers,
PM

Last edit: 2 years 6 months ago by prashant.

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

admin
Offline
Administrator
Deeds not Words

More

2 years 6 months ago - 2 years 6 months ago #23190 by admin

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

All data is stored in the repository database.
Setting Run SQL scripts = 1 tells the software to create the repository tables or upgrade them
This is done when you start the software (restart the service)
Once it is completed the software sets Run SQL scripts back to 0

The script might fail for various reasons
EG: incorrect password not enough user rights etc

To see the actual error message run it from the command line

Stop ETL-Tools.com URL Logger (64bit) windows service
execute C:\Program Files\DB Software Laboratory\URL Logger\url_logger.exe

www.etl-tools.com/wiki/url-logger/troubleshooting/

setting SQL_LOGGING to 1 will provide more information

There is no need to reinstall the software all the time

Mike
ETL Architect

Last edit: 2 years 6 months ago by admin.

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

prashant
Topic Author
Offline
Platinum Member

More

2 years 6 months ago - 2 years 6 months ago #23191 by prashant

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

HI Mike,

There is some progress, I managed to MS-SQL running. , it doesn't like mysql for some reason. The schema is created inside MS-SQL but I am stuck at error below

"Error: Invalid usage of the option NEXT in the FETCH statement."

All the tables created in MS-SQL are empty

Last edit: 2 years 6 months ago by prashant.

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

admin
Offline
Administrator
Deeds not Words

More

2 years 6 months ago #23192 by admin

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

>>> it doesn't like mysql for some reason.

This link has a picture
www.etl-tools.com/wiki/url-logger/troubleshooting/

It will show you the reason.

Did you see any errors?

Mike
ETL Architect

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

ETL Forum