Mixpost
-
@humptydumpty do them one at a time and i think you can change it back. I will try a build from scratch tomorrow and go thru the docs to update as needed.
-
@humptydumpty i see it - your DB host is wrong: should be DB_HOST=172.18.30.1
everything else looks correct. -
I changed DB_Host to:
- 172.18.30.1
- 172.18.0.1 (this is the LDAP port for me)
- 172.0.0.1 (this was the default in there originally)
Then, I tried those values for the both fields, DB_Host and for REDIS_HOST just in case they both needed to match.
Same step 7 error. I'm going to start again with a fresh LAMP install.
-
I figured it out. I had to cd into the mixpost-pro-team-app folder before doing step 7.
cd /app/data/mixpost-pro-team-app
Line of 1 step 7 went OK. Line 2 with an error. Line 3 went OK.
In Connection.php line 795: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'job_batches' already exists (Connection: mysql, SQL: create table `job_batches` (`id` varchar(255) not null, `name` varchar(255) not null, `to tal_jobs` int not null, `pending_jobs` int not null, `failed_jobs` int not null, `failed_job_ids` longtext not null, `options` mediumtext null, `cancelled_at` int null, `created_at` int not null, `finished_ at` int null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') In Connection.php line 580: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'job_batches' already exists
Step 10: I nano'd into kernel.php and removed the two references of void, but there's no &. I found actual lines of code in there, so I left those untouched and saved.
Step 11: not sure whether to stay in app/code or cd into /data or the mixpost app folder but running step 11's command shows this:
Reading package lists... Done Building dependency tree... Done Reading state information... Done supervisor is already the newest version (4.2.1-1ubuntu1). W: Not using locking for read only lock file /var/lib/dpkg/lock-frontend W: Not using locking for read only lock file /var/lib/dpkg/lock E: Archives directory /var/cache/apt/archives/partial is missing. - Acquire (2: No such file or directory)
Step 12: I encouter an error after running the command
PHP Parse error: syntax error, unexpected token "{" in /app/data/mixpost-pro-team-app/app/Console/Kernel.php on line 14
Going to stop here for now.Changed my mind.I changed the environment from local to production. The app is live on my subdomain, despite all the errors. Woohoo!
What does your kernel.php file look like?
-
@humptydumpty remove the ":" at the end of each function and test
-
It's all green.
I am still getting an error on step 11 when installing supervisor.
Reading package lists... Done Building dependency tree... Done Reading state information... Done supervisor is already the newest version (4.2.1-1ubuntu1). W: Not using locking for read only lock file /var/lib/dpkg/lock-frontend W: Not using locking for read only lock file /var/lib/dpkg/lock E: Archives directory /var/cache/apt/archives/partial is missing. - Acquire (2: No such file or directory)
But the rest of the steps went smoothly. Now to the real questions:
- What does the upgrade process look like?
- Do Cloudron backups work in case things go south?
-
Nice!!! π«‘
You already have Supervisor it so no need to worry
-
Upgrade process look like?: idk yet as this is new to me too, I'd image its close to the install process. Since we are running off of LAMP and Composer - Mixpost plays nicely. So it should not be too cumbersome* (Famous Last Words, lol)
-
Cloudron backups DO cover whatever is in /app/data/.... in the LMAP app so yeah
You wont be the only one going through the process π¦Ύ
-
-
@privsec Ive updated the docs with @humptydumpty's note on CD'ing to the app dir so just follow the current steps you should be good
-
Hi everyone,
Thank you @plusone-nick for your contribution. I'm glad to see that the community has found a solution to install Mixpost in Cloudron.I have a question, why do we have to delete the voids from the Kernel file?
-
@lao9s Hey Dima,
Thanks!
I recall that I was getting some error with Kernel.php, so I was really just shooting in the dark trying things. It could have been resolved via another change I made, and I was confusing the results.Will have to go back and try to reproduce the error. But assuming I broke or bypassed something with the change, what are the implications?
Edit* Any suggestions/edits on the docs are more than welcome =]
-
@plusone-nick Technically, there should be no error in those functions from Kernel.
I think you had some errors elsewhere and thought this was the solution. If you now have Mixpost functional, try to return ":void" and see if everything is fine.
-
@lao9s Everything is still green @humptydumpty make the change too
Docs update β Removed the stepDima, I have a question β What happens when using the same pro/enterprise license on two instances? Does the local/production env var enable any test/dev feature?
-
Using the same pro license in production on two or more instances is not allowed.
Using the same enterprise license in two or more instances is allowed and nothing happens.
The
local
env is used when you want to modify the code, usually, the work is done locally. For example: if you have envlocal
and want to run a migration, it won't ask you if you are sure to migrate or not, it will simply run the command. -
@plusone-nick I tried upgrading to v1 using these steps (the standalone route, not Docker): https://docs.inovector.com/books/mixpost-pro-team/page/upgrading-to-v1
I ran into an error on this step:Run php artisan migrate
APPLICATION IN PRODUCTION. β Are you sure you want to run this command? βββββββββββββββββββ β Yes β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ INFO Running migrations. 2023_08_12_121215_create_job_batches_table ............................................................................................. 15ms FAIL In Connection.php line 795: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'job_batches' already exists (Connection: mysql, SQL: create table `job_batches` (`id` varchar (255) not null, `name` varchar(255) not null, `total_jobs` int not null, `pending_jobs` int not null, `failed_jobs` int not null, `failed_job_ids` longtext n ot null, `options` mediumtext null, `cancelled_at` int null, `created_at` int not null, `finished_at` int null) default character set utf8mb4 collate 'utf8mb 4_unicode_ci') In Connection.php line 580: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'job_batches' already exists
I continued with the other steps regardless of the error. The went well. But the app shows a blank white page. Restoring to a working backup for now.
If this doesn't make you appreciate Cloudron even more, then I don't know what will!
-
@plusone-nick Step 10 isn't necessary at all. I messed up the upgrade so I loaded up a fresh LAMP install and re-did the installation steps without installing supervisor (step 10) and it works fine.
I still encounter an error when I get to
php artisan migrate
during step 7. It's similar/same error I get when upgrading from 0.10.X to v1. The app loads a blank white page if you're upgrading but works fine regardless of the error if it's a fresh installation. At one point, I had Horizon get killed after starting it. I tried so many things that I lost track of what I did, but I couldn't get Mixpost to upgrade successfully.Anyway, I don't remember seeing SMTP stuff in 0.10.X. For v1 in the .env file:
#SMTP MAIL_MAILER=smtp MAIL_HOST=smtp.mailgun.org MAIL_PORT=587 MAIL_USERNAME= MAIL_PASSWORD= MAIL_ENCRYPTION=tls MAIL_FROM_ADDRESS="hello@example.com" MAIL_FROM_NAME="${APP_NAME}"
I guess we need to fill that from the info in
credentials.txt
.