Any Log Infos about "External Database Connection"?

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
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
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?
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
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.