Ambiente FreeBSD/Jails

[Felipe N. Oliva 0]

Fala galera!

Alguém roda o ambiente sobre FreeBSD? Muitas dificuldades?

Estou montando um ambiente dedicado e gostaria de separar em Jails(semelhante ao Docker no Linux).

Atendi os requisitos solicitados na documentação oficial, tentei fazer a instalação via composer, via git+composer, via download do zip, mas tudo sem sucesso, parece que o maior problema é satisfazer as dependencias que o composer precisa baixar.

Ambiente: freebsd 12.2, iocage, apache24, php73, magento 2.3.3

Erro:

# composer install
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Package container-interop/container-interop is abandoned, you should avoid using it. Use psr/container instead.
Package facebook/webdriver is abandoned, you should avoid using it. Use php-webdriver/webdriver instead.
Package flow/jsonpath is abandoned, you should avoid using it. Use softcreatr/jsonpath instead.
Package fzaninotto/faker is abandoned, you should avoid using it. No replacement was suggested.
Package phpunit/php-token-stream is abandoned, you should avoid using it. No replacement was suggested.
Package phpunit/phpunit-mock-objects is abandoned, you should avoid using it. No replacement was suggested.
Package sebastian/finder-facade is abandoned, you should avoid using it. No replacement was suggested.
Package zendframework/zend-captcha is abandoned, you should avoid using it. Use laminas/laminas-captcha instead.
Package zendframework/zend-code is abandoned, you should avoid using it. Use laminas/laminas-code instead.
Package zendframework/zend-config is abandoned, you should avoid using it. Use laminas/laminas-config instead.
Package zendframework/zend-console is abandoned, you should avoid using it. Use laminas/laminas-console instead.
Package zendframework/zend-crypt is abandoned, you should avoid using it. Use laminas/laminas-crypt instead.
Package zendframework/zend-db is abandoned, you should avoid using it. Use laminas/laminas-db instead.
Package zendframework/zend-di is abandoned, you should avoid using it. Use laminas/laminas-di instead.
Package zendframework/zend-diactoros is abandoned, you should avoid using it. Use laminas/laminas-diactoros instead.
Package zendframework/zend-escaper is abandoned, you should avoid using it. Use laminas/laminas-escaper instead.
Package zendframework/zend-eventmanager is abandoned, you should avoid using it. Use laminas/laminas-eventmanager instead.
Package zendframework/zend-feed is abandoned, you should avoid using it. Use laminas/laminas-feed instead.
Package zendframework/zend-filter is abandoned, you should avoid using it. Use laminas/laminas-filter instead.
Package zendframework/zend-form is abandoned, you should avoid using it. Use laminas/laminas-form instead.
Package zendframework/zend-http is abandoned, you should avoid using it. Use laminas/laminas-http instead.
Package zendframework/zend-hydrator is abandoned, you should avoid using it. Use laminas/laminas-hydrator instead.
Package zendframework/zend-i18n is abandoned, you should avoid using it. Use laminas/laminas-i18n instead.
Package zendframework/zend-inputfilter is abandoned, you should avoid using it. Use laminas/laminas-inputfilter instead.
Package zendframework/zend-json is abandoned, you should avoid using it. Use laminas/laminas-json instead.
Package zendframework/zend-loader is abandoned, you should avoid using it. Use laminas/laminas-loader instead.
Package zendframework/zend-log is abandoned, you should avoid using it. Use laminas/laminas-log instead.
Package zendframework/zend-mail is abandoned, you should avoid using it. Use laminas/laminas-mail instead.
Package zendframework/zend-math is abandoned, you should avoid using it. Use laminas/laminas-math instead.
Package zendframework/zend-mime is abandoned, you should avoid using it. Use laminas/laminas-mime instead.
Package zendframework/zend-modulemanager is abandoned, you should avoid using it. Use laminas/laminas-modulemanager instead.
Package zendframework/zend-mvc is abandoned, you should avoid using it. Use laminas/laminas-mvc instead.
Package zendframework/zend-psr7bridge is abandoned, you should avoid using it. Use laminas/laminas-psr7bridge instead.
Package zendframework/zend-serializer is abandoned, you should avoid using it. Use laminas/laminas-serializer instead.
Package zendframework/zend-server is abandoned, you should avoid using it. Use laminas/laminas-server instead.
Package zendframework/zend-servicemanager is abandoned, you should avoid using it. Use laminas/laminas-servicemanager instead.
Package zendframework/zend-session is abandoned, you should avoid using it. Use laminas/laminas-session instead.
Package zendframework/zend-soap is abandoned, you should avoid using it. Use laminas/laminas-soap instead.
Package zendframework/zend-stdlib is abandoned, you should avoid using it. Use laminas/laminas-stdlib instead.
Package zendframework/zend-text is abandoned, you should avoid using it. Use laminas/laminas-text instead.
Package zendframework/zend-uri is abandoned, you should avoid using it. Use laminas/laminas-uri instead.
Package zendframework/zend-validator is abandoned, you should avoid using it. Use laminas/laminas-validator instead.
Package zendframework/zend-view is abandoned, you should avoid using it. Use laminas/laminas-view instead.
Generating autoload files
42 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
 

[Felipe N. Oliva 0]

1 hour ago, Felipe N. Oliva said:

Fala galera!

Alguém roda o ambiente sobre FreeBSD? Muitas dificuldades?

Estou montando um ambiente dedicado e gostaria de separar em Jails(semelhante ao Docker no Linux).

Atendi os requisitos solicitados na documentação oficial, tentei fazer a instalação via composer, via git+composer, via download do zip, mas tudo sem sucesso, parece que o maior problema é satisfazer as dependencias que o composer precisa baixar.

Ambiente: freebsd 12.2, iocage, apache24, php73, magento 2.3.3

Erro:

# composer install
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Package container-interop/container-interop is abandoned, you should avoid using it. Use psr/container instead.
Package facebook/webdriver is abandoned, you should avoid using it. Use php-webdriver/webdriver instead.
Package flow/jsonpath is abandoned, you should avoid using it. Use softcreatr/jsonpath instead.
Package fzaninotto/faker is abandoned, you should avoid using it. No replacement was suggested.
Package phpunit/php-token-stream is abandoned, you should avoid using it. No replacement was suggested.
Package phpunit/phpunit-mock-objects is abandoned, you should avoid using it. No replacement was suggested.
Package sebastian/finder-facade is abandoned, you should avoid using it. No replacement was suggested.
Package zendframework/zend-captcha is abandoned, you should avoid using it. Use laminas/laminas-captcha instead.
Package zendframework/zend-code is abandoned, you should avoid using it. Use laminas/laminas-code instead.
Package zendframework/zend-config is abandoned, you should avoid using it. Use laminas/laminas-config instead.
Package zendframework/zend-console is abandoned, you should avoid using it. Use laminas/laminas-console instead.
Package zendframework/zend-crypt is abandoned, you should avoid using it. Use laminas/laminas-crypt instead.
Package zendframework/zend-db is abandoned, you should avoid using it. Use laminas/laminas-db instead.
Package zendframework/zend-di is abandoned, you should avoid using it. Use laminas/laminas-di instead.
Package zendframework/zend-diactoros is abandoned, you should avoid using it. Use laminas/laminas-diactoros instead.
Package zendframework/zend-escaper is abandoned, you should avoid using it. Use laminas/laminas-escaper instead.
Package zendframework/zend-eventmanager is abandoned, you should avoid using it. Use laminas/laminas-eventmanager instead.
Package zendframework/zend-feed is abandoned, you should avoid using it. Use laminas/laminas-feed instead.
Package zendframework/zend-filter is abandoned, you should avoid using it. Use laminas/laminas-filter instead.
Package zendframework/zend-form is abandoned, you should avoid using it. Use laminas/laminas-form instead.
Package zendframework/zend-http is abandoned, you should avoid using it. Use laminas/laminas-http instead.
Package zendframework/zend-hydrator is abandoned, you should avoid using it. Use laminas/laminas-hydrator instead.
Package zendframework/zend-i18n is abandoned, you should avoid using it. Use laminas/laminas-i18n instead.
Package zendframework/zend-inputfilter is abandoned, you should avoid using it. Use laminas/laminas-inputfilter instead.
Package zendframework/zend-json is abandoned, you should avoid using it. Use laminas/laminas-json instead.
Package zendframework/zend-loader is abandoned, you should avoid using it. Use laminas/laminas-loader instead.
Package zendframework/zend-log is abandoned, you should avoid using it. Use laminas/laminas-log instead.
Package zendframework/zend-mail is abandoned, you should avoid using it. Use laminas/laminas-mail instead.
Package zendframework/zend-math is abandoned, you should avoid using it. Use laminas/laminas-math instead.
Package zendframework/zend-mime is abandoned, you should avoid using it. Use laminas/laminas-mime instead.
Package zendframework/zend-modulemanager is abandoned, you should avoid using it. Use laminas/laminas-modulemanager instead.
Package zendframework/zend-mvc is abandoned, you should avoid using it. Use laminas/laminas-mvc instead.
Package zendframework/zend-psr7bridge is abandoned, you should avoid using it. Use laminas/laminas-psr7bridge instead.
Package zendframework/zend-serializer is abandoned, you should avoid using it. Use laminas/laminas-serializer instead.
Package zendframework/zend-server is abandoned, you should avoid using it. Use laminas/laminas-server instead.
Package zendframework/zend-servicemanager is abandoned, you should avoid using it. Use laminas/laminas-servicemanager instead.
Package zendframework/zend-session is abandoned, you should avoid using it. Use laminas/laminas-session instead.
Package zendframework/zend-soap is abandoned, you should avoid using it. Use laminas/laminas-soap instead.
Package zendframework/zend-stdlib is abandoned, you should avoid using it. Use laminas/laminas-stdlib instead.
Package zendframework/zend-text is abandoned, you should avoid using it. Use laminas/laminas-text instead.
Package zendframework/zend-uri is abandoned, you should avoid using it. Use laminas/laminas-uri instead.
Package zendframework/zend-validator is abandoned, you should avoid using it. Use laminas/laminas-validator instead.
Package zendframework/zend-view is abandoned, you should avoid using it. Use laminas/laminas-view instead.
Generating autoload files
42 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
 

