Skip to main content
E
elvis is dead
Inspiring
September 9, 2021
Question

cannot make a database connection

  • September 9, 2021
  • 2 replies
  • 307 views

Due to the upgrade to PHP 7, I need to rebuild a custom application but am unable to successfully connect to the database.

 

The following error message is generated when using DMXZone Server Connect:

"Invalid target configuration! Check your Web Server URL and the connectivity to it."

 

Been chatting with DMXZone tech support but they're unable to determine what the issue is. They were able to run internal tests using my config and had no issues.

 

Repeatedly gone through System Preferences and unable to find anything that might be blocking the connection.

 

Has anyone had a similar issue and found a solution? Are there options beyond DMXZone?

 

Here is the enviornment:

MacOS 11.5.2
DW 21.1
Server Type MySQL 5.7.26
PHP 7.3.9
PHP extension mysqli
MAMP 5.7

DMXzone Server Connect 2, version 2.3.1
DMXzone App Connect, version 1.9.21
Database Connector 2, version 2.3.1

 

This topic has been closed for replies.

2 replies

Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
Community Expert
September 9, 2021

Have you looked at Wappler?  Also made by DMX Zone.

 

 

Nancy O'Shea— Product User & Community Expert
O
osgood_
Legend
September 9, 2021

Do you get a connection to your database if you use the code below? Insert code in blank document, save and run it in the browser. Change the connection details obviously ie 'my_user', 'my_password' and 'my_db'

 

That should at least rule out an internal mis-configuration.

 

<?php

$mysqli = new mysqli('localhost' , 'my_user' , 'my_password' , 'my_db');

if($mysqli -> connect_errno) {

echo "Failed to connect to MySQL: ".$mysqli -> connect_error;

}

else {

echo "Connected Successfully";

}

?>

    E
    elvis is deadAuthor
    Inspiring
    September 9, 2021

    Thanks. Connected Successfully was displayed.

     

    Next task is to re-write the code to display the pages ...

    O
    osgood_
    Legend
    September 9, 2021
    quote

    Thanks. Connected Successfully was displayed.

     

    Next task is to re-write the code to display the pages ...


    By @elvis is dead

     

     

    Must be something to do with the DMXZone extension then and incompatiblity with your upgrade, assunming it was working ok previously to your upgrade.

     

    Well re-writing the code probably won't be simple unless you have some experience in querying databases and getting that information back. There's plenty of mysqli/php tutorials on Youtube which will provide the code, but try to find ones no more than about 3 years old.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices