search

mplx / docker-pixelfed

Pixelfed Federated Image Sharing in an Alpine Docker Container
MIT License
7 stars 3 forks source link

SQLSTATE[HY000] [2002] Connection refused #1

Closed nicobo closed 4 years ago

nicobo commented 4 years ago

I got the gmitirol/alpine311:1.0.0, gmitirol/alpine310-php73:v1 and mplx/docker-pixelfed images built from source in order to run them on a Raspberry Pi 4 (armv7 in my case).

However when I start the docker-pixelfed container I have the following error. Does that mean I need to configure a MySQL server outside of the container ?

me@home:~/docker-pixelfed# docker run -p 8000:8000 -v /var/local/pixelfed:/home/project/pixelfed/storage -it mplx/docker-pixelfed:latest
Pixelfed v0.10.8 entrypoint
Setting timezone to Europe/Berlin
Copy storage template...
Storage...
The [public/storage] directory has been linked.
Database...
[2020-03-26 21:19:03] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = forge and table_name = migrations and table_type = 'BASE TABLE') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = forge and table_name = migrations and table_type = 'BASE TABLE') at /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)
[stacktrace]
#0 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('select * from i...', Array, Object(Closure))
#1 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run('select * from i...', Array, Object(Closure))
#2 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(18): Illuminate\\Database\\Connection->select('select * from i...', Array)
#3 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(169): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#4 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(585): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#5 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(91): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#6 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(63): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#7 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#8 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#9 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#10 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#11 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#12 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#13 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(202): Illuminate\\Container\\Container->call(Array)
#14 /home/project/pixelfed/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#15 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(189): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#16 /home/project/pixelfed/vendor/symfony/console/Application.php(1011): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#17 /home/project/pixelfed/vendor/symfony/console/Application.php(272): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#18 /home/project/pixelfed/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#19 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#20 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#21 /home/project/pixelfed/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#22 {main}

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /home/project/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31)
[stacktrace]
#0 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\\DBAL\\Driver\\PDOConnection->__construct('mysql:host=127....', 'forge', '', Array)
#1 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=127....', 'forge', '', Array)
#2 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=127....', Array, Array)
#3 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)
#4 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()
#5 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))
#6 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(949): Illuminate\\Database\\Connection->getPdo()
#7 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\\Database\\Connection->getReadPdo()
#8 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\\Database\\Connection->getPdoForSelect(true)
#9 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select * from i...', Array)
#10 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('select * from i...', Array, Object(Closure))
#11 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run('select * from i...', Array, Object(Closure))
#12 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(18): Illuminate\\Database\\Connection->select('select * from i...', Array)
#13 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(169): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#14 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(585): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#15 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(91): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#16 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(63): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#17 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#18 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#19 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#20 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#21 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#22 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#23 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(202): Illuminate\\Container\\Container->call(Array)
#24 /home/project/pixelfed/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#25 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(189): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#26 /home/project/pixelfed/vendor/symfony/console/Application.php(1011): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#27 /home/project/pixelfed/vendor/symfony/console/Application.php(272): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#28 /home/project/pixelfed/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#30 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 /home/project/pixelfed/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#32 {main}

[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /home/project/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27)
[stacktrace]
#0 /home/project/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(27): PDO->__construct('mysql:host=127....', 'forge', '', Array)
#1 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\\DBAL\\Driver\\PDOConnection->__construct('mysql:host=127....', 'forge', '', Array)
#2 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\\Database\\Connectors\\Connector->createPdoConnection('mysql:host=127....', 'forge', '', Array)
#3 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\\Database\\Connectors\\Connector->createConnection('mysql:host=127....', Array, Array)
#4 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\\Database\\Connectors\\MySqlConnector->connect(Array)
#5 [internal function]: Illuminate\\Database\\Connectors\\ConnectionFactory->Illuminate\\Database\\Connectors\\{closure}()
#6 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))
#7 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(949): Illuminate\\Database\\Connection->getPdo()
#8 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\\Database\\Connection->getReadPdo()
#9 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\\Database\\Connection->getPdoForSelect(true)
#10 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select * from i...', Array)
#11 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('select * from i...', Array, Object(Closure))
#12 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run('select * from i...', Array, Object(Closure))
#13 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(18): Illuminate\\Database\\Connection->select('select * from i...', Array)
#14 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(169): Illuminate\\Database\\Schema\\MySqlBuilder->hasTable('migrations')
#15 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(585): Illuminate\\Database\\Migrations\\DatabaseMigrationRepository->repositoryExists()
#16 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(91): Illuminate\\Database\\Migrations\\Migrator->repositoryExists()
#17 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(63): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#18 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#19 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#20 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#21 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#22 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#23 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#24 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(202): Illuminate\\Container\\Container->call(Array)
#25 /home/project/pixelfed/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#26 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(189): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#27 /home/project/pixelfed/vendor/symfony/console/Application.php(1011): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#28 /home/project/pixelfed/vendor/symfony/console/Application.php(272): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 /home/project/pixelfed/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#30 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#32 /home/project/pixelfed/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#33 {main}
"} 

In Connection.php line 669:

  SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = forge and table_name = migrations and table_type = 'BASE TABLE')  

In PDOConnection.php line 31:

  SQLSTATE[HY000] [2002] Connection refused  

In PDOConnection.php line 27:

  SQLSTATE[HY000] [2002] Connection refused
mplx commented 4 years ago

Hi Nicolas, thanks for testdriving!

1) ARM: thats a very good point. Usually I'm working x64/amd64 based but I'll see what possible within autobuild on docker hub.

2) gmitirol/alpine: I'm sorry you had the hazzle with rebuilding them for ARMv7. I don't like using the official alpine image as base for my projects as PHP works on one day and is broken the other one (ie. gd, imagemagick, memcached). The gmitirol images provide a stable, fully testet php environment. I'll see whats possible here regarding to ARM. (btw, you mixed up versions, alpine 3.11 base with alpine 3.10 php)

