Announcement

#1 2020-11-14 15:33:01

kt368
Member
2020-11-14
9

Installation thru web browser: Cannot connect to server

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:

Code:

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:

Code:

Cannot connect to server.

Could anybody navigate me in right direction?

Offline

 

#2 2020-11-14 16:07:14

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Installation thru web browser: Cannot connect to server

Hi :-)

foler local/config

edit database.inc.php



$conf['dblayer'] = ?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#3 2020-11-14 16:49:58

kt368
Member
2020-11-14
9

Re: Installation thru web browser: Cannot connect to server

There is no file database.inc.php among piwigo files at all...

Code:

root@OpenWrt:/www/photos# find . -name database.inc.php
root@OpenWrt:/www/photos#

Offline

 

#4 2020-11-14 17:10:25

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Installation thru web browser: Cannot connect to server

Hi :-)

Adresse server Sql ?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#5 2020-11-14 17:22:33

kt368
Member
2020-11-14
9

Re: Installation thru web browser: Cannot connect to server

Host: loalhost
Here is a screenshot of the installation process:
https://imgur.com/GOAX4NY

Offline

 

#6 2020-11-14 20:36:10

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: Installation thru web browser: Cannot connect to server

Hi :-)

can you test with uk


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#7 2020-11-15 11:38:58

kt368
Member
2020-11-14
9

Re: Installation thru web browser: Cannot connect to server

I've tried English (UK) - same errors.
Here is the list of installed php and it's modules:

Code:

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:

Code:

[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

 

#8 2020-11-15 12:24:31

erAck
Only trying to help
2015-09-06
2027

Re: Installation thru web browser: Cannot connect to server

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:

Code:

mysql --host=localhost --user=piwigo --password=YOURPASSWORD piwigodatabase

Running Piwigo at https://erack.net/gallery/

Offline

 

#9 2020-11-15 12:42:44

kt368
Member
2020-11-14
9

Re: Installation thru web browser: Cannot connect to server

I've checked, I can connect successfully to the database using your command...

Offline

 

#10 2020-11-15 13:45:51

erAck
Only trying to help
2015-09-06
2027

Re: Installation thru web browser: Cannot connect to server

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?


Running Piwigo at https://erack.net/gallery/

Offline

 

#11 2020-11-15 14:18:17

kt368
Member
2020-11-14
9

Re: Installation thru web browser: Cannot connect to server

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

 

#12 2020-11-15 14:33:46

erAck
Only trying to help
2015-09-06
2027

Re: Installation thru web browser: Cannot connect to server

That symbolic link doesn't sound right to me. See
https://openwrt.org/docs/guide-user/ser … using_php7


Running Piwigo at https://erack.net/gallery/

Offline

 

#13 2020-11-15 15:24:39

erAck
Only trying to help
2015-09-06
2027

Re: Installation thru web browser: Cannot connect to server

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 ...


Running Piwigo at https://erack.net/gallery/

Offline

 

#14 2020-11-15 22:21:43

kt368
Member
2020-11-14
9

Re: Installation thru web browser: Cannot connect to server

Of course string

Code:

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

 

#15 2020-11-15 23:22:33

erAck
Only trying to help
2015-09-06
2027

Re: Installation thru web browser: Cannot connect to server

However, your web server setup apparently is not able to write the local/config/database.inc.php file.


Running Piwigo at https://erack.net/gallery/

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact