Good morning
UPDATE: 25 August 2021 - The MySQL Connect utility is now part of the New Awesome Kitchen Sink.
Download
I kindly request your help. I am not a PHP expert and without having to resolute to "well, it works on my pc". Houston we have a problem!
I have done a couple of deployments of my BANano + PHP WebApp which are working fine for now.
With due respect, this is a PHP challenge and not a jetty challenge, please bear that in mind.
The purpose of the attached app is to check of you are able to
1. Connect to your backend database via PHP, whether you are working on a local development server or remote.
2. Whether you are able to access your BANano WebApp from your local development or remote webserver. The app on this download.
3. The steps are easy I hope.
4. We kindly request that you please run the tests and then come back here and reflect about your experiment.
What you need to do to make this work.
1. Download and install the BVAD3 library to your external libraries. Use the one from the provided download link above.
2. If you dont have banano installed, please set it up from here.
3. If you dont have a development webserver, please set up one
4, If you are using xampp, on the Main module, change your publish variable to use Xampp and change the \ to //
5. Open the mysqlconfig.php file and update it to reflect your MySQL connection settings.
6. On the Main module, change the ServerIP variable to be where your app is running from.
7. On pgIndex, change the dbname to be the actual name of your database
8. Ensure that your inbound & outbound tcp/ip connections to port 336 are set to be allowed on your firewall.
9. Grant Access for your MySQL user should be set to % for all IP addresses.
If you are running localhost with SSL, your ServerIP should be https otherwise it should be http.
For your remote host, you can also use localhost as the php file will be called from that machine. Also your DB_HOST can be localhost if the database is on the same machine, otherwise use the IP address of your web server.
If you dont have a successful connection, please indicate. Did you use an ip address / domain name / localhost for your connection, what is the error? What are the apache error logs saying etc.
What will this do and help with?
We have received indications that BVAD3 with PHP does not work and would like to get the details about cases why it does not work and possible solutions. In one of the cases, even a pure breed BANano PHP app could not connect whilst the php script run perfectly on the browser.
We are still investigating whether this is the source code we are writing or something else out of the ordinary and want to find out what we are missing and possibly doing wrong, and why in one instance, deployments work without issues and then for others nothing works.
As an example, if we use an ip address in BANAno.PHPHost, we get server errors, whilst using a domain name for the same everything works without hurdles.
I thank you.
UPDATE: 25 August 2021 - The MySQL Connect utility is now part of the New Awesome Kitchen Sink.
Download
I kindly request your help. I am not a PHP expert and without having to resolute to "well, it works on my pc". Houston we have a problem!
I have done a couple of deployments of my BANano + PHP WebApp which are working fine for now.
With due respect, this is a PHP challenge and not a jetty challenge, please bear that in mind.
The purpose of the attached app is to check of you are able to
1. Connect to your backend database via PHP, whether you are working on a local development server or remote.
2. Whether you are able to access your BANano WebApp from your local development or remote webserver. The app on this download.
3. The steps are easy I hope.
4. We kindly request that you please run the tests and then come back here and reflect about your experiment.
What you need to do to make this work.
1. Download and install the BVAD3 library to your external libraries. Use the one from the provided download link above.
2. If you dont have banano installed, please set it up from here.
3. If you dont have a development webserver, please set up one
4, If you are using xampp, on the Main module, change your publish variable to use Xampp and change the \ to //
5. Open the mysqlconfig.php file and update it to reflect your MySQL connection settings.
6. On the Main module, change the ServerIP variable to be where your app is running from.
7. On pgIndex, change the dbname to be the actual name of your database
8. Ensure that your inbound & outbound tcp/ip connections to port 336 are set to be allowed on your firewall.
9. Grant Access for your MySQL user should be set to % for all IP addresses.
If you are running localhost with SSL, your ServerIP should be https otherwise it should be http.
For your remote host, you can also use localhost as the php file will be called from that machine. Also your DB_HOST can be localhost if the database is on the same machine, otherwise use the IP address of your web server.
If you dont have a successful connection, please indicate. Did you use an ip address / domain name / localhost for your connection, what is the error? What are the apache error logs saying etc.
What will this do and help with?
We have received indications that BVAD3 with PHP does not work and would like to get the details about cases why it does not work and possible solutions. In one of the cases, even a pure breed BANano PHP app could not connect whilst the php script run perfectly on the browser.
We are still investigating whether this is the source code we are writing or something else out of the ordinary and want to find out what we are missing and possibly doing wrong, and why in one instance, deployments work without issues and then for others nothing works.
As an example, if we use an ip address in BANAno.PHPHost, we get server errors, whilst using a domain name for the same everything works without hurdles.
I thank you.
Last edited: