Forums

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

Hi Proximate,
​
You can try adding turning the Debugger on for the listing. That might show you the info you need.
​
Bob

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?

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 ;-)