cannot make a database connection

Participant ,
Sep 09, 2021 Sep 09, 2021

Copy link to clipboard

Copied

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

 

TOPICS
Error , Server side applications

Views

73

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 09, 2021 Sep 09, 2021

Copy link to clipboard

Copied

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

}

?>

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Sep 09, 2021 Sep 09, 2021

Copy link to clipboard

Copied

Thanks. Connected Successfully was displayed.

 

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 09, 2021 Sep 09, 2021

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Sep 09, 2021 Sep 09, 2021

Copy link to clipboard

Copied

LATEST

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

 

 

Nancy O'Shea, Adobe Product User & Community Professional
Alt-Web Design & Publishing ~ Web : Print : Graphics : Media

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines