
Quote from dglojnar on June 20, 2022, 7:19 pm@luishp
I made a small database app with VN WEB and, when I run locally with neoPHP server ,everything works great :-)
Database is SQLite 3, around 15.000 records...
In a meantime I made a WEB server on my Synology NAS with following setup, pretty straightforward:
Apache 2.4
PHP 7.4 and 8.0
phpMyAdmin
MariaDB/MySQL database
Following your instructions, I copied complete app (compiled) folder on WEB Server and app, of course not working - I'm 99% sure that is a PHP problem...
So, my question is - can I copy config.php to root folder of my WEB Server?
Or something else?
Is PHP 7.4 / 8.0 understand config.php or I have to edit file ?
I don't see too much logic to start nepPHP Server from my computer...
As I said, DB is SQLite 3.
Thank you in advance :-)
Cheers!
I made a small database app with VN WEB and, when I run locally with neoPHP server ,everything works great :-)
Database is SQLite 3, around 15.000 records...
In a meantime I made a WEB server on my Synology NAS with following setup, pretty straightforward:
Apache 2.4
PHP 7.4 and 8.0
phpMyAdmin
MariaDB/MySQL database
Following your instructions, I copied complete app (compiled) folder on WEB Server and app, of course not working - I'm 99% sure that is a PHP problem...
So, my question is - can I copy config.php to root folder of my WEB Server?
Or something else?
Is PHP 7.4 / 8.0 understand config.php or I have to edit file ?
I don't see too much logic to start nepPHP Server from my computer...
As I said, DB is SQLite 3.
Thank you in advance :-)
Cheers!

Quote from luishp on June 20, 2022, 8:24 pm@dglojnar it's not easy to configure your own web server. You don't only need PHP, but Apache server or NGIX too.
It's also necessary to be sure all the required PHP extensions are loaded (specialy pdo extensions for SQLite).This is the default php.ini file content in neoPhp server:
;This configuration file will be copied to each project everytime the server starts. ;and will be removed automatically everytime the server stops. ;Usually it's not necessary to edit it. date.timezone="Europe/Madrid" ; Maximum allowed size for uploaded files. upload_max_filesize = 200M ; Must be greater than or equal to upload_max_filesize post_max_size = 200M ; Enable ODBC extension module extension=./php/ext/php_odbc.dll extension=./php/ext/php_pdo_odbc.dll ; Enable SQLServer extension module extension=./php/ext/php_sqlsrv_74_nts_x86.dll extension=./php/ext/php_pdo_sqlsrv_74_nts_x86.dll ; Enable sqlite extension module extension=./php/ext/php_pdo_sqlite.dll extension=./php/ext/php_sqlite.dll ; Enable mysql extension module extension=./php/ext/php_pdo_mysql.dll extension=./php/ext/php_mysql.dll ;Enable GD extension extension=./php/ext/php_gd2.dll ;Enable mbstring extension extension=./php/ext/php_mbstring.dll ;Enable cURL extension extension=./php/ext/php_curl.dll allow_url_fopen = On allow_url_include = Off asp_tags = Off display_errors = On enable_dl = On file_uploads = On max_execution_time = 120 max_input_time = 60 max_input_vars = 10000 memory_limit = 256M session.gc_maxlifetime = 1440 zlib.output_compression = Off
@dglojnar it's not easy to configure your own web server. You don't only need PHP, but Apache server or NGIX too.
It's also necessary to be sure all the required PHP extensions are loaded (specialy pdo extensions for SQLite).
This is the default php.ini file content in neoPhp server:
;This configuration file will be copied to each project everytime the server starts. ;and will be removed automatically everytime the server stops. ;Usually it's not necessary to edit it. date.timezone="Europe/Madrid" ; Maximum allowed size for uploaded files. upload_max_filesize = 200M ; Must be greater than or equal to upload_max_filesize post_max_size = 200M ; Enable ODBC extension module extension=./php/ext/php_odbc.dll extension=./php/ext/php_pdo_odbc.dll ; Enable SQLServer extension module extension=./php/ext/php_sqlsrv_74_nts_x86.dll extension=./php/ext/php_pdo_sqlsrv_74_nts_x86.dll ; Enable sqlite extension module extension=./php/ext/php_pdo_sqlite.dll extension=./php/ext/php_sqlite.dll ; Enable mysql extension module extension=./php/ext/php_pdo_mysql.dll extension=./php/ext/php_mysql.dll ;Enable GD extension extension=./php/ext/php_gd2.dll ;Enable mbstring extension extension=./php/ext/php_mbstring.dll ;Enable cURL extension extension=./php/ext/php_curl.dll allow_url_fopen = On allow_url_include = Off asp_tags = Off display_errors = On enable_dl = On file_uploads = On max_execution_time = 120 max_input_time = 60 max_input_vars = 10000 memory_limit = 256M session.gc_maxlifetime = 1440 zlib.output_compression = Off

Quote from dglojnar on June 20, 2022, 10:03 pm@luishp
Thank you for your quick response and php.ini :-)
On Synology NAS Apache server 2.4 is installed (PHP 7.4 also) and all PHP extensions (included a pdo ) are loaded.
Is this enough to copy php.ini on the root of my server ?
With best regards!
Thank you for your quick response and php.ini :-)
On Synology NAS Apache server 2.4 is installed (PHP 7.4 also) and all PHP extensions (included a pdo ) are loaded.
Is this enough to copy php.ini on the root of my server ?
With best regards!

Quote from luishp on June 21, 2022, 6:54 amIs this enough to copy php.ini on the root of my server ?
No, don't do that. The correct php.ini file depends on your folder structure.
You should compare it with yours and check if there is any missing item.
Once everything is correct you should be able to run your app as you do with neoPhp server.
If you have any problem, remember to check the web browser console (F12) to see any possible error message.Regards.
Is this enough to copy php.ini on the root of my server ?
No, don't do that. The correct php.ini file depends on your folder structure.
You should compare it with yours and check if there is any missing item.
Once everything is correct you should be able to run your app as you do with neoPhp server.
If you have any problem, remember to check the web browser console (F12) to see any possible error message.
Regards.