3) MySQL: yep, you're missing mysql. The container just provides nginx (http only) and runs the php stuff but no database. I've quickly added some sample files (however didn't test run them) so you should see how to get things running.

mplx commented 4 years ago

The master image (mplx/docker-pixelfed:master) now supports multiarch (arm32v6, arm32v7, arm64v8) cea6e692fd0bdde2ef32e14d3bc251cbe7151d3e - experimental! I'm not happy with the build process on docker hub. Also the image still is labeled as amd64 (docker image inspect mplx/docker-pixelfed:master | grep Arch) however it's runable (at least on arm32v7).

Maybe you can give it another testdrive?

nicobo commented 4 years ago

Hi, running docker run -d -p 8000:8000 -e 'DB_DATABASE=pixelfed' -e 'DB_USERNAME=auser' -e 'DB_PASSWORD=apassword' --rm --name pixelfed mplx/docker-pixelfed:master the container exists in seconds with :

me@home:~ $ docker logs pixelfed
Pixelfed v0.10.9 entrypoint
/bin/sh: -c requires an argument
nicobo commented 4 years ago

Well this seems to be a connection issue with my local MySQL service ; I'll check that and come back to you

mplx commented 4 years ago 
Pixelfed v0.10.9 entrypoint
/bin/sh: -c requires an argument

Hm, it seems you rush into the run alternate command of entrypoint.sh. It defaults to web so as long as you don't add any alternate commands to the docker run you shouldn't be here.... is the docker run you quoted all your're entering or do you have any commands afterwards? You can also try to append web to your command (docker run .... web).

In your command line I'm also missing redis configuration (while the official docs say it's optional it seems to be mandatory according to https://github.com/pixelfed/docs/issues/7). I'm thinking about adding redis to the base image, however I'm not sure if it's just used for caching or it should be persistent.

For mysql, I'll add some checks on startup to make shure the database is available.

nicobo commented 4 years ago

Anyway thanks for the image because it runs on Raspberry Pi out of the box ! The rest is very probably a configuration issue on my side.

FYI it can now connect to the MySQL server ; it was a wrong network configuration (for now I'm using --net=host until I find the correct way to do it).

I still have an error but I haven't linked it with redis yet (gonna do it) :

Pixelfed v0.10.9 entrypoint
Setting timezone to Europe/Berlin
Copy storage template...
Storage...
The [public/storage] directory has been linked.
Database...
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.06 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (0.04 seconds)
Migrating: 2016_06_01_000001_create_oauth_auth_codes_table
Migrated:  2016_06_01_000001_create_oauth_auth_codes_table (0.06 seconds)
Migrating: 2016_06_01_000002_create_oauth_access_tokens_table
Migrated:  2016_06_01_000002_create_oauth_access_tokens_table (0.07 seconds)
Migrating: 2016_06_01_000003_create_oauth_refresh_tokens_table
Migrated:  2016_06_01_000003_create_oauth_refresh_tokens_table (0.07 seconds)
Migrating: 2016_06_01_000004_create_oauth_clients_table
Migrated:  2016_06_01_000004_create_oauth_clients_table (0.04 seconds)
Migrating: 2016_06_01_000005_create_oauth_personal_access_clients_table
Migrated:  2016_06_01_000005_create_oauth_personal_access_clients_table (0.04 seconds)
Migrating: 2018_04_16_000059_create_sessions_table
Migrated:  2018_04_16_000059_create_sessions_table (0.06 seconds)
Migrating: 2018_04_16_002611_create_profiles_table
Migrated:  2018_04_16_002611_create_profiles_table (0.07 seconds)
Migrating: 2018_04_16_005848_create_statuses_table

In Connection.php line 669:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i  
[2020-04-27 05:08:50] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, `created_at` timestamp null, `updated_at` timestamp null) default cha' at line 1 (SQL: create table `statuses` (`id` bigint unsigned not null auto_increment primary key, `uri` varchar(191) null, `caption` varchar(191) null, `rendered` text null, `profile_id` bigint unsigned null, `in_reply_to_id` bigint unsigned null, `reblog_of_id` bigint unsigned null, `url` varchar(191) null, `is_nsfw` tinyint(1) not null default '0', `visibility` enum('public', 'unlisted', 'private', 'direct') not null default 'public', `reply` tinyint(1) not null default '0', `likes_count` bigint unsigned not null default '0', `reblogs_count` bigint unsigned not null default '0', `language` varchar(191) null, `conversation_id` bigint unsigned null, `local` tinyint(1) not null default '1', `application_id` bigint unsigned null, `in_reply_to_profile_id` bigint unsigned null, `entities` json null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, `created_at` timestamp null, `updated_at` timestamp null) default cha' at line 1 (SQL: create table `statuses` (`id` bigint unsigned not null auto_increment primary key, `uri` varchar(191) null, `caption` varchar(191) null, `rendered` text null, `profile_id` bigint unsigned null, `in_reply_to_id` bigint unsigned null, `reblog_of_id` bigint unsigned null, `url` varchar(191) null, `is_nsfw` tinyint(1) not null default '0', `visibility` enum('public', 'unlisted', 'private', 'direct') not null default 'public', `reply` tinyint(1) not null default '0', `likes_count` bigint unsigned not null default '0', `reblogs_count` bigint unsigned not null default '0', `language` varchar(191) null, `conversation_id` bigint unsigned null, `local` tinyint(1) not null default '1', `application_id` bigint unsigned null, `in_reply_to_profile_id` bigint unsigned null, `entities` json null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') at /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)
[stacktrace]
#0 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('create table `s...', Array, Object(Closure))
#1 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Illuminate\\Database\\Connection->run('create table `s...', Array, Object(Closure))
#2 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(97): Illuminate\\Database\\Connection->statement('create table `s...')
#3 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))
#4 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(167): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))
#5 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\Schema\\Builder->create('statuses', Object(Closure))
#6 /home/project/pixelfed/database/migrations/2018_04_16_005848_create_statuses_table.php(37): Illuminate\\Support\\Facades\\Facade::__callStatic('create', Array)
#7 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(387): CreateStatusesTable->up()
#8 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(396): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#9 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(197): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateStatusesTable), 'up')
#10 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(162): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/project/p...', 1, false)
#11 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(109): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array)
#12 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(71): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array)
#13 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#14 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#15 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#16 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#17 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#18 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#19 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(202): Illuminate\\Container\\Container->call(Array)
#20 /home/project/pixelfed/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#21 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(189): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#22 /home/project/pixelfed/vendor/symfony/console/Application.php(1011): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#23 /home/project/pixelfed/vendor/symfony/console/Application.php(272): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#24 /home/project/pixelfed/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#25 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#26 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#27 /home/project/pixelfed/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#28 {main}

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, `created_at` timestamp null, `updated_at` timestamp null) default cha' at line 1 at /home/project/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63)
[stacktrace]
#0 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(457): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('create table `s...')
#1 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('create table `s...', Array)
#2 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('create table `s...', Array, Object(Closure))
#3 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Illuminate\\Database\\Connection->run('create table `s...', Array, Object(Closure))
#4 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(97): Illuminate\\Database\\Connection->statement('create table `s...')
#5 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))
#6 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(167): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))
#7 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\Schema\\Builder->create('statuses', Object(Closure))
#8 /home/project/pixelfed/database/migrations/2018_04_16_005848_create_statuses_table.php(37): Illuminate\\Support\\Facades\\Facade::__callStatic('create', Array)
#9 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(387): CreateStatusesTable->up()
#10 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(396): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#11 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(197): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateStatusesTable), 'up')
#12 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(162): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/project/p...', 1, false)
#13 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(109): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array)
#14 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(71): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array)
#15 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#16 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#17 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#18 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#19 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#20 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#21 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(202): Illuminate\\Container\\Container->call(Array)
#22 /home/project/pixelfed/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#23 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(189): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#24 /home/project/pixelfed/vendor/symfony/console/Application.php(1011): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#25 /home/project/pixelfed/vendor/symfony/console/Application.php(272): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#26 /home/project/pixelfed/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#27 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#28 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 /home/project/pixelfed/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#30 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, `created_at` timestamp null, `updated_at` timestamp null) default cha' at line 1 at /home/project/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61)
[stacktrace]
#0 /home/project/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(61): PDO->prepare('create table `s...', Array)
#1 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(457): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('create table `s...')
#2 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('create table `s...', Array)
#3 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('create table `s...', Array, Object(Closure))
#4 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Illuminate\\Database\\Connection->run('create table `s...', Array, Object(Closure))
#5 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(97): Illuminate\\Database\\Connection->statement('create table `s...')
#6 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(290): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))
#7 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(167): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))
#8 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Database\\Schema\\Builder->create('statuses', Object(Closure))
#9 /home/project/pixelfed/database/migrations/2018_04_16_005848_create_statuses_table.php(37): Illuminate\\Support\\Facades\\Facade::__callStatic('create', Array)
#10 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(387): CreateStatusesTable->up()
#11 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(396): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#12 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(197): Illuminate\\Database\\Migrations\\Migrator->runMigration(Object(CreateStatusesTable), 'up')
#13 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(162): Illuminate\\Database\\Migrations\\Migrator->runUp('/home/project/p...', 1, false)
#14 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(109): Illuminate\\Database\\Migrations\\Migrator->runPending(Array, Array)
#15 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(71): Illuminate\\Database\\Migrations\\Migrator->run(Array, Array)
#16 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#17 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#18 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Util.php(36): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#19 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#20 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#21 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#22 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(202): Illuminate\\Container\\Container->call(Array)
#23 /home/project/pixelfed/vendor/symfony/console/Command/Command.php(255): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#24 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Command.php(189): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#25 /home/project/pixelfed/vendor/symfony/console/Application.php(1011): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#26 /home/project/pixelfed/vendor/symfony/console/Application.php(272): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#27 /home/project/pixelfed/vendor/symfony/console/Application.php(148): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#28 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#29 /home/project/pixelfed/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#30 /home/project/pixelfed/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#31 {main}
"} 
  n your SQL syntax; check the manual that corresponds to your MariaDB server  
   version for the right syntax to use near 'json null, `created_at` timestam  
  p null, `updated_at` timestamp null) default cha' at line 1 (SQL: create ta  
  ble `statuses` (`id` bigint unsigned not null auto_increment primary key, `  
  uri` varchar(191) null, `caption` varchar(191) null, `rendered` text null,   
  `profile_id` bigint unsigned null, `in_reply_to_id` bigint unsigned null, `  
  reblog_of_id` bigint unsigned null, `url` varchar(191) null, `is_nsfw` tiny  
  int(1) not null default '0', `visibility` enum('public', 'unlisted', 'priva  
  te', 'direct') not null default 'public', `reply` tinyint(1) not null defau  
  lt '0', `likes_count` bigint unsigned not null default '0', `reblogs_count`  
   bigint unsigned not null default '0', `language` varchar(191) null, `conve  
  rsation_id` bigint unsigned null, `local` tinyint(1) not null default '1',   
  `application_id` bigint unsigned null, `in_reply_to_profile_id` bigint unsi  
  gned null, `entities` json null, `created_at` timestamp null, `updated_at`   
  timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')  

In PDOConnection.php line 63:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i  
  n your SQL syntax; check the manual that corresponds to your MariaDB server  
   version for the right syntax to use near 'json null, `created_at` timestam  
  p null, `updated_at` timestamp null) default cha' at line 1                  

In PDOConnection.php line 61:

  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i  
  n your SQL syntax; check the manual that corresponds to your MariaDB server  
   version for the right syntax to use near 'json null, `created_at` timestam  
  p null, `updated_at` timestamp null) default cha' at line 1
mplx commented 4 years ago

Seems like your MariaDB is too old - what version are you using? According to the manual Pixelfed requires MySQL 5.6+ or MariaDB 10.2.7+...

nicobo commented 4 years ago

You're right I was using MariaDB 10.1.x because it's the latest image from linuxserver.io (the one I found working well on Raspbian).

I couldn't find a working docker image for MariaDB 10.2.x in arm32v7 so I switched to PostgresQL.

Unfortunately the php-ext.sh script from Alpine does not have the php modules for PostgresQL but I managed to add it by modifying your Dockerfile and rebuilding it locally.

Here are the modified lines :

apk add --no-cache --update git mysql-client postgresql-client php7-pgsql php7-pdo_pgsql jpegoptim optipng pngquant && \
[...]
php-ext.sh enable 'pdo mysqlnd pdo_mysql pgsql pdo_pgsql' && \

I'm not sure if postgresql-client is required, neither if the pgsql and pdo_pgsql need to be enabled in the php-ext.sh line, since I've the folllowing errors at build :

+ php-ext.sh enable 'bcmath curl exif gd imagick intl fileinfo pcntl'                                                                                                                              
+ php-ext.sh enable 'pdo mysqlnd pdo_mysql pgsql pdo_pgsql'                                                                                                                                        
sed: /etc/php7/conf.d/01_pdo_pgsql.ini                                                                                                                                                             
/etc/php7/conf.d/00_pgsql.ini: No such file or directory                                                                                                                                           
sed: /etc/php7/conf.d/01_pdo_pgsql.ini                                                                                                                                                             
/etc/php7/conf.d/00_pgsql.ini: No such file or directory

but it still works (with the following configuration) :

DB_CONNECTION=pgsql
DB_PORT=5432

and I now have a running pixelfed instance !

mplx commented 4 years ago

Glad it's finally running! :)

The PostgreSQL issue should be OK in the lastest build, I've backported xelan's fix to my multiarch image.

As I consider your MySQL/MariaDB problems as solved I'm closing this issue, if you encounter any other problems please feel free to open a new one.

Casuallynoted commented 4 years ago

I'm currently trying to use this container with a postgres database, but it says "Could not find driver" when the db is changed to postgres from mysql.

fleadope commented 3 years ago

Still getting "Could not find driver" with pgsql...