Fail to install Phraseanet

Steven Hua

unread,

May 12, 2021, 5:30:54 AM5/12/21

to phrasea-i...@googlegroups.com

Hi,

I'm trying to install Phraseanet on a local virtual machine running Ubuntu 20.10. The setup is PHP 7.0.33 and Apache 2.4.46. For simplicity, I created a host called phraseanetlocal0 and routed it in the system's hosts file.

I then followed the instruction of Apache (https://docs.phraseanet.com/4.1/en/Admin/Configuration/Apache.html) and used the same configuration. The directory is correct.

I also put a php info test page under the last www folder, and it works.

Then I started the installation process. I followed the command-line way given here (https://docs.phraseanet.com/4.0/en/Admin/Install.html).

But it shows the following error.

I also tried to install via the GUI, but when I go to the host phraseanetlocal0, I was redirected to phraseanetlocal0/setup, and it shows Not Found.

Can anyone help me with this? I'm not really an expert with PHP and Apache.

Thank you.

Yupeng Hua

unread,

May 12, 2021, 5:38:34 AM5/12/21

to phrasea-install-en

I do have another version of PHP installed in the system for another project. I don't know if this affects.

Moctar Diouf

unread,

May 12, 2021, 5:39:18 AM5/12/21

to phrasea-i...@googlegroups.com

Hello,

Seems like you are facing a matter dealing with sql_mode.

What is the result of theses mysql requests ?

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

If the result is :

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

This is what is causing the problem

To fix this :

add a line

sql_mode =

under [mysqld]

into the my.cnf or a mysql/conf.d/specific.conf file

restart mysql or mariadb and retry the installation.

Regards

Le 12 mai 2021 à 11:30, Steven Hua <stevenyu...@gmail.com> a écrit :

Hi,

I'm trying to install Phraseanet on a local virtual machine running Ubuntu 20.10. The setup is PHP 7.0.33 and Apache 2.4.46. For simplicity, I created a host called phraseanetlocal0 and routed it in the system's hosts file.

<image.png>

I then followed the instruction of Apache (https://docs.phraseanet.com/4.1/en/Admin/Configuration/Apache.html) and used the same configuration. The directory is correct.

<image.png>

I also put a php info test page under the last www folder, and it works.

<image.png>

Then I started the installation process. I followed the command-line way given here (https://docs.phraseanet.com/4.0/en/Admin/Install.html).

<image.png>

But it shows the following error.

<image.png>

I also tried to install via the GUI, but when I go to the host phraseanetlocal0, I was redirected to phraseanetlocal0/setup, and it shows Not Found.

<image.png>

Can anyone help me with this? I'm not really an expert with PHP and Apache.

Thank you.

--
You received this message because you are subscribed to the Google Groups "phrasea-install-en" group.
To unsubscribe from this group and stop receiving emails from it, send an email to phrasea-install...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/phrasea-install-en/CADY2-OoRjtfp9MUq8y6n-n-jRR%3DgYAeRG1dbmv9RjskJPC7%3DMQ%40mail.gmail.com.

Yupeng Hua

unread,

May 12, 2021, 10:18:52 AM5/12/21

to phrasea-install-en

Hi,

I tried your method but it doesn't work. The sql_mode was the one as you suggested, then I add the line in the my.cnf.