Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. App Wishlist
  3. Mixpost

Mixpost

Scheduled Pinned Locked Moved App Wishlist
164 Posts 15 Posters 39.1k Views 18 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P plusone-nick

    @humptydumpty lol 🫡
    Final update for now: got all services "UP" and "working"
    ef72b891-db15-4ffc-8dd0-d0e3cd532752-image.png

    BUT... - still need to have Horizon/Supervisor Config set as it only stays alive for a little, in that time I was able to push some posts through
    image.png

    Dwindled down from 38 to 7 errors – something regarding: Illuminate & Symfony


    [2023-08-06 22:56:13] production.ERROR: Not enough arguments (missing: "name"). {"exception":"[object] (Symfony\Component\Console\Exception\RuntimeException(code: 0): Not enough arguments (missing: "name"). at /app/data/mixpost-pro-team-app/vendor/symfony/console/Input/Input.php:76)
    [stacktrace]
    #0 /app/data/mixpost-pro-team-app/vendor/symfony/console/Command/Command.php(321): Symfony\Component\Console\Input\Input->validate()
    #1 /app/data/mixpost-pro-team-app/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run()
    #2 /app/data/mixpost-pro-team-app/vendor/symfony/console/Application.php(1081): Illuminate\Console\Command->run()
    #3 /app/data/mixpost-pro-team-app/vendor/symfony/console/Application.php(320): Symfony\Component\Console\Application->doRunCommand()
    #4 /app/data/mixpost-pro-team-app/vendor/symfony/console/Application.php(174): Symfony\Component\Console\Application->doRun()
    #5 /app/data/mixpost-pro-team-app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run()
    #6 /app/data/mixpost-pro-team-app/artisan(37): Illuminate\Foundation\Console\Kernel->handle()
    #7 {main}
    "}

    @girish @lao9s any thoughts or suggestions? 🤓

    girishG Offline
    girishG Offline
    girish
    Staff
    wrote on last edited by
    #47

    @plusone-nick said in Mixpost:

    [2023-08-06 22:56:13] production.ERROR: Not enough arguments (missing: "name"). {"exception":"[object] (Symfony\Component\Console\Exception\RuntimeException(code: 0): Not enough arguments (missing: "name"). at /app/data/mixpost-pro-team-app/vendor/symfony/console/Input/Input.php:76)

    this seems like some CLI is expecting more arguments (specifically --name or something)

    1 Reply Last reply
    1
    • P Offline
      P Offline
      plusone-nick
      wrote on last edited by
      #48

      All errors cleared, and the system has been up for about two days going on three so i think it's safe to say its usable
      image.png
      Still need a workaround for one last step to complete: configure a process monitor Supervisor as it wants to write to /etc/supervisor/conf.d

      Other than that i will document the steps i took and share them here before the end of the week

      ✌💙+1

      1 Reply Last reply
      4
      • P Offline
        P Offline
        plusone-nick
        wrote on last edited by plusone-nick
        #49

        Cloudron + Mixpost + LAMP = +1

        Note: this is for the Pro/Enterprise version of Mixpost

        On a fresh LAMP install open a terminal

        Step 1:

         cd /app/data/
        

        Step 2:

         composer create-project inovector/mixpost-pro-team-app
        

        Step 3: From the File Manager: You can use command line if you like

         Change owner of the mixpost-pro-team-app folder to www-data
        

        Step 4 Enter the mixpost-pro-team-app folder and open .env and Populate:

        APP_URL=https://YOUR-DOMAIN
        APP_ENV=production (WHEN READY)
        APP_DEBUG=fale
        

        Step 5: Populate SQL (creds @: /app/data/credentials.txt)

        DB_HOST=172.18.30.1            /
        DB_PORT=3306                     /
        DB_DATABASE=CLOUDRON_MYSQL_DATABASE
        DB_USERNAME=CLOUDRON_MYSQL_USERNAME
        DB_PASSWORD=CLOUDRON_MYSQL_PASSWORD
        

        NOTE: I had to put the slash / after the two DB_ env vars because the numbers were causing a line bug in the markdown while generating this post so make sure to remove them if you copy and paste the whole code block

        Step 6: Populate REDIS (creds @: /app/data/credentials.txt )

        REDIS_HOST=CLOUDRON_REDIS_HOST
        REDIS_PASSWORD=CLOUDRON_REDIS_PASSWORD
        REDIS_PORT=6379
        

        - Save and Close

        Step 7: Configure Database Tables:

        cd /app/data/mixpost-pro-team-app  
        php artisan queue:batches-table
        php artisan migrate
        php artisan vendor:publish --tag=mixpost-config
        

        Step 8: go to and edit

        /app/data/apache/app.conf
        

        Change both instances of: /app/data/public
        To:

        /app/data/mixpost-pro-team-app/public
        

        - Save and Close

        Step 9: On the CRON tab paste and save below:

        * * * * * cd /app/data/mixpost-pro-team-app && php artisan schedule:run >> /app/data/null 2>&1
        

        Step 10: Install Supervisor:

        sudo apt-get install supervisor
        

        Step 11: Cache Config:

        php artisan config:cache
        

        Step 12: Cache Routes:

        php artisan route:cache
        

        Step 13: Restart the APP to save the config

        Step 14: Go to /app/data/mixpost-pro-team-app/ & Then Start Horizon

        cd /app/data/mixpost-pro-team-app/
        php artisan horizon
        

        Step 15: Go to the landing page and register!

        🦾🤓


        NOTE: i think there is still a need to figure out a solution to configure Supervisor: https://docs.inovector.com/books/server-configuration-mixpost/page/installing-configuring-supervisor

        • Until then manually start the app with php artisan horizon as needed

        • I Only have one license so I had to retrace the steps I took. If there are any errors please forgive me!

        • If anyone runs into issues let me know. I will help troubleshoot and can rebuild my instance as needed =]
          ✌️💖+1

        ✌💙+1

        humptydumptyH 1 Reply Last reply
        6
        • P plusone-nick

          Cloudron + Mixpost + LAMP = +1

          Note: this is for the Pro/Enterprise version of Mixpost

          On a fresh LAMP install open a terminal

          Step 1:

           cd /app/data/
          

          Step 2:

           composer create-project inovector/mixpost-pro-team-app
          

          Step 3: From the File Manager: You can use command line if you like

           Change owner of the mixpost-pro-team-app folder to www-data
          

          Step 4 Enter the mixpost-pro-team-app folder and open .env and Populate:

          APP_URL=https://YOUR-DOMAIN
          APP_ENV=production (WHEN READY)
          APP_DEBUG=fale
          

          Step 5: Populate SQL (creds @: /app/data/credentials.txt)

          DB_HOST=172.18.30.1            /
          DB_PORT=3306                     /
          DB_DATABASE=CLOUDRON_MYSQL_DATABASE
          DB_USERNAME=CLOUDRON_MYSQL_USERNAME
          DB_PASSWORD=CLOUDRON_MYSQL_PASSWORD
          

          NOTE: I had to put the slash / after the two DB_ env vars because the numbers were causing a line bug in the markdown while generating this post so make sure to remove them if you copy and paste the whole code block

          Step 6: Populate REDIS (creds @: /app/data/credentials.txt )

          REDIS_HOST=CLOUDRON_REDIS_HOST
          REDIS_PASSWORD=CLOUDRON_REDIS_PASSWORD
          REDIS_PORT=6379
          

          - Save and Close

          Step 7: Configure Database Tables:

          cd /app/data/mixpost-pro-team-app  
          php artisan queue:batches-table
          php artisan migrate
          php artisan vendor:publish --tag=mixpost-config
          

          Step 8: go to and edit

          /app/data/apache/app.conf
          

          Change both instances of: /app/data/public
          To:

          /app/data/mixpost-pro-team-app/public
          

          - Save and Close

          Step 9: On the CRON tab paste and save below:

          * * * * * cd /app/data/mixpost-pro-team-app && php artisan schedule:run >> /app/data/null 2>&1
          

          Step 10: Install Supervisor:

          sudo apt-get install supervisor
          

          Step 11: Cache Config:

          php artisan config:cache
          

          Step 12: Cache Routes:

          php artisan route:cache
          

          Step 13: Restart the APP to save the config

          Step 14: Go to /app/data/mixpost-pro-team-app/ & Then Start Horizon

          cd /app/data/mixpost-pro-team-app/
          php artisan horizon
          

          Step 15: Go to the landing page and register!

          🦾🤓


          NOTE: i think there is still a need to figure out a solution to configure Supervisor: https://docs.inovector.com/books/server-configuration-mixpost/page/installing-configuring-supervisor

          • Until then manually start the app with php artisan horizon as needed

          • I Only have one license so I had to retrace the steps I took. If there are any errors please forgive me!

          • If anyone runs into issues let me know. I will help troubleshoot and can rebuild my instance as needed =]
            ✌️💖+1

          humptydumptyH Offline
          humptydumptyH Offline
          humptydumpty
          wrote on last edited by
          #50

          @plusone-nick I have a Pro license and haven't been able to try Mixpost yet. I'll give it shot soon and report back. Thank you so much for getting this going!!

          1 Reply Last reply
          2
          • humptydumptyH Offline
            humptydumptyH Offline
            humptydumpty
            wrote on last edited by
            #51

            @plusone-nick Step 7 error: Could not open input file: artisan

            I decided to continue anyway. Step 8 & 9 were easy. Step 10 error: bash: cd: app/Console/: No such file or directory

            This is where I stopped. To backtrack a bit, what exactly do you mean by populate? I might have messed up Step 5 & 6. I tried to use the variables and not the actual values since it's mentioned they change on app restart so, CLOUDRON_MYSQL_DATABASE but that didn't get me through Step 7. Then, I tried the actual values of each field which were located in /app/data/credentials.txt. That didn't help with Step 7 either.

            P 1 Reply Last reply
            0
            • humptydumptyH humptydumpty

              @plusone-nick Step 7 error: Could not open input file: artisan

              I decided to continue anyway. Step 8 & 9 were easy. Step 10 error: bash: cd: app/Console/: No such file or directory

              This is where I stopped. To backtrack a bit, what exactly do you mean by populate? I might have messed up Step 5 & 6. I tried to use the variables and not the actual values since it's mentioned they change on app restart so, CLOUDRON_MYSQL_DATABASE but that didn't get me through Step 7. Then, I tried the actual values of each field which were located in /app/data/credentials.txt. That didn't help with Step 7 either.

              P Offline
              P Offline
              plusone-nick
              wrote on last edited by
              #52

              @humptydumpty you can't use the variables until you set them in the .env file
              so you have to remove the placeholders like "CLOUDRON_MYSQL_DATABASE" and put the value for that variable which is located in /app/data/credentials.txt
              e710262d-3455-4555-ba78-c4a5f994d1ac-image.png
              They are like 16 and 32 characters long

              ✌💙+1

              1 Reply Last reply
              0
              • humptydumptyH Offline
                humptydumptyH Offline
                humptydumpty
                wrote on last edited by humptydumpty
                #53

                OK, I made the changes and this is my .env file:

                image.png

                Still, step 7 with same error.

                1 Reply Last reply
                0
                • humptydumptyH Offline
                  humptydumptyH Offline
                  humptydumpty
                  wrote on last edited by humptydumpty
                  #54

                  I think I'm doing Step 7 wrong. Do you paste all 3 commands together in the terminal or do these go elsewhere?

                  Edit: I'm reading thru Mixpost's docs, and I think I prematurely changed the APP_ENV to production. They have that listed after doing the artisan stuff and when the UI is up. I'll try again tomorrow with a fresh mind. Doing this after work is a horrible idea😵

                  P 1 Reply Last reply
                  1
                  • humptydumptyH humptydumpty

                    I think I'm doing Step 7 wrong. Do you paste all 3 commands together in the terminal or do these go elsewhere?

                    Edit: I'm reading thru Mixpost's docs, and I think I prematurely changed the APP_ENV to production. They have that listed after doing the artisan stuff and when the UI is up. I'll try again tomorrow with a fresh mind. Doing this after work is a horrible idea😵

                    P Offline
                    P Offline
                    plusone-nick
                    wrote on last edited by
                    #55

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

                    ✌💙+1

                    1 Reply Last reply
                    0
                    • P Offline
                      P Offline
                      plusone-nick
                      wrote on last edited by plusone-nick
                      #56

                      @humptydumpty i see it - your DB host is wrong: should be DB_HOST=172.18.30.1
                      everything else looks correct.

                      ✌💙+1

                      1 Reply Last reply
                      0
                      • humptydumptyH Offline
                        humptydumptyH Offline
                        humptydumpty
                        wrote on last edited by
                        #57

                        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.

                        1 Reply Last reply
                        0
                        • humptydumptyH Offline
                          humptydumptyH Offline
                          humptydumpty
                          wrote on last edited by humptydumpty
                          #58

                          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.

                          a9ad4a82-5a14-4152-981c-de3651ea2662-image.png

                          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!

                          1de21275-3010-4909-bc81-f94ba222bc1d-image.png

                          What does your kernel.php file look like?

                          P 1 Reply Last reply
                          1
                          • humptydumptyH 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.

                            a9ad4a82-5a14-4152-981c-de3651ea2662-image.png

                            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!

                            1de21275-3010-4909-bc81-f94ba222bc1d-image.png

                            What does your kernel.php file look like?

                            P Offline
                            P Offline
                            plusone-nick
                            wrote on last edited by
                            #59

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

                            ✌💙+1

                            1 Reply Last reply
                            0
                            • humptydumptyH Offline
                              humptydumptyH Offline
                              humptydumpty
                              wrote on last edited by
                              #60

                              It's all green.

                              image.png

                              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?
                              1 Reply Last reply
                              1
                              • P Offline
                                P Offline
                                plusone-nick
                                wrote on last edited by
                                #61

                                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 🦾🤓

                                ✌💙+1

                                1 Reply Last reply
                                3
                                • P Offline
                                  P Offline
                                  privsec
                                  wrote on last edited by
                                  #62

                                  So is there a final version of docs?

                                  P 1 Reply Last reply
                                  0
                                  • P privsec

                                    So is there a final version of docs?

                                    P Offline
                                    P Offline
                                    plusone-nick
                                    wrote on last edited by
                                    #63

                                    @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

                                    ✌💙+1

                                    1 Reply Last reply
                                    2
                                    • L Offline
                                      L Offline
                                      lao9s
                                      wrote on last edited by
                                      #64

                                      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?

                                      P 1 Reply Last reply
                                      1
                                      • L 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?

                                        P Offline
                                        P Offline
                                        plusone-nick
                                        wrote on last edited by plusone-nick
                                        #65

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

                                        ✌💙+1

                                        1 Reply Last reply
                                        0
                                        • L Offline
                                          L Offline
                                          lao9s
                                          wrote on last edited by
                                          #66

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

                                          P 2 Replies Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Bookmarks
                                          • Search