Zuluru
Installation Help
Hey yall! I am trying to make a project on wich anyone can just share their own tornument and create an league so everyone can see and automatic attend to that event; As of that i found this platform that seems to fit perfectly the purpose if this project. As i was trying to install the software i cant from anyhow to get it running.... Im on a EC2 t2.medium with ubuntu 24.04 and i installed php7.4 because it seems that is the only one that is capable of dealing with all the packages without errors. Step by step of what i did: 1- git clone to /var/www/html Using Apache2 2- after install compose, done sudo compose install (tried without sudo and came with permission error) 3- created an .env file on the root so at /var/www/html/zuluru3 3.1- Filled with SQL_USERNAME, SQL_DATABASE, SQL_PORT, SQL_HOSTNAME, SQL_PASSWORD and TIMEZONE=UTC; 3.2- Also changed on the bootstrap.php config file the date_default_timezone_set to TIMEZONE 4- Also created an file on /etc/apache2/sites-available/zuluru3.conf <VirtualHost *:80> ServerAdmin [email protected] ServerName yourdomain.com DocumentRoot /var/www/html/zuluru3/webroot
<Directory /var/www/html/zuluru3/webroot>
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Require all granted
</Directory>
ErrorLog ${APACHE_LOG_DIR}/zuluru3_error.log
CustomLog ${APACHE_LOG_DIR}/zuluru3_access.log combined
Update: The Timezone was fixed an small .env error, but still got the Plugin Scheduler error... while trying to use the bin/cake server. Apache still shows an default page?
At this point i tried so many things that i cant even remember everything :(
I'll assume you used the master branch. There's a new "cake4" branch which will very soon become official, but isn't quite there yet. It's mostly upgrades for various things (PHP, MySQL, CakePHP framework, third party packages). #49 is working on resolving installation issues there.
All that said, your main problem seems to be that you tried to create the .env file on your own, instead of using the web-based installer, per the instructions in the readme file. Not sure that doing so will resolve it all for you at this point, waiting for a couple weeks until I have time to really nail down the new version might be your best bet.
Yes, i created the .env file for my self because i just came along many issues and couldnt get the web installer going trough; Btw i tried to do a composer install on a fresh os installation with php8.0 on the cakephp4 branch but came with the same issue: Exception: Plugin Scheduler could not be found. In [/home/admin/Zuluru3/vendor/cakephp/cakephp/src/Core/PluginCollection.php, line 143]
Just to see if this helps out trying to sort out bugs but on ubuntu 22.04 on the cakephp4 branch: ubuntu:~/Zuluru3$ sudo docker-compose up -d Building app DEPRECATED: The legacy builder is deprecated and will be removed in a future release. Install the buildx component to build images with BuildKit: https://docs.docker.com/go/buildx/
Sending build context to Docker daemon 20.31MB Step 1/9 : FROM php:7.3-alpine ---> 8e078b6a6493 Step 2/9 : RUN apk add --update autoconf git icu-dev libzip-dev php7-curl php7-intl php7-mbstring php7-mysqli php7-opcache php7-openssl php7-pdo_mysql php7-pdo_pgsql php7-pgsql php7-zip php7-zlib postgresql-dev && docker-php-ext-configure pdo_mysql --with-pdo-mysql=mysqlnd && docker-php-ext-install intl mbstring pcntl pdo_mysql pdo_pgsql pgsql zip opcache && rm -rf /var/cache/apk/* ---> Using cache ---> f6fea09035f4 Step 3/9 : RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/bin/ --filename=composer ---> Using cache ---> 4651db0f8756 Step 4/9 : COPY . /var/www/html ---> Using cache ---> 04a664c02659 Step 5/9 : WORKDIR /var/www/html ---> Using cache ---> 790443329d2b Step 6/9 : RUN composer install --no-interaction ---> Running in cf7904dbdb3d Installing dependencies from lock file (including require-dev) Verifying lock file contents can be installed on current platform. Your lock file does not contain a compatible set of packages. Please run composer update.
Problem 1 - Root composer.json requires php >=7.4.0 but your php version (7.3.33) does not satisfy that requirement. Problem 2 - cakephp/migrations is locked to version 3.6.1 and an update of this package was not requested. - cakephp/migrations 3.6.1 requires php >=7.4.0 -> your php version (7.3.33) does not satisfy that requirement. Problem 3 - dereuromark/cakephp-calendar is locked to version 1.5.0 and an update of this package was not requested. - dereuromark/cakephp-calendar 1.5.0 requires php >=7.4 -> your php version (7.3.33) does not satisfy that requirement. Problem 4 - firebase/php-jwt is locked to version v6.10.0 and an update of this package was not requested. - firebase/php-jwt v6.10.0 requires php ^7.4||^8.0 -> your php version (7.3.33) does not satisfy that requirement. Problem 5 - laminas/laminas-diactoros is locked to version 2.17.0 and an update of this package was not requested. - laminas/laminas-diactoros 2.17.0 requires php ^7.4 || ~8.0.0 || ~8.1.0 -> your php version (7.3.33) does not satisfy that requirement. Problem 6 - laminas/laminas-zendframework-bridge is locked to version 1.6.1 and an update of this package was not requested. - laminas/laminas-zendframework-bridge 1.6.1 requires php >=7.4, <8.2 -> your php version (7.3.33) does not satisfy that requirement. Problem 7 - league/mime-type-detection is locked to version 1.15.0 and an update of this package was not requested. - league/mime-type-detection 1.15.0 requires php ^7.4 || ^8.0 -> your php version (7.3.33) does not satisfy that requirement. Problem 8 - psr/container is locked to version 1.1.2 and an update of this package was not requested. - psr/container 1.1.2 requires php >=7.4.0 -> your php version (7.3.33) does not satisfy that requirement. Problem 9 - zuluru/cakephp-bootstrap is locked to version dev-cake4 and an update of this package was not requested. - zuluru/cakephp-bootstrap dev-cake4 requires php >=7.4 -> your php version (7.3.33) does not satisfy that requirement. Problem 10 - zuluru/cakephp-jquery is locked to version dev-cake4 and an update of this package was not requested. - zuluru/cakephp-jquery dev-cake4 requires php >=7.4 -> your php version (7.3.33) does not satisfy that requirement. Problem 11 - fakerphp/faker is locked to version v1.23.1 and an update of this package was not requested. - fakerphp/faker v1.23.1 requires php ^7.4 || ^8.0 -> your php version (7.3.33) does not satisfy that requirement. Problem 12 - nikic/php-parser is locked to version v5.0.2 and an update of this package was not requested. - nikic/php-parser v5.0.2 requires php >=7.4 -> your php version (7.3.33) does not satisfy that requirement. Problem 13 - psy/psysh is locked to version v0.12.2 and an update of this package was not requested. - psy/psysh v0.12.2 requires php ^8.0 || ^7.4 -> your php version (7.3.33) does not satisfy that requirement. Problem 14 - laminas/laminas-diactoros 2.17.0 requires php ^7.4 || ~8.0.0 || ~8.1.0 -> your php version (7.3.33) does not satisfy that requirement. - cakephp/authentication 2.9.0 requires laminas/laminas-diactoros ^2.2.2 -> satisfiable by laminas/laminas-diactoros[2.17.0]. - cakephp/authentication is locked to version 2.9.0 and an update of this package was not requested. The command '/bin/sh -c composer install --no-interaction' returned a non-zero code: 2 ERROR: Service 'app' failed to build : Build failed
Thanks for your patience on this. Docker support is unofficial, contributed by a third-party. I have not yet gotten into any of that, so I'm not in a good position to help with those details. I do know that PHP 7.4 is required to run the latest version, so if the Docker container doesn't provide that, then that's going to need an upgrade. I'll aim to get to that once the CakePHP4 branch itself is finalized and I get all my server updates completed.
The issues with "Plugin Scheduler could not be found." should be resolved now, with the latest update to the CakePHP4 branch.
Hey again, after a while decided to try it again on this project. To summarize a bit what i did was on a fresh installation of portainer i set up to pull the image of the cakhephp4 and to build it. Wich was sucessfull. However the database that comes on the stack dosent work and therefore i was required to setup an external database (not any problem on connecting tho). So far it seems that is all ok with one reaaly big inconvenient: Why in the world the only countrys avaiable are Canada and USA? Like.... it may be from me but i think a bit weird..? Any way to add other countries? I will be prodiving more feedback as im trying to enroll on the platform! Thanks in advance.
Update: Leagues Have major errors: when trying to create an league or view the league summary an: Error: An Internal Error Has Occurred. pops-up. No usefull logs tho as in portainer only appears this: [Sun Sep 8 14:35:51 2024] 192.168.1.28:62556 [200]: /img/help_16.png?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62557 [200]: /css/pace/themes/pace-theme-minimal.css?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62558 [200]: /img/add_32.png?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62559 [200]: /img/view_32.png?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62560 [200]: /img/dropdown.png?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62561 [200]: /js/zuluru.js?1573761399 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62562 [200]: /js/pace.min.js?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62563 [200]: /img/facebook.png?1545263252 [Sun Sep 8 14:35:51 2024] 192.168.1.28:62564 [200]: /img/calendar.png [Sun Sep 8 14:36:15 2024] 192.168.1.28:62608 [200]: /css/zuluru/look.css?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62567 [200]: /css/zuluru/layout.css?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62609 [200]: /css/pace/themes/pace-theme-minimal.css?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62610 [200]: /img/view_32.png?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62611 [200]: /img/edit_32.png?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62612 [200]: /img/facebook.png?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62613 [200]: /img/dropdown.png?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62614 [200]: /js/pace.min.js?1545263252 [Sun Sep 8 14:36:15 2024] 192.168.1.28:62615 [200]: /js/zuluru.js?1573761399 [Sun Sep 8 14:36:16 2024] 192.168.1.28:62616 [200]: /favicon.ico?1545263252 [Sun Sep 8 14:36:16 2024] 192.168.1.28:62617 [200]: /favicon.ico?1545263252 [Sun Sep 8 14:36:21 2024] 192.168.1.28:62625 [200]: /css/zuluru/layout.css?1545263252 [Sun Sep 8 14:36:21 2024] 192.168.1.28:62626 [200]: /css/zuluru/look.css?1545263252 [Sun Sep 8 14:36:21 2024] 192.168.1.28:62627 [200]: /css/pace/themes/pace-theme-minimal.css?1545263252 [Sun Sep 8 14:36:21 2024] 192.168.1.28:62628 [200]: /img/facebook.png?1545263252 [Sun Sep 8 14:36:21 2024] 192.168.1.28:62629 [200]: /js/pace.min.js?1545263252 [Sun Sep 8 14:36:21 2024] 192.168.1.28:62630 [200]: /js/zuluru.js?1573761399
Also im having a few problems on deploying SSL from zoraxy (reverse proxy).
Using https shows the following errors on debug=true: Notice (8): compact(): Undefined variable: etagMatches [CORE/src/Http/Response.php, line 2066] Notice (8): compact() [function.compact]: Undefined variable: timeMatches [CORE/src/Http/Response.php, line 2066] Notice (8): compact() [function.compact]: Undefined variable: etagMatches [CORE/src/Http/Response.php, line 2066] Notice (8): compact() [function.compact]: Undefined variable: timeMatches [CORE/src/Http/Response.php, line 2066] Warning (512): Unable to emit headers. Headers sent in file=/var/www/html/vendor/cakephp/cakephp/src/Error/Debugger.php line=853 [CORE/src/Http/ResponseEmitter.php, line 48] Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/html/vendor/cakephp/cakephp/src/Error/Debugger.php:853) [CORE/src/Http/ResponseEmitter.php, line 148] Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/html/vendor/cakephp/cakephp/src/Error/Debugger.php:853) [CORE/src/Http/ResponseEmitter.php, line 177]
Those look like you're using PHP8, but Zuluru is not yet PHP8 compliant. Should work fine with PHP7.4. One of many updates that need to happen in the next few months.
And about the error i posted earlier? Error: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'content' at row 1 Here is the mariadb scheme: MariaDB [zuluru]> SHOW COLUMNS FROM leagues; +--------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(100) | YES | | NULL | | | sport | varchar(32) | NO | | NULL | | | season | varchar(16) | NO | | None | | | open | date | NO | | NULL | | | close | date | NO | | NULL | | | is_open | tinyint(1) | NO | | 0 | | | schedule_attempts | int(11) | YES | | 100 | | | display_sotg | varchar(32) | NO | | all | | | sotg_questions | varchar(32) | YES | | NULL | | | numeric_sotg | tinyint(1) | YES | | NULL | | | expected_max_score | int(11) | NO | | NULL | | | affiliate_id | int(11) | NO | MUL | 1 | | | stat_tracking | varchar(32) | NO | | never | | | tie_breaker | varchar(100) | NO | | NULL | | | carbon_flip | tinyint(1) | NO | | 0 | | | content | varchar(32) | YES | | NULL | | +--------------------+--------------+------+-----+---------+----------------+ 17 rows in set (0.000 sec)
MariaDB [zuluru]> ALTER TABLE leagues MODIFY content VARCHAR(200);
Query OK, 0 rows affected (0.618 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zuluru]>
The CakePHP 4 branch has (finally!) been finalized and merged to master. I'm hoping that this will finally clear up all these installation issues. I have successfully run installations of this using PHP 7.4 and MySQL 8.0.
I'm not sure where the "content" problem is coming from; I don't believe that the leagues table has ever had a field called content in it. The i18n table did, but it would have been a "text" column with a max size way bigger than 32 characters.