Avancei. Fiz o processo novamente, mas baixando o arquivo.zip.

Consegui iniciar o setup e parou em 53%. Segue erro no httpd-error.log:

[Fri Apr 09 10:24:40.122364 2021] [php7:error] [pid 65832] [client mascarado:60738] PHP Fatal error:  Uncaught Exception: User Error: Some transactions have not been
committed or rolled back in /usr/local/www/mascarado/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php on line 3985 in /usr/local/www/mascarado/vendor/magento/framework/App/ErrorHandler.php:61\nStack trace:\n#0 [internal function]: Magento\\Framework\\App\\ErrorHandler->handler(256, 'Some transactio...', '/usr/
local/www/...', 3985, Array)\n#1 /usr/local/www/mascarado/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(3985): trigger_error('Some transactio...', 256)\
n#2 [internal function]: Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->__destruct()\n#3 {main}\n  thrown in /usr/local/www/mascarado/vendor/magento/framework
/App/ErrorHandler.php on line 61, referer: http://mascarado/setup/

 

[Felipe N. Oliva 0]

3 minutes ago, Felipe N. Oliva said:

Avancei. Fiz o processo novamente, mas baixando o arquivo.zip.

Consegui iniciar o setup e parou em 53%. Segue erro no httpd-error.log:

[Fri Apr 09 10:24:40.122364 2021] [php7:error] [pid 65832] [client mascarado:60738] PHP Fatal error:  Uncaught Exception: User Error: Some transactions have not been
committed or rolled back in /usr/local/www/mascarado/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php on line 3985 in /usr/local/www/mascarado/vendor/magento/framework/App/ErrorHandler.php:61\nStack trace:\n#0 [internal function]: Magento\\Framework\\App\\ErrorHandler->handler(256, 'Some transactio...', '/usr/
local/www/...', 3985, Array)\n#1 /usr/local/www/mascarado/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(3985): trigger_error('Some transactio...', 256)\
n#2 [internal function]: Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->__destruct()\n#3 {main}\n  thrown in /usr/local/www/mascarado/vendor/magento/framework
/App/ErrorHandler.php on line 61, referer: http://mascarado/setup/

 

Mais informações:

# php -m

	bcmath
	Core
	ctype
	curl
	date
	dom
	fileinfo
	filter
	gd
	hash
	iconv
	intl
	json
	libxml
	mbstring
	mysqlnd
	openssl
	pcre
	PDO
	pdo_mysql
	Phar
	Reflection
	SimpleXML
	soap
	sockets
	SPL
	standard
	timezonedb
	tokenizer
	xml
	xmlwriter
	xsl
	Zend OPcach
	zip

	[Zend Modules]
	Zend OPcache

	 

# mysql --version
mysql  Ver 14.14 Distrib 5.7.33, for FreeBSD12.2 (amd64) using  EditLine wrapper
 

Edited April 9, 2021 by Felipe N. Oliva

[Felipe N. Oliva 0]

Habilitei o log de queries no mysql e repeti alguns comandos sql executados.

2021-04-09T14:29:15.734705Z         9 Query     SHOW DATABASES
2021-04-09T14:29:15.735314Z         9 Query     SELECT PRIVILEGE_TYPE FROM USER_PRIVILEGES WHERE REPLACE(GRANTEE, '\'', '') = current_user()
2021-04-09T14:29:15.735682Z         9 Query     SELECT PRIVILEGE_TYPE FROM SCHEMA_PRIVILEGES WHERE 'magento' LIKE TABLE_SCHEMA AND REPLACE(GRANTEE, '\'', '') = current_us
er()
2021-04-09T14:29:15.736020Z         9 Quit
2021-04-09T14:29:15.749527Z         8 Query     START TRANSACTION
2021-04-09T14:29:15.752766Z         8 Query     SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`eav_attribute`.`attribute_code`='sku') AND (entity_type_id = '4')
2021-04-09T14:29:15.753553Z         8 Query     SELECT `eav_entity_type`.`additional_attribute_table` FROM `eav_entity_type` WHERE (entity_type_id = '4')
2021-04-09T14:29:15.754074Z         8 Query     SELECT `catalog_eav_attribute`.* FROM `catalog_eav_attribute` WHERE (attribute_id = '74')
2021-04-09T14:29:15.766675Z         8 Query     ROLLBACK
 

As tabelas  USER_PRIVILEGES e SCHEMA_PRIVILEGES, não existem.