Any Log Infos about "External Database Connection"?

Connect to an external database in ChronoForms.

Overview

The connection failed due to missing IP whitelisting and a model not refreshing after creation.
Whitelist the connecting server's IP address on the external database server. After creating a new model, save the function again to refresh the available table list.

Answered
Connectivity v6
Pr Proximate 17 Oct, 2018
Hi Community
​
I am trying to connect to an external database in chrono connectivity
​
Page / Server A:
- DB with Data
​
Page / Server B:
- ChronoConnectivity where i want to use the data
​
First Question:
Are all Fields required? (db type / prefix)
the prefix is well known but the db type (its a MysQL - MariaDB) - is it mysqli?
​
Second:
i am not able to connect - in the table selection i have the message "Database connection failed."
--> I have a user with external access and i am able to connect to this DB with Sequel pro.
I think the Issue is that i have to specify the access sources (whitelisting) and i cannot see whats my actual source (from Page B) is.
i have already tried to put the Domain, Subdomain, Servername (loginxy.hoster.ch) but it was all unsuccessfull.
​
So is there any LOG or any option to get MORE informations about the Connection failed?
The PHP Server Log & ErrorLog File has no infos...
​
thanks for your input
​
kind regards
Gr GreyHead 17 Oct, 2018
Hi Proximate,
​
You can try adding turning the Debugger on for the listing. That might show you the info you need.
​
Bob
Pr Proximate 18 Oct, 2018
Hi Bob
​
Thanks for your answer, i had to whitelist the B server's IP Adress (on A Side) to grant access.
is it correct that just the main model can access an external db? - when i create a second model in the same function it just let me choose from the local db.
​
Is this a bug?
Gr GreyHead 19 Oct, 2018
Answer
Hi Proximate,
​
I don't know - I would expect that both models can access an external server. Please try asking Max - the developer - using the Contact menu above and linking to this thread.
​
Bob
Pr Proximate 23 Oct, 2018
i've tried again now and it works - you have really to SAVE the function again (after creating the new model again!) to see the external tables in the list.
​
thanks Bob ;-)
This topic is locked and no more replies can be posted.