Phraseanet
Phraseanet copied to clipboard
User from the installer lacks permissions?
I installed phraseanet 4.1 and 4.0.9 on an Ubuntu 18.04 machine both versions have the same issue. The installer completes and i can login with the user that has been created during the installation.
I want to create another user so i check the docs and they say: "Admin"->"Users"->"New User" So i go to "Admin" and see that i don't have the "Users" Page.
The reason for that seems to be that my user lacks the "canadmin" permission in basusr. While researching the bug i saw in templates/web/admin/tree.html.twig
{% if app.getAclForUser(app.getAuthenticatedUser()).has_right(constant('\\ACL::CANADMIN')) %}
<li class="{% if feature == 'users' %}selected{% endif %}">
<a target="right" href="{{ path('admin_users_search') }}" class="ajax zone_editusers">
<img src="/assets/admin/images/Users.png" />
<span>{{ 'admin::utilisateurs: utilisateurs' | trans }}</span>
</a>
</li>
<li class="{% if feature == 'registrations' %}selected{% endif %}">
<a target="right" href="{{ path('users_display_registrations') }}" class="ajax">
<img src="/assets/admin/images/Demandes.png" />
<span>{{ 'admin::utilisateurs: demandes en cours' | trans }}</span>
</a>
</li>
{% endif %}
That my user seems to need the canadmin flag. Looking into the basusr table i saw that my user doesn't even have an entry there so i made an insert into the table and it showed up (But fails with an error when trying to access it).
After that i tried to figure out why my user doesn't have this flags. Looking into lib/Alchemy/Phrasea/Setup/Installer.php and following the createUser trace, i saw that the User Object never sets those flags.
I'm not sure if this is a bug or if i've made an error? I would like to know what the correct way of installing Phraseanet is since the normal documented way seems to miss some important step. (Or i am just stupid)
Hello,
Looking at the way you’re investigating the matter, I am sure that you’re really far from being stupid :-)
The matter you’re encountering deals with MySQL's or MariaDB's default sql_mode. Disabling the strict mode will fix this.
Add into the my.cnf or my.ini
sql_mode=‘'
see : https://docs.phraseanet.com/4.0/en/Admin/Prerequisite.html#database
A pull request have been made by our development team adapt Phraseanet to SQL strict_mode.
Other way to test Phraseanet :
Use Docker : See details into the README of the application
User our virtualbox VM : https://www.phraseanet.com/builds/vm/vm_ovf1_vmdk_phraseanet40_rc_20170410.zip https://www.phraseanet.com/builds/vm/ReadmePhraseanet40preview.txt
Regards
Hello,
thanks for the help :) My DB was already running in NOT strict mode but i tried it again with an empty sql_mode:
mysql> SHOW VARIABLES LIKE 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode | |
+---------------+-------+
1 row in set (0.00 sec)
But this also doesn't work.
Here are some more information about the system maybe that will help:
mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper
Server version: Apache/2.4.29 (Ubuntu)
PHP 7.2.24-0ubuntu0.18.04.1
Looking at the docs again i saw this: Please note: PHP versions 7.1.0 or greater are not suitable at the moment. I am currently running 7.2, could this be the problem?
Phraseanet ./setup check:system
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "en_US:en",
LC_ALL = (unset),
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
Binaries requirements :
OK PHP CLI is required to run Phraseanet task manager
OK Phraseanet requires the Unix `file` command
OK Exiftool is required for reading, writing and editing meta information
OK Exiftool version 9.15 or higher is required (10.10 provided)
Binaries recommendations :
OK Phraseanet recommends `file` version 5.04 or higher
WARNING SWFTools are required for documents (Word, Excel, PDF, etc...) support
Please install SWFTools (http://www.swftools.org/)
OK Unoconv is required for documents (Word, Excel, etc...) support
OK Unoconv version 0.5 or higher is required (0.7 provided)
OK SWFTools (swfextract) are required for flash files support
OK SWFTools (swfextract) version 0.9.0 or higher is required (0.9.2 provided)
OK SWFTools (swfrender) are required for flash files support
OK SWFTools (swfrender) version 0.9.0 or higher is required (0.9.2 provided)
OK MP4Box is required for video support
OK MP4Box version 0.4.0 or higher is required (0.5.2 provided)
OK XPDF is required for PDF indexation
OK FFMpeg (or libav-tools) is required for Video processing
OK FFProbe (or avprobe) is required for Video processing
Cache Server requirements :
Cache Server recommendations :
WARNING A cache server extension such as Memcached, Memcache or Redis is recommended
Install and enable a cache server extension.
Filesystem requirements :
OK /var/www/html/Phraseanet/config directory must be writable
OK /var/www/html/Phraseanet/config/stamp directory must be writable
OK /var/www/html/Phraseanet/config/status directory must be writable
OK /var/www/html/Phraseanet/config/minilogos directory must be writable
OK /var/www/html/Phraseanet/config/templates directory must be writable
OK /var/www/html/Phraseanet/config/topics directory must be writable
OK /var/www/html/Phraseanet/config/wm directory must be writable
OK /var/www/html/Phraseanet/logs directory must be writable
OK /var/www/html/Phraseanet/tmp directory must be writable
OK /var/www/html/Phraseanet/tmp/locks directory must be writable
OK /var/www/html/Phraseanet/tmp/caption directory must be writable
OK /var/www/html/Phraseanet/tmp/lazaret directory must be writable
OK /var/www/html/Phraseanet/tmp/download directory must be writable
OK /var/www/html/Phraseanet/cache directory must be writable
OK /var/www/html/Phraseanet/www/custom directory must be writable
Filesystem recommendations :
Locales requirements :
OK intl extension should be available
Locales recommendations :
OK intl extension should be correctly configured
OK intl ICU version should be at least 4+
PHP requirements :
OK date.timezone setting must be set
OK detect_unicode must be disabled in php.ini
OK safe_mode must be disabled in php.ini
OK detect_unicode must be disabled in php.ini
OK file_uploads must be enabled in php.ini
OK session.cache_limiter must be disabled in php.ini
OK magic_quotes_gpc must be disabled in php.ini
OK magic_quotes_runtime must be disabled in php.ini
PHP recommendations :
OK short_open_tag should be disabled in php.ini
OK register_globals should be disabled in php.ini
OK session.auto_start should be disabled in php.ini
OK display_errors should be disabled in php.ini
OK display_startup_errors should be disabled in php.ini
OK allow_url_fopen should be enabled in php.ini
OK session.hash_bits_per_character should be at least 6
OK session.hash_function should be enabled in php.ini
OK session.use_only_cookies should be enabled in php.ini
OK session.use_cookies should be enabled in php.ini
OK session.cookie_http_only should be enabled in php.ini
WARNING session.cookie_secure should be enabled in php.ini, but only if you use HTTPS
Set session.cookie_secure to on in php.ini*.
System requirements :
OK PHP version must be at least 5.5.0 (7.2.24-0ubuntu0.18.04.1 installed)
OK Vendor libraries must be installed
OK date.timezone setting must be set
OK Configured default timezone "Europe/Berlin" must be supported by your installation of PHP
OK json_encode() must be available
OK session_start() must be available
OK ctype_alpha() must be available
OK token_get_all() must be available
OK simplexml_import_dom() must be available
OK detect_unicode must be disabled in php.ini
OK PCRE extension must be available
OK PHP-XML module should be installed
OK mb_strlen() should be available
OK iconv() should be available
OK exif extension is required
OK curl extension is required
OK gd extension is required
OK hash extension is required
OK proc_* functions are required
OK Socket extension is required for task manager
OK Zip extension is required for download
OK ZMQ extension is required.
OK utf8_decode() should be available
OK PDO should be installed
OK PDO should have MySQL driver installed (currently available: mysql)
System recommendations :
OK You should not use PHP 5.4.0 due to the PHP bug #61453
OK PCRE extension should be at least version 8.0 (8.39 installed)
OK pcntl extension is recommended in unix environments
OK Posix extension is recommended for task manager
WARNING Twig extension is strongly recommended in production
Install and enable the twig extension.
OK Imagick or Gmagick extension is strongly recommended for image processing
OK Fileinfo extension is recommended
OK posix_isatty() should be available
OK ftp extension is required for FTP export
OK a PHP accelerator should be installed
OK short_open_tag should be disabled in php.ini
OK magic_quotes_gpc should be disabled in php.ini
OK register_globals should be disabled in php.ini
OK session.auto_start should be disabled in php.ini
I've compared my system to the VM you provided and except for the versions of the programms everything else seems to be the same.