Cloudron Forum

@micmc Doesn't work unfortunately:

mysql> SET slow_query_log = 'ON';

ERROR 1229 (HY000): Variable 'slow_query_log' is a GLOBAL variable and should be set with SET GLOBAL

...meaning it has to be set as a global variable. Logging a single database isn't possible apparently. The app level user doesn't have access to set global variables:

mysql> SET GLOBAL slow_query_log = 'ON';
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

@girish I tried to modify the variables using this approach but unfortunately MySQL doesn't log anything after doing this. Seems like these variables are overridden at the database level: If I open the 'Variables' section for my app database in Phpmyadmin the logging is disabled.

Is there any way to get root/admin access to the MySQL CLI? I'd like to try this approach: https://ma.ttias.be/mysql-slow-query-log-without-restart/

This approach would be much better because I want to enable logging on a single database, not on all of them.

@girish I'll try it out, thanks!

Any recommendations on how to enable mysql slow query logging?

Before using Cloudron I'd just temporarily elevate the MySQL user's permissions and set the global variables within a SQL query.

Is there any way to:

1. Get root access to temporarily elevate the MySQL user's permissions?
2. Set some variable somewhere? The variables I need to set are slow_query_log, log_queries_not_using_indexes and slow_query_log_file
3. Access the my.cnf?

Thanks!

Maybe one of these? https://phoenixnap.com/blog/docker-container-monitoring-tools

I'll look into Zabbix, thanks for the recommendation

Hi all,
I'd like to have more insight in how every app and service is performing. For example:

• Average response time for each app
• Whether an app is doing too many I/O operations (and/or swapping)
• Whether I should increase RAM on services such as MySQL
• Some API for error logging and reporting of async tasks

Some general dashboard with a notification system would be brilliant.

Any idea how to approach this without having to build it from scratch or using some expensive and overly complex cloud service?

Thanks!

Hi @nebulon, the usecase is that I want my dev environment on a remote VPS so I don't need to worry about backups or my laptop breaking all of a sudden. I need to be able to switch to another laptop with minimal effort.

Up until now I've got this working pretty well on a VPS but keeping it up to date and managing configurations is a pain. Cloudron seems to solve that.

Even though the CLI is very intuitive, the build service seems interesting, I'll look into that, thanks!

@brutalbirdie right, but you're running these commands from your local desktop right? In my case the "local desktop" would be an installed app. In theory the Cloudron CLI tool should work, but the warning in the docs made me doubt.

Hi,
While reading the docs for creating a Custom App I ran into the following warning:

The Cloudron CLI is intended to be installed on your PC/Mac and should NOT be installed on the Cloudron.

Some background regarding the problem I'm trying to solve: I want to create a Custom App based on the Docker image of coder.com. Within this environment I'll be developing applications. After each git push the idea is to do a docker build and docker push. At this point git and the Docker Registry are up to date.

The next step would be to 'push' these changes to Cloudron. To do this I have to execute cloudron push or cloudron update. Would this work considering that I'm working within a Cloudron app? Or would it be more recommended to do this step on a higher level or a different environment?

Does this flow make sense? Apologies if this is a dumb question

@girish it's been solved. I did a docker logout and tried again. Got the error again but this time the error was a bit more detailed. Tried it again and it worked.

Thanks!

Hi,
I'm running into an authentication error while installing Cloudron:

molivier@ubuntu:~/Downloads$ sudo ./cloudron-setup

##############################################
         Cloudron Setup (latest)
##############################################

 Follow setup logs in a second terminal with:
 $ tail -f /var/log/cloudron-setup.log

 Join us at https://forum.cloudron.io for any questions.

=> Updating apt and installing script dependencies
=> Checking version
=> Downloading version 6.1.2 ...
=> Installing base dependencies and downloading docker images (this takes some time) ...Init script failed. See /var/log/cloudron-setup.log for details

Log:

echo -e "\tPulling docker images: ${images}"
        Pulling docker images: cloudron/base:2.0.0@sha256:f9fea80513aa7c92fe2e7bf3978b54c8ac5222f47a9a32a7f8833edf0eb5a4f4 cloudron/turn:1.2.0@sha256:4359aae80050a92bae3be30600fb93ef4dbaec6dc9254bda353c0>
for image in ${images}; do
    docker pull "${image}"
    docker pull "${image%@sha256:*}" # this will tag the image for readability
done
Error response from daemon: unauthorized: authentication required

Seems like the init script runs into an authentication error here, but I can't seem to find out which docker image is throwing authentication errors https://git.cloudron.io/cloudron/box/blob/5a7e636f2d5fee2c3c5bec166e61ab4bcaa41531/baseimage/initializeBaseUbuntuImage.sh#L89

Am I doing something wrong?

Thanks!