user9371654's questions

I have very long queries text (~50 lines). Recently MySQL workbecnh is exhibiting strange behavior. While editing the query (I open it, I edit one character and want to continue to the next), it freezes forever.

I suspect it can be something related to memory? I see in the preferences there is a default value for maximum query length to store in history in bytes with this default value: 65536. Is this relevant? What do you suggest?

My device is running Ubuntu 18.04 and the workbench is verion 8.0 which is the latest. I cleaned the temp files using: clean and autoclean commands but no hope.

Please help me how to overcome this problem. Knowing that I do not face it when I edit the query in a text editor. Just when I am using the workbench editor. But it is not practical to use external editor.

I also tried to reboot and shut down my device and open the database connection again.

If you need the log, please specify the step to get it for you.

In Ubuntu 18.04, how can I give a user x a full access (read/write/execute) to a directory and all its content?

I am trying to open a .movie file in Ubuntu 18.04. When I double click I get a message saying Could not display [filename].movie.

Can you please point me to some applications to install that will open .movie files?

When I connect my external hard disk to my Ubuntu device and delete some files and folders from it, they are not actually deleted as they still preserve space but I do not see them.

However, when I connect the hard disk to a Windows machine, I see a folder .Trash-1000 contains some files and folders, and when I delete them from there, I get the space freed.

1) How can I delete my files and folders from the external hard disk to the rubbish bin and free their space in Ubuntu?

2) How can I see the .Trash-1000 folder in the external hard disk from my Ubuntu machine?

I use MySQL workbench 6.3 on Ubunut 18 using MySQL server 8+. I need to backup my database from the workbench. When I click on Data export I select the scheme and make sure all the tables needed are checked. I choose the file path where I want to export the backup (external hard drive). I click export but I get error saying:

Could not get mysqldump version Workbench was unable to get mysqldump version. Please verify the log for more information

Please note that I first get warning syaing the existing data will be overwritten (I deleted old backup but I am saving the new one under same name). Although the old files are not there, I click ok. But still the backup does not work in both types (self-contained sql file or dump project files).

How to solve the issue?

This post have similar problem. It suggest going to Edit -> Preferences -> Administration and to change the path to mysqldump tool to where mysqldump is. I tried to change it to both: /usr/bin/mysqldump /usr/lib/mysql-workbench/mysqldump

After each change, I close and open the MySQL workbench. Nothing solve the issue.

Note, this is the result for locating mysqldump.

$ locate mysqldump
/etc/mysql/conf.d/mysqldump.cnf
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/lib/mysql-workbench/mysqldump
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz

Please note that the export worked with me yesterday. I did not change anything apart from shutting down my device and start it.

Please note that I also upgraded both MySQL workbench and MySQL server. I did not remove the old MySQL server but when I check the version using: SHOW VARIABLES LIKE "%version%"; It see the new version: 8.0.15

Here is the MySQL workbench paths I see:

Also, when I go to /usr/bin/ and execute: mysqldump --version I get:

mysqldump: [Warning] unknown variable 'loose-local-infile=1'.
mysqldump  Ver 8.0.15 for Linux on x86_64 (MySQL Community Server - GPL)

Finally, the loose-local-infile=1 is an entry I entered in /etc/mysql/my.cnf to be able to load data from local files into my database.

Please, help me solve my problem. I need to backup my databases to do some changes.

I upgraded both MySQL work-bench to version 8.0 and MySQL server to version 8.0.15. I restarted my computer and I opened the workbench. I found my old connection. When I click test connection I get successful result.

When I double click on my connection I get this error message.

I tried to login to the MySQL server using and reset the password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Please, what could be the problem?
I forgot what was the port number when I set up the connection in the old... version.

EDIT:

In the terminal, this is an attempt and it seems working. Just the workbench which I used to work from. Note that I use Ubunut 18.04:

$ mysql -u root -p -h 127.0.0.1 -P 3306
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 8.0.15 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

I installed hplip and hplip-data. Then I started HPLIP Toolbox GUI. I click add printer and then I get a message (see pic) that PPD file is not found. When I click browse I find some .gz file and none of them solve the issue if selected.

Then

My Ubuntu is Ubuntu 18.04

The output of apt-cache policy hplip hplip-gui:

hplip:
  Installed: 3.17.10+repack0-5
  Candidate: 3.17.10+repack0-5
  Version table:
 *** 3.17.10+repack0-5 500
        500 http://us.archive.ubuntu.com/ubuntu bionic/main amd64 Packages
        100 /var/lib/dpkg/status
