[anuragkumar]

6 years, 1 month ago #14842

I have created a mysql connector but I am getting below error:-

{
“message”: “Connector Call AnuragSQLConnector / getAlInventories produced an unexpected error during execution: Error executing connector ‘AnuragSQLConnector’ of type ‘SQL’: Couldn’t connect to the Database.”,
“success”: false
}

Please find the details of my SQL Connector configs in the attachments below.

I have a database named “shopping_mall” with a table “inventory” on my local mysql.

Please let me know what can be going wrong.

Thanks in advance.

Attachments:

You must be logged in to view attached files.

[Chris Bouveret]

6 years, 1 month ago #14853

Up

1

Down

::

Hi,

you are trying to connect to a Database on your localhost. This ist not possible because the Simplifier Freemium Instance cannot access your localhost. The easiest way is to move your Database to the Web so that is reachable via IP adress or hostname.

Hope that helps

Best
Chris

[anuragkumar]

6 years, 1 month ago #14867

Up

0

Down

::

@Chris, Thanks..

Can you please provide some example of websites where I can move my database to and which can be accessed from freemium simplifier instance.

Regards

[Chris Bouveret]

6 years, 1 month ago #14868

Up

0

Down

::

Hi,

well there is no limits. You could use AWS Database Services or any other Webserver that has e.g. MySQL or other Database Services running. You could also use SQLite which would be stored on your Freemium Simplifier Instance. In this case you would just have to migrate your data to SQLite. In general, the SQL Connector of Simplifier can access any Endpoint that is reachable in the Internet.

Best
Chris

[anuragkumar]

6 years, 1 month ago #14870

Up

0

Down

::

Hi @Chris

Thanks again,

As I am a complete newbie to simplifier, please guide me how I can use SQLite that as per you would be stored on my Freemium Simplifier Instance.
Will I need to install SQLite on my system for this? I am clueless on this.

If possible share some link which I can refer for detailed info.

Thanks in advance.

Regards
Anurag

[Chris Bouveret]

6 years, 1 month ago #15225

Up

0

Down

::

Hi,

please see the “ITIZ_Template_SQL_ShoppingList” Example App, it uses SQLite and you can see how data is stored and SQLite is managed

Hope that helps
Chris

[anuragkumar]

6 years, 1 month ago #15236

Up

0

Down

::

Thanks Chris. It worked.