Cloudron Forum

I'd love to see an open-source password manager on Cloudron. There's already a post about BitWarden, so I'll through out Buttercup as another option. It features cross-platform compatibility with macOS, Windows, and Linux. It also has apps for both Android and IOS. In addition, it includes browser extensions for Chrome and Firefox with more on the way.

@girish Went ahead and tried it and it works beautifully! Took a matter of seconds for it to load all my feeds. Really appreciate y'all's work on this. I'm becoming a bigger Cloudron fan by the minute

@girish Awesome. Thanks! I'll check it out tomorrow.

Hi,

I've been in communication with the FreshRSS devs about not being able to sync my feeds with the FeedMe app on my Android devices. I've had one of them check out my installation. Here's the dev's response:

"""""Dev Response BEGIN"""""
I have tested your server manually, and it looks like there is a configuration problem with nginx, which does not pass the HTTP Authorization header to PHP. Could you please post your nginx configuration and/or compare it with https://freshrss.github.io/FreshRSS/en/admins/02_Installation.html ?

Please also post the most recent entries (i.e. the bottom) of ./FreshRSS/data/users/_/log_api.txt*
"""""Dev Response END"""""
I have attempted to download the log_api.txt file, but whenever I try do so I get a file does not exist error; however, I can download other files in that same directory just fine. Is there something preventing me from being able to download the log_api.txt file?

Also, I'm not sure what to do about the nginx issue. Is there a way I can get a hold of a configuration log for that or is that not possible for a Clourdon hosted app?

You can follow the issue I created on GitHub to get the full context of everything if you'd like. It can be found HERE.

Thanks for keeping us posted, @girish . Will just have to wait for Wallabag 3.4!

@girish I have Wallabag installed, so that explains it. Thanks.

@girish How do I update to 3.3? I login to Cloudron and go to Setting and click 'Check for Updates' and nothing happens...? I'm still running 3.2.3 as seen below:

@girish Wow! I got it to work. What a pain Google made that process. I ended up having to disable 2FA, go in to my G-Suite management console and enable less secure apps options for users, then go to my admin console for my actual email account and enable less secure apps there, then enable 2FA, then create an app password. Finally, it accepted my credentials in the Cloudron Email setting. I sent a test email in InvoiceNinja and it appears to be working.

Alright. Any ideas on how to get Google Maps working in InvoiceNinja? When I got to a client page, it appears a map attempts to load and then just altogether disappears. Do I need to add API information?

@girish Okay. I am actually getting an error there as well. I initially tried my username with my normal password, and it said 'application password required,' which wasn't unexpected. I then created an application password, and now it says 'username and password not accepted.'

Re: Importing SQL Database for InvoiceNinja

@girish Good news about the memory. I'll adjust it back after I'm done getting everything set up.

I noticed after viewing the ENV file an API_Secret already existed. I guess one is created automatically? I initially edited the ENV file to overwrite the include one with my old API_Secret thinking it would save me from having to type in that rather long string of characters on my phone. However, this didn't seem to work no matter what I tried. I eventually went back to the API_Secret that was included by default and everything works. Not sure why I couldn't use my own, but it works.

The only thing I need to get setup now is email relay. I've made several attempts, but so far no luck. I am using a Google Business account (G-Suite) for my email and have set up the appropriate MX records on my DigitalOcean account. Everything works as I am sending/receiving emails from BlueMail on my phone and also Mailbird and Thunderbird. However, I can't get it to work in InvoiceNinja. I found a tutorial on the InvoiceNinja with the following instructions:

""""
Enable SMTP Access

Log in to your Google Apps for Business admin console.
Go to Apps –> Google Apps –> G-Mail –> Advanced Settings then scroll down until you see SMTP relay service, however over it and click on Configure.
Select Only addresses in my domains then tick Require SMTP Authentication and Require TLS encryption and click on Add Setting then click Save.
Configure .env which is located in the root of your Invoice Ninja installation.

MAIL_DRIVER=smtp
MAIL_PORT=587
MAIL_ENCRYPTION=tls
MAIL_HOST=smtp-relay.gmail.com
MAIL_USERNAME=username@yourdomain.com
MAIL_FROM_NAME=username@yourdomain.com
MAIL_PASSWORD=yourpassword

It also mentions enabling 'less secure apps' in my account security settings, but I have 2FA enabled so this isn't available. I instead created an APP password and tried to use it. So far I'm just getting this error message when I click the 'test email' button in InvoiceNinja
""""

 Expected response code 250 but got code "535", with message "535-5.7.8 Username and Password not accepted. Learn more at 535 5.7.8 https://support.google.com/mail/?p=BadCredentials k78sm1762576qkh.13 - gsmtp "

One other thing. My google maps aren't working in InvoiceNinja. Do I need to include an API reference in the ENV file? I know I did on A2 Hosting, but noticed there is a Google_Maps = True (or something similar) already in my ENV file.

I think I will need to edit the .env file as I need to include a Shared Secret so that my Android app can communicate with the server. I'm going to give a go to see if I can figure it out first.

@girish That did the trick! Thanks for all your help. Looks like I need to go purchase some additional memory on DigitalOcean

@girish said in Importing SQL Database for InvoiceNinja:

mysqldump --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST} --add-drop-table --no-data ${MYSQL_DATABASE} | grep -e '^DROP | FOREIGN_KEY_CHECKS' | mysql --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST} ${MYSQL_DATABASE}

The command runs successfully, it appears. I then run the other command afterwards. Now, however, I'm not getting any output. Does it take a while for the command to complete? My file is only 3MB, so I wouldn't think so.

Here's a pic from the terminal:

I'm getting the following error (on a brand new install),

Error 1050 (42s01) at line 31: Table 'accounts' already exists

Not sure exactly what this is referring to, but I haven't created any accounts as of yet.

@girish Thanks! I was close. I had uploaded my dump file to the /tmp file and was fiddling around with the mySQL button. I'll try your suggestions.

And thanks for the tip on the .env file.

I'll give this a shot now.

I'm transitioning from A2 Hosting to Cloudron. I've been using InvoiceNinja for a couple of years now. I performed a mySQL dump on my A2 account, but am unsure how to import to my Cloudron install of InvoiceNinja. Since I didn't assign a password to the database during the install, I have no idea what the password is. I'd also prefer to rename the database to something more readable, but am unsure how to do this. Any help will be much appreciated. (Note: I think I will also need to transfer my .env file as well...)

@ctrl I agree. This is the one app that Cloudron doesn't have that I'd like to use. Bookstack would also be nice. Hope they add them both soon!