hplip-gui:
  Installed: 3.17.10+repack0-5
  Candidate: 3.17.10+repack0-5
  Version table:
 *** 3.17.10+repack0-5 500
        500 http://us.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages
        500 http://us.archive.ubuntu.com/ubuntu bionic/universe i386 Packages
        100 /var/lib/dpkg/status

Following this post, I did:

1. sudo apt-get install hplip-gui
2. hp-setup

I get a GUI for HP Device Manager. My printer is connected by USB. So I select USB then Next. Then I move to another page with title Select from Discovered Device, which shows my printer listed. I click on my printer and Next. Then I get this in the terminal.

HP Linux Imaging and Printing System (ver. 3.17.10)
Printer/Fax Setup Utility ver. 9.0

Copyright (c) 2001-15 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.

Searching... (bus=usb, search=(None), desc=0)
error: No PPD found for model deskjet_2540 using old algorithm.
error: No appropriate print PPD file found for model deskjet_2540_series

I need to install a network printer. I use Ubuntu 18.04. I typed:

$ sudo system-config-printer

But I got:

sudo: system-config-printer: command not found

How can I bring the printer configuration GUI? I want to add a printer using the GUI.

I use Ubuntu 18.04. It was shipped with OpenSSL 1.1.0g . I tried to link manually compiled Python to a manually compiled OpenSSL1.1.1a but things does not seem to work well. When I now run Python it is automatically linked to OpenSSL1.1.1a. I want to revert this. I want to restore OpenSSL1.1.0g as the default library for my system and my system's installed python. When I check my system's OpenSSL version I get:

OpenSSL 1.1.0g  2 Nov 2017 (Library: OpenSSL 1.1.1a  20 Nov 2018)

When I check:

whereis openssl

I get:

openssl: /usr/bin/openssl /usr/include/openssl /usr/local/openssl /usr/local/openssl/bin/openssl /usr/share/man/man1/openssl.1ssl.gz

How can I remove OpenSSL 1.1.1a and just leave the system's OpenSSL 1.1.0g? How can I make Python linked to OpenSSL 1.1.0g? Any Python is linked to OpenSSL 1.1.1a now.

EDIT:

The command I used to compile python and openssl is similar to (except different versions):

# new openssl install
curl https://www.openssl.org/source/openssl-1.0.2g.tar.gz | tar xz && cd openssl-1.0.2g && ./config shared --prefix=/usr/local/ && make && make install

# Python install script
export LDFLAGS="-L/usr/local/lib/"
export LD_LIBRARY_PATH="/usr/local/lib/"
export CPPFLAGS="-I/usr/local/include -I/usr/local/include/openssl"
apt-get update
apt-get install build-essential checkinstall -y
apt-get install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev -y
cd /home/web/
wget https://www.python.org/ftp/python/2.7.11/Python-2.7.11.tgz | tar xzf Python-2.7.11.tgz && cd Python-2.7.11 
./configure --prefix=/usr/local/ 
make altinstall

I use Ubuntu 18.04. When I close my laptop, and open it again, I find all my previously opened programs are lost. My Power configurations has "Off" in the "Automatic Suspend". Also, in "When the Power Button is pressed" I have "Off". But closing the laptop is not pressing the power button.

The lid close action seems to already be set to "suspend":

$ gsettings get org.gnome.settings-daemon.plugins.power lid-close-ac-action
'suspend'

This is very annoying. I want to close my laptop (i.e., closed the screen. This is different from pressing the power button) and find all my previously opened programs.

I am running a network related program that performs TLS handshakes with many hosts. I ant to monitor the network traffic so I used nethogs. It shows 0 KB.

NetHogs version 0.8.5-2

PID USER     PROGRAM                    DEV        SENT      RECEIVED       
  ? root     unknown TCP                            0.000       0.000 KB/sec

  TOTAL                                                 0.000       0.000 KB/sec

I have previously run this program and nethogs was showing me information about the network traffic. What is the problem? How to see the ongoing/outgoing traffic? Are there alternative tools?

I use Ubuntu 18.04. The command I entered:

sudo nethogs

I also tried with the adapter name that I obtain using ifconfig:

sudo nethogs enx9cebe8b0d86a

I want to get a log of the updates I installed in my Ubuntu 18.04 recently (say last month) using apt-get upgrade and apt-get update. Is there any way?

