membersound's questions

I have 2 mysql updates that cannot be installed on a 20.04:

2 updates could not be installed automatically. For more details,
see /var/log/unattended-upgrades/unattended-upgrades.log

I tried the following:

$ sudo apt install mysql-server-8.0 mysql-client-8.0

The following packages have unmet dependencies:
 mysql-client-8.0 : Depends: mysql-common (>= 5.5)
 mysql-server-8.0 : PreDepends: mysql-common (>= 5.5)
                    Depends: mysql-common (>= 5.8+1.0.4~)


$ sudo apt-get --with-new-pkgs upgrade

The following packages have been kept back:
  mysql-client mysql-server
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.


$ sudo apt list mysql* --installed

mysql-apt-config/now 0.8.16-1 all [installed,local]
mysql-client/now 8.0.22-1ubuntu18.04 amd64 [installed,upgradable to: 8.0.23-0ubuntu0.20.04.1]
mysql-common/now 8.0.22-1ubuntu18.04 amd64 [installed,local]
mysql-community-client-core/now 8.0.22-1ubuntu18.04 amd64 [installed,local]
mysql-community-client-plugins/now 8.0.22-1ubuntu18.04 amd64 [installed,local]
mysql-community-client/now 8.0.22-1ubuntu18.04 amd64 [installed,local]
mysql-community-server-core/now 8.0.22-1ubuntu18.04 amd64 [installed,local]
mysql-community-server/now 8.0.22-1ubuntu18.04 amd64 [installed,local]
mysql-server/now 8.0.22-1ubuntu18.04 amd64 [installed,upgradable to: 8.0.23-0ubuntu0.20.04.1]

How can I resolve them?

I have a server with an alias as follows:

~/.bash_aliases 
alias update='sudo apt update && sudo apt -y upgrade'

Now I want to create a shortcut from my desktop that can simply trigger this script remotely over sshpass: For a simple login, it works as follows:

sshpass -p "<password>" ssh <user>@<host>

But adding the alias as ssh command does not work and simply closes the terminal without action:

sshpass -p "<password>" ssh <user>@<host> 'update'

Question: is it possible at all?

I have several .desktop entries that launch the terminal as follows:

[Desktop Entry]
Version=1.0
Name=<the name>
Type=Application
Exec=gnome-terminal <commands>

Problem: when I click on them from the desktop view, they are executed as expected. BUT when I'm in nautilus in the Desktop folder, they are only opened as editor file.

Question: how can I force nautilus to execute them, just like on the desktop view?

Is there any working utility that can simulate mouse movements on a ubuntu?

Important: I only want that utility to control the mouse if the machine is idle for X minutes.

Of course I could use xdotool to simulate some movement, but how would I detect if the pc is idle for x minutes? I could not find any working tool for linux...

I would like to install the following package on an ubuntu 18.04: https://launchpad.net/ubuntu/+source/yate/5.4.0-1-1ubuntu2 yate-qt4.

I have an existing ubuntu installation that I once upgraded from 16.x, and there the yate client was just kept.

Now I'm reinstalling 18.04 directly, and cannot find a way to force installation of the yate client again.

If I downloaded the *.tar.gz from the url, what would I have to do with it in order to install yate?

I'm on Ubuntu 18.04 with default-java -> java-1.11.0-openjdk-amd64/. java -version shows:

OpenJDK 64-Bit Server VM (build 10.0.2+13-Ubuntu-1ubuntu0.18.04.3, mixed mode)

I already did an apt upgrade and apt-upgrade, but the java version is still 10.

How can I safely upgrade my Java installation to JDK 11 GA? If I have to add a repository, which one should I use? Do I have to uninstall the existing JDK first?

How can I then make the new Java version the default-java?

I'm running 18.04 LTS and would like to upgrade my i7 Intel HD Graphics Kaby Lake driver.

I found that in general the following sources should be used: https://01.org/linuxgraphics/downloads/2018q1-intel-graphics-stack-recipe

But: There is no guideline.

• Which of those files presented do I have to download, and how to install them?
• Only the kernel?
• What about the Xserver?

I upgraded 16.04 to 18.04 LTS. How can I re-enable sticky edges in the new gnome? I cannot find anything in settings or tweak configuration...

Where can I find the defaults for lftp? Eg net:max-retries and net:timeout.

I'm asking because I get some **** Data socket error (Connection timed out) - reconnecting message in my lftp debug log. And it seems to retry forever if I don't quit the process manually. Which is bad for cron jobs.

Questions:

