Hi
I'm trying to install piwigo 2.10.2 at powerfull openwrt router (2*1.4 GHz CPU, 512 RAM, 4 GB swap, 6 TB HDD).
Mysql (mariadb) version: 10.2.33-1.
I've downloaded zip archive with piwigo 2.10.2, extracted it and copied it to the /www/photos folder.
I've created mysql user for piwigo, granted him full access, created database.
Then I've go to 192.168.1.1/photos/ and tried to process with installation, but unsuccesfully...
I am getting these messages:
Warning: mysqli::__construct(): (HY000/2002): No such file or directory in /www/photos/include/dblayer/functions_mysqli.inc.php on line 52 Warning: mysqli::set_charset(): Couldn't fetch mysqli in /www/photos/include/dblayer/functions_mysqli.inc.php on line 88
And finally:
Cannot connect to server.
Could anybody navigate me in right direction?
Offline
Hi :-)
foler local/config
edit database.inc.php
$conf['dblayer'] = ?
Offline
There is no file database.inc.php among piwigo files at all...
root@OpenWrt:/www/photos# find . -name database.inc.php root@OpenWrt:/www/photos#
Offline
Hi :-)
Adresse server Sql ?
Offline
Host: loalhost
Here is a screenshot of the installation process:
https://imgur.com/GOAX4NY
Offline
Hi :-)
can you test with uk
Offline
I've tried English (UK) - same errors.
Here is the list of installed php and it's modules:
php7 - 7.2.31-1 php7-cgi - 7.2.31-1 php7-cli - 7.2.31-1 php7-mod-curl - 7.2.31-1 php7-mod-gd - 7.2.31-1 php7-mod-hash - 7.2.34-1 php7-mod-json - 7.2.31-1 php7-mod-mysqli - 7.2.34-1 php7-mod-mysqlnd - 7.2.34-1 php7-mod-openssl - 7.2.34-1 php7-mod-zip - 7.2.31-1
Here is my /etc/php.ini:
[PHP] zend.ze1_compatibility_mode = Off date.timezone = Europe/Kiev ; Language Options engine = On precision = 12 y2k_compliance = On output_buffering = Off zlib.output_compression = Off implicit_flush = Off unserialize_callback_func = serialize_precision = 100 ;open_basedir = disable_functions = disable_classes = ; Miscellaneous expose_php = On ; Resource Limits max_execution_time = 30 ; Maximum execution time of each script, in seconds. max_input_time = 60 ; Maximum amount of time each script may spend parsing request data. memory_limit = 8M ; Maximum amount of memory a script may consume. ; Error handling and logging error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT display_errors = On display_startup_errors = Off log_errors = Off log_errors_max_len = 1024 ignore_repeated_errors = Off ignore_repeated_source = Off report_memleaks = On track_errors = Off ; Data Handling variables_order = "EGPCS" request_order = "GP" register_globals = Off register_long_arrays = Off register_argc_argv = On auto_globals_jit = On post_max_size = 8M magic_quotes_runtime = Off magic_quotes_sybase = Off auto_prepend_file = auto_append_file = default_mimetype = "text/html" ; Paths and Directories user_dir = extension_dir = "/usr/lib/php" enable_dl = On cgi.fix_pathinfo=1 ; File Uploads file_uploads = On upload_tmp_dir = "/tmp" upload_max_filesize = 2M max_file_uploads = 20 ; Fopen wrappers allow_url_fopen = On allow_url_include = Off default_socket_timeout = 60
Offline
Make sure the database you are trying to connect to does exist and is reachable at localhost and can be logged in to with the user/password credentials you provided to the Piwigo setup, i.e. this works on the command line:
mysql --host=localhost --user=piwigo --password=YOURPASSWORD piwigodatabase
Offline
I've checked, I can connect successfully to the database using your command...
Offline
Dumb question, does the user the web server runs as have write permissions under /www/photos/ or at least in the {local,_data,upload} directories?
Offline
I use the uhttpd web server, it runs from the root user.
Root user has access to the /www/photos and all inside it.
My system has no /usr/bin/php binary (for web I must use /usr/bin/php-cgi) so I've created /usr/bin/php as symlink to /usr/bin/php-cgi...
But...unsuccessfully, piwigo still isn't installing...
Offline
That symbolic link doesn't sound right to me. See
https://openwrt.org/docs/guide-user/ser … using_php7
Offline
Btw, php.ini
memory_limit = 8M
is way too little. Give it at least 128M or better 256M. Also
upload_max_filesize = 2M
post_max_size = 8M
when using the file uploader won't make you happy with images larger than 2MB, or a maximum of 4 images of maximum 2MB ...
Offline
Of course string
list interpreter '.php=/usr/bin/php-cgi'
is present in the uhttpd config file.
I have changed memory lumits in php.ini, but this dont helps too.
What is going on?
Offline
However, your web server setup apparently is not able to write the local/config/database.inc.php file.
Offline