I am having a disaster. My Ubuntu can not boot. The problem is summarised here

I read about Ubunut recovery mode. I followed these instructions. I selected Drop to root shell promot. I got a shell in the bottom. It has the followign text:

Press Enter for maintenance
(or press Contol-D to continue):
root@mypc-name:~#

There is a cursos blinking. When I type pwd it prints: /root

I need to recover my data to an external hard disk. Please help me in a step by step. I use Ubuntu in GUI. I use the terminal but I have no experience in mounting and working with hard disks and moving data using the shell.

Please note that I have 0 Bytes available in my hard disk.

I am facing serious issue. My hard disk was extremely full that 0 bytes available. I tried to empty the trash bin but it hanged. I restarted the system. But it failed. It gives this messages:

[FAILED] Failed to start MySQL Community Server.
Seee 'systemctl status mysql.service' for details.

The cursors is blinking but I can't type anything.

Is there any hope that I boot the system under sort of last known good configurations or safe mode like in Windows?

I made hardware test and the device is healthy. Please help me disable MySQL or boot my system I just need my data because lots of work there.

EDIT:

The device company can not help with data backup. They can only format and install the system. I need my data.

I have the latest version of google chrome. I need to test an issue in an older version. How to install the old version? and this also requires disabling the auto-updates.

I installed chromium using:

sudo apt-get install chromium-browser

Then I want to completely remove it. I used:

sudo apt-get remove chromium --purge
rm -rf ~/.config/chromium
rm -rf ~/.cache/chromium
sudo rm -rf /etc/chromium

But it is still there. If I click Activities and type Chrom.. I see Chromium. And when I click it it open the Chromium browser. I do not want to see it in my computer. How to remove it.

When I try to run atom or sudo atom, I get this error:

Gtk-Message: 16:51:25.304: Failed to load module "canberra-gtk-module

I looked at similar posts, and they suggest installing:

sudo apt-get install libcanberra-gtk-module
sudo apt-get install libcanberra-gtk-module:i386

Even after installing them, the problem still appear.

I tried to install atom by:

sudo apt-get insatall atom

I am getting:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
atom is already the newest version (1.26.1-1~webupd8~0).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

I also tried: wget -O atom-amd64.deb https://atom.io/download/deb

But there seem to be a problem.

--2018-09-28 17:08:21--  https://atom.io/download/deb
Resolving atom.io (atom.io)... 34.231.150.116, 34.232.181.106, 34.235.97.255, ...
Connecting to atom.io (atom.io)|34.231.150.116|:443... connected.
ERROR: cannot verify atom.io's certificate, issued by ‘CN=DigiCert SHA2 High Assurance Server CA,OU=www.digicert.com,O=DigiCert Inc,C=US’:
  Unable to locally verify the issuer's authority.
To connect to atom.io insecurely, use `--no-check-certificate'.

I do not want to use --no-check-certificate because I need authentication of the website and this is not achieved without a certificate.

I have some installation instructions but they use pathmunge which caused me an error in Ubuntu. What is the equivalent syntax to the following script to do the same in Ubuntu?

/etc/profile.d/openssl.sh
pathmunge /usr/local/openssl/bin

I did add pathmunge command to Ubuntu using this answer:

run nano ~/.bashrc && source ~/.bashrc and paste this:

pathmunge () {
        if ! echo $PATH | /bin/egrep -q "(^|:)$1($|:)" ; then
           if [ "$2" = "after" ] ; then
              PATH=$PATH:$1
           else
              PATH=$1:$PATH
           fi
        fi
}

When I login, I get this error:

When I click ctrl+alt+del I wan to lock my computer (not log off). I can not find the lock option, only log out and it says

[user] will be logged out automatically in 60 seconds

How to enable lock screen in ubuntu 18 and disable auto log out?

I have Ubuntu 16.04. It has OpenSSL 1.0.2g. I need to use OpenSSL 1.1.0g. I did:

sudo apt-get upgrade
sudo apt-get update

But OpenSSL in my Ubuntu machine did not get updated. How can I update it?

I use python socket, ssl modules to make TLS connection in port 443. Will python automatically recognizes OpenSSL 1.1.0g if I updated the old OpenSSL 1.0.2g to OpenSSL 1.1.0g?

The reason for upgrading OpenSSL is I need to run python program ssl socket but I need the program to use OpenSSL 1.1.0g. How to ensure that?