Announcement

#1 2020-03-03 13:01:35

Webcomedian
Member
2020-03-03
4

Setup Question

Hello/Hi/Greetings,

I am trying to set it up on a new server. It is unix based and does support PHP and SQL

When I run the manual or the auto install it is missing something as shown in the docs.

1st the docs show version 2.2, but the install script shows. 2.10.1

I enter all the correct information and it says it cannot connect to server. But the docs show that there is a pull down menu to select the type of database and it shows MYSQL

Here are the parameters:

Description | photos
Host name   |localhost
Port        |3306
User name   |(I HAVE IT HIDDEN HERE)
Type/version|MySQL 5.5
Storage     |not available

That is my server info.. I do not see a place to put the port in in the install

I created the database with a user and pw (admin account)

Do i need 2.2? If so where do I get it?

Thanks.. and I look forward to using this




Piwigo version:
PHP version:
MySQL version:
Piwigo URL: http://

Offline

 

#2 2020-03-03 17:20:53

erAck
Only trying to help
2015-09-06
2026

Re: Setup Question

Webcomedian wrote:

1st the docs show version 2.2, but the install script shows. 2.10.1

The docs are older, but installation should be about the same.

I do not see a place to put the port in in the install

Port 3306 is the default MySQL port and shouldn't need any specific treatment.
Make sure you have the database user setup correctly with MySQL and entered the correct user and password in Piwigo, and the database is indeed reachable with these parameters at localhost. Try with Adminer or phpMyAdmin.

Do i need 2.2? If so where do I get it?

No. 2.10.1 is the most recent version.


Another possibility is that you don't have a matching mysqli or mysql PHP extension loaded in your webserver environment. mysqli is mandatory for PHP >= 7, mysql is a possible fallback for older PHP versions (not recommended to use those, use 7.1 or 7.2).


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

Offline

 

#3 2020-03-03 22:26:48

Webcomedian
Member
2020-03-03
4

Re: Setup Question

Thanks for the feedback.. it still does not work.. here is what I have

PHP version is 7.2. It was set to 7.3, but changed it to 7.3.,  7.4 is also available and I can click and extended support is available for 7.1, 7.0. 5.6, 5.5, 5.4, 5.2 and 4.0.

It says I can order PHP extended support for the older ones. But that costs extra money per month to my server. That ain't going to happen.

Here are the database details..

Database: dbdbdb
Description: Photos
Host Name: localhost
Port: 3306
Type and version: MySQL 5.5
Storage: Not available

I copied and pasted to a text file so I know I typed it right.
Here is what I entered in Piwigo

Host: localhost
User: uuuuuu   (this is the admin account for the server)
Password:
Database name: dbdbdb
Database tables prefix: piwigo (this was filled by the installation)

Administration configuration
Username: dbdbdb

Sometimes it just says CAN'T CONNECT TO SERVER and other times it says that and says check username and password.

The uuuuuu is the admin username to the server
the  dbdbdb is the database user for the Photo database

But no where do I put in the server/host name that I access the server with... should I change the localhost to that?

Thanks in advance

Offline

 

#4 2020-03-03 22:30:33

Webcomedian
Member
2020-03-03
4

Re: Setup Question

When it tells me the user and password is wrong it does not tell me which one it is and it clears out all the passwords so I have to enter it again.

Offline

 

#5 2020-03-04 02:58:43

erAck
Only trying to help
2015-09-06
2026

Re: Setup Question

You should not publicly post database name and username details, I redacted those for you.

I doubt the database's admin username is the correct one to use, unless things are set up that way. It likely is a database username instead. If in doubt ask your hosting provider.

localhost is fine as long as the database is reachable on the same host as the web server runs on.
Again, try if the database is reachable with your credentials in the constellation with the webserver using Adminer or phpMyAdmin.


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

Offline

 

#6 2020-03-04 03:24:55

Webcomedian
Member
2020-03-03
4

Re: Setup Question

OK, I have to call them anyhow as when I use sFTP it says that the port is 22. If I set the FTP client to 22 it does not work. With Filezilla I have to set it to an empty field and it works.

I can't use other admin programs for it as it is a c-panel.

I tried another PHP script and it does not work either. Just having bad luck.

I think I will try the galleries that I created in Photoshop using HTML5 and see if they work.

Thanks for the help. I am not giving up on this script, because I like what I see..

Listen to my blues show at ***

Offline

 

#7 2020-03-04 17:29:40

erAck
Only trying to help
2015-09-06
2026

Re: Setup Question

Adminer is a single PHP file you can drop (and delete after) anywhere under a temporary directory or subdomain and invoke by pointing your browser to it. It does not require the server's admin access.


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

Offline

 

Board footer

Powered by FluxBB

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