How could I explicit set the timeout and retries for one special script, which is as follows:

lftp -c "
open $HOST
user $USER $PASS
lcd $SOURCEFOLDER
mirror --delete --verbose $FSOURCE $FTARGET
exit
"

And how could I catch any sync errors in the batch file above, so that I could eg send an email notification on max timeouts?

I'm connected to a LAN, and want to provide a hotspot for a mobile phone. Further, all the phones content should be served through a ssh socks5 tunnel, which is running with:

sshpass -p <pass> ssh -Nf -D 8090 [email protected]

Questin: what could I do now to route all hotspot wlan traffic directly to port 8090 of the ssh socket?

I tried the solution here: How to share WiFi/hotspot over SSH tunnel

BUT: when trying to add the iptables commands, nothing happens. No iptable routes are added at all. Any solution would be fine. Also installing additional tools.

test.sh: /usr/bin/notify-send "test"

The following works: bash ~/Documents/test.sh

BUT the crontab never shows the notification. Why?

*/1 * * * * bash ~/Documents/test.sh

I'm reading the last line of a file into a variable. Then I want to get the last X characters of the string variable:

#!/bin/bash
someline="this is the last line content"
echo ${someline}
somepart=${someline: -5}
echo ${somepart}

Run with: sh lastchars.sh

Result:

this is the last line content
line 4: Bad substitution

What might be wrong here?

Given a parameter $1, I want to subtract 5 minutes from that time, and echo it (later reuse the variable).

echo $1
time5=date -d "$1 5 minutes ago" +'%H:%M'
echo ${time5}

Call with: ./script.sh 16:55

Result:

prints 16:50

./script.sh: line 2: -d: command not found

Why can't I assign the date to the variable time5?

I want to grep a specific status of a service (tomcat8.service).

Only if the string was found, I want to execute some logic.

Problem: even if I execute the script on service name that does not exist ("asd" in this example), the if $status still matches and prints out. But why?

status = $(systemctl status asd.service | grep 'active')
echo $status

if $status
then 
    echo "$SERVICE was active"
    exit 0
fi 
exit 0

Result output is: asd.service was active, which is certainly not true.

The echo $status prints: status: Unknown job: =

I have a tomcat server that generates access logfiles on a daily rotation.

To clean them up every X days, I tried configuring the following crontab -e:

@weekly find /var/log/tomcat8/localhost_access_log.*.txt -mtime +10 -delete

Problem: I'm getting a Permission denied error running this. Because the /var/log/tomcat8 folder has tomcat:tomcat user:group permissions, and I'm logged in as a different one.

So, how could I best create a cronjob that has permissions to delete those files?

Or should I just add the crontab via sudo crontab -e?

I want to sync an ftp directory with lftp, and run a jar file afterwards, but only if any files have been changed.

For testing, I just tried to execute another bash file after sync has finished, but it does not work:

lftp.sh:

lftp -f "
open $HOST
user $USER $PASS
lcd $SOURCEFOLDER
mirror --delete --verbose --on-change=test.sh $SOURCEFOLDER $TARGETFOLDER
bye
"

test.sh:

echo test ok

Result:

Unknown command `test.sh'.

Why, and how can I improve this? Absolute path also fails!

If not possible, how can I catch some kind of status code on exit to determine if there was a change on sync, and execute a command in case?

As well it would be fine if I could just get the number of new files transfered.

I have a bash script that runs periodically once a day using crontab.

The script checks a condition, and if true, it should issue an at command at a specific time.

at 14:10 <notify-send hello>

The question is: how can I add a specific command like notify-send to the at command?

I want to run a shell script that copies a file. I don't like to make absolute reference to that file.

myproject/target/myapp.jar
myproject/docs/copy.sh

copy.sh contains: scp ~/Projects/myproject/target/myapp.jar user@myip:/var/www

Question: how can I run the copy.sh shell script and reference the myapp.jar relative? Like first walking up one folder, and then going into /target?

I'm running a java tool as a command line app using cronjob: java -jar /var/java/-myfile.jar

By default I'm using logback and write to /var/log/mylogfile.log.

Problem: the user running the jar has no permissions to write to the /var/log/ folder. That folder has only permissions to `root syslog'.

Question: should I run the jar as sudo? Or should I give the running user write permissions to that folder? If yes, how?

How could I best write a hotkey script that opens an url in the webbrowser (firefox)?

Example:

ALT+G = www.google.de
ALT+W = www.wikipedia.de

Or would I have to use some kind of existing software therefore?