DMXzone Database Connector PHP Support Product Page

In progress

PHP7 support

Reported 25 Apr 2016 06:54:08
4
have this problem
25 Apr 2016 06:54:08 Greta Garberini posted:
Hi,
I'm having issues with Database Connector PHP since some servers got updated to PHP version 7 Ubuntu Xenial uses php7 as a standard now.
It is not possible to create a connection to mysql databases (at least thats what I've tried)
Can you please help?

Replies

Replied 25 Apr 2016 07:17:06
25 Apr 2016 07:17:06 Teodor Kuduschiev replied:
Hello, the extensions are PHP7 compatible.
Could you please explain what exactly do you mean by: "It is not possible to create a connection to mysql databases"? Please provide a little more detailed information about the issues.
Replied 25 Apr 2016 07:32:00
25 Apr 2016 07:32:00 Greta Garberini replied:
Thank you Teodor for the quick reply.
The issue I'm having is - creating a database connection. I start with creating a connection file and a database connection. I can input the database dtails like localhost, database name etc. As soon as I click on "apply" or "OK" it is checking the connection and the I get a window, similar to this: www.dmxzone.com/support/22072/topic/60703/
(second screenshot from above)
"Error using this Database Connection"
Server response:

without a message. It is on our develop server which has been updated to Ubuntu xenial which uses php7 by default.
https://launchpad.net/ubuntu/+source/php7.0
Replied 25 Apr 2016 07:36:54
25 Apr 2016 07:36:54 Teodor Kuduschiev replied:
Can you please post a link to an empty PHP file, on your server containing:


<?php phpinfo(); ?> 


Replied 25 Apr 2016 07:40:21
25 Apr 2016 07:40:21 Greta Garberini replied:
I am afraid ist is on our local network with an 192.168..IP address . I could provide the phpinfo() if it helps.
Moving the thing back to php 5.6 makes it work again, if no other settings are changed
Replied 25 Apr 2016 07:41:28
25 Apr 2016 07:41:28 Teodor Kuduschiev replied:
Please provide your phpinfo then. There must be some server configuration issue, as if the extension works on PHP 5.6, it must be working on PHP 7.
Replied 25 Apr 2016 07:41:55
25 Apr 2016 07:41:55 Greta Garberini replied:
OK, thanks. Just a moment
Replied 25 Apr 2016 08:11:35
25 Apr 2016 08:11:35 Greta Garberini replied:
Replied 25 Apr 2016 08:28:45
25 Apr 2016 08:28:45 Teodor Kuduschiev replied:
Thanks, we are checking this now.
Replied 25 Apr 2016 08:40:49
25 Apr 2016 08:40:49 Teodor Kuduschiev replied:
Hello,
In order for the error to be displayed in the connection window, please make sure to turn the "display_errors" setting ON.
Then we will be able to tell what causes the error.
Replied 25 Apr 2016 08:50:37
25 Apr 2016 08:50:37 Greta Garberini replied:
I can't close the window by clicking OK, only by Abort. The file which is created shows this:

<?php
require('../../../dmxConnectLib/dmxConnect.php');


$app = new \lib\App();

$app->define(<<<'JSON'
{
"meta": {
"options": {}
},
"exec": {
"steps": "Connections/Intern"
}
}
JSON
);
?>
Replied 25 Apr 2016 08:51:26
25 Apr 2016 08:51:26 Teodor Kuduschiev replied:
Can you post a screenshot of the error window?
Replied 25 Apr 2016 08:56:19
25 Apr 2016 08:56:19 Greta Garberini replied:
Replied 25 Apr 2016 08:57:21
25 Apr 2016 08:57:21 Teodor Kuduschiev replied:
So after enabling the display_errors: on, you still don't see the exact error there? Please restart the server and try again.
Replied 25 Apr 2016 09:05:03
25 Apr 2016 09:05:03 Greta Garberini replied:
I restarted Apache service but the error stays. After checking the database connection the window pops up as shown. I can cancel the action but not save the action fiel because the connection credentials alre lost.
Replied 25 Apr 2016 09:21:52
25 Apr 2016 09:21:52 Teodor Kuduschiev replied:
The error is there as there is a problem obviously. My question is - do you see the server response after enabling the display_errors setting on your server or not?
Replied 25 Apr 2016 09:28:01
25 Apr 2016 09:28:01 Greta Garberini replied:
unfortunately not
Replied 25 Apr 2016 09:53:16
25 Apr 2016 09:53:16 Teodor Kuduschiev replied:
Can you tell me how is your mysql host (localhost ? Ip? - the value you are using) and what is your db name?
Replied 25 Apr 2016 10:27:55
25 Apr 2016 10:27:55 Teodor Kuduschiev replied:
Please check your email and try again.
Replied 04 May 2016 10:02:24
04 May 2016 10:02:24 Greta Garberini replied:
Glad we got this fixed. Will there be an updated version, soon? With one of the last updates I had the modified database file overwritten (the one with error class instead of myerror class)

BTW php 7 is worth it! It is so much faster than 5
Replied 04 May 2016 11:21:02
04 May 2016 11:21:02 Teodor Kuduschiev replied:
If the modified database file is in the configuration folder, as i explained in the mail, nothing will replace it, unless you reinstall the extension.
The fix will be included in the next update.

Reply to this topic