Mixpost

[humptydumpty]

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.

[humptydumpty]

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?

[plusone-nick]

@humptydumpty remove the ":" at the end of each function and test

[humptydumpty]

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?

[plusone-nick]

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]

So is there a final version of docs?

[plusone-nick]

@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

[lao9s]

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?

[plusone-nick]

@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 =]

[lao9s]

@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.

[plusone-nick]

@lao9s 🫡roger

[plusone-nick]

@lao9s Everything is still green @humptydumpty make the change too
Docs update – Removed the step

Dima, 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?

[lao9s]

@plusone-nick

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 env local 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.

[privsec]

I have skimmed the docs and tried to find this answer, but haven’t.

@lao9s Can you create some sort of chart of what specially can be done on each platform?

Something similar to https://buffer.com/pricing

[privsec]

The reason why is I’d love to buy the early supporter enterprise license, but if certain features are not even planned to be done, then it wouldn’t be useful for some of my clients.

[humptydumpty]

@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!

[humptydumpty]

@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.

[robi]

Making a script do the install repeatably might be a good idea.

[privsec]

@robi said in Mixpost:

Making a script do the install repeatably might be a good idea.

Would this just uninstall, then reinstall using the same subdomain name?

[robi]

@privsec not sure I follow you.. the install script would just automate your steps on new installs.