The issue is that Docker images are stripped down, so many tools and even python3 is missing, so you'll have to build or update the actual image yourself. I assume you have started an image with something like this and that you have the Nvidia Toolkit installed (assuming you are using GPUs). If you're not using nvidia just remove --runtime=nvidia --gpus all. docker run -it --runtime=nvidia --gpus all ubuntu bash These works for most images li........

It may appear to be an Xorg or lightdm/gdm/mdm error but in reality for many users with this issue, it's a driver conflict and issue. I had a system that had two GPUs, an Intel and Nvidia GPU. The only thing that got it working was to remove the nouveau driver and blacklist it so it never came back, then the Intel GPU works fine without these issues. Solution sudo rmmod nouveau add nouveau/other driver to blacklist edit th........

apt install software-properties-common add-apt-repository ppa:deadsnakes/ppa apt update apt install python3-pip apt install python3.7 curl gnupg python3.7-dev git ln -s /usr/bin/python3.7 /usr/bin/python3 pip3 install numpy keras_preprocessing curl https://bazel.build/bazel-release.pub.gpg | sudo apt-key add - echo "deb [arch=amd64] http://storage.googleapis.com/bazel-apt stable jdk1.8" | sudo tee /etc/apt/sources.list.d/bazel........

yum -y install wget unzip wget https://download.nextcloud.com/server/releases/nextcloud-18.0.2.zip unzip nextcloud-18.0.2.zip yum -y install php php-mysqlnd php-json php-zip php-dom php-xml php-libxml php-mbstring php-gd mysql mysql-server Last metadata expiration check: 0:58:02 ago on Fri 13 Mar 2020 02:12:49 PM EDT. Dependencies resolved. ===================================================================........

This is sure simple if you follow the guide but it took a lot of hacking around to make this work on Debian/Ubuntu! Now before you ask why bother running wine and python, the reason is because Python executables are NOT cross-platform. If you run pyinstaller in Linux, that binary will only run on Linux and the same if you do it in Windows. So it is preferable if you have a single environment that you can create Linux and Windows binaries from rather than running 2 separate........

MySQL on Debian versions is configured differently than the native local MySQL plugin so you will be disappointed when your password on the mysql client fails by default. Here is how you reset the MySQL root password the proper and "working way" #first we gracefully stop mysql sudo systemctl stop mysql; #then we forcefully kill any mysqld process just in case sudo killall -9 mysqld mysqld_safe;........

mysql reset root password. Oops I can't remember my MySQL root password! [root@centos7test etc]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) First we need to stop mariadb: systemctl stop mariadb Now we need to restart it with skip-grant-tables whic........

Most of us know the heredoc method but what if you need a basic query done repeatedly and manually while working from bash? It is a pain to manually type mysql and login each time. With this command below you can semi-automate those queries: echo "use somedb; select * from auctions" | mysql -u root --password="yourpassword" Just modify the above to suit your needs and you can add more queries by adding a sem........

Create Database: create database yourdbname; Show All Databases: show databases; Change Database: use mysql; Drop / Delete a MySQL Database: drop database nameofyourdatabase;........

By default bind will not respond to outside queries for security reasons. In most distributions you will find the default in /etc/named.conf looks like this at the top under options: listen-on port 53 { 127.0.0.1; }; listen-on-v6 port 53 { ::1; }; directory "/var/named";........

Opening Firefox from the CLI reveals the following as the cause of the error: Query failed: Error: Error(s) encountered during statement execution: no such table: moz_favicons The symptoms of this issue are that in the address bar you cannot hit enter to browse to a site/url/address and your history cannot be accessed, nor does your history show up in the address bar when typing previously used addresses. This usually happens because you've........

Install Errors on Version 12: This error happened on QEMU emulator version 2.11.1 pve-qemu-kvm_2.11.1-5 on Proxmox/Debian but installing on QEMU.12 on Centos 6 did not produce the error. *Update it is not related to the OS or QEMU version. This happened in Centos 6 too after a second install. What really causes this even though you successfully install........

This may sound silly but often on the same machine multiple versions of SQL may be installed due to other applications. How do we know which one we are running and connected to? Use the query: select @@version ........

mytop is one of my favorite tools and it is fairly simple aside from a few caveats and issues that persist to this day. To install it on Centos: yum -y install centos Configure ~/.mytop vi ~/.mytop user=root host=localhost db=test #port=3306 socket=/var/lib/mysql/mysql.sock header=1 color=1 Try runni........

#mount the VCSA DVD mount /dev/sr0 /mnt/cd #alternatively you could mount the iso directly mount -o loop vcsa.iso /your/mount/path #for this purpose we are using the CLI installer on Linux cd /mnt/cd/vcsa-cli-installer/lin64 #no it's not going to be that easy you can't just run vcsa-deploy like that you need to use a template or configured .json file ./vcsa-deploy Usage: vcsa-deploy [-h] [--version] [--supported-deploymen........

First find the line number: awk '/what you are searching for/{ print NR; exit }' input-file 86 Now use sed to replace it: sed -i 86s/.*/"your replacement text"/ $file Here is a full sample script to automate it: file=some/f........

mysqldump or mysql query of a larger file/table ERROR 2006 (HY000) at line 567: MySQL server has gone away Add this to /etc/my.cnf max_allowed_packet=64M service mysqld restart........

The code may lead you to believe you have an incompatible template but if you are not trying to use an old template currently that is not the issue. I actually deleted all 3.x style templates to make sure. What the issue is, is old plugins that are not compatible but Vbulletin does not seem to account for this except that you'll see a fatal PHPerror. You should disable all plugins and then enable one by one until you find the one that is causing the issue. &........

whois in Linux is incredibly out of date and does not seem to recognize most new TLDs domains, but there is a quick and easy tip/hack/tweak for this. An example of new TLD's site as .review .site .club whois somesite.club No whois server is known for this kind of object. bash to the rescue Now I did try to apply this in .bashrc but DONOT! Ithink the * wil........

The solution is simple but strange, if you copy your /var/lib/mysql directory to another server and think it will work, be sure to check if you have /var/log/mysql and binary log files. If you do, the server will not work and will give you errors like below and crash without the proper log files. UPDATE user SET password=password("newpass") WHERE user='root'; flush privileges; ERROR 2013 (HY000): Lost connection to MySQL server durin........

service named status rndc: connect failed: 127.0.0.1#953: connection refused named (pid 10557) is running... This issue is normally caused by a permissions issue where named doesn't have the permissions to read the rndc.key. Check /var/log/messages: Jan 4 17:06:22 storagebox named[10753]: none:0: open: /etc/rndc.key: permission denied Jan 4 17:06:22 storagebox named[10........

This happened while trying to delete several thousand users from phpBB and basically corrupted the innoDB tables. InnoDB: Page lsn 3 881164362, low 4 bytes of lsn at page end 881164362 InnoDB: Page number (if stored to page already) 86920, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be an index page where index id is 700 InnoDB: (index "tid_post_time" of table "phpBBdb2005"."phpbb3_p........

This example is based on Wordpress but applies to any other query string eg. http://wordpress.com/?p=55 If you want to manually redirect that p=55 to /some/other/url how do you do it? RewriteCond %{QUERY_STRING} p=55 [NC] RewriteRule .* /new-url/? [R=301,L] You can change the p=55 to whatever your query string looks like. Remember to keep the "?" at the end of the new URLunless you really want the query s........

I struggled with this for awhile because sometimes you have rewritten URLs that you want to pass a query string but most of the info and examples do not support this. Take a typical example like this: RewriteRule ^(.*)-(.*)-(.*) /?module=$3&id=$2 You need to add the QSA flag to make it work like below: RewriteRule ^(.*)-(.*)-(.*) /?module=$3&id=$2 [QSA] The QSA preserves the original query string but also appends it wit........

Enter the console as root mysql -u root -p Then kill the process (where 1234 = the thread ID) kill 1234 It's also a good idea to use a tool like "mtop" to monitor which processes and queries are slow, killing them is a temporary fix while you try to isolate the actual problem.........

I was having an issue with only certain random/jpeg files with the functions imagecreatefromjpeg imagecreatetruecolor and other related ones. This issue was annoying basically it seems like a libgd issue/bug with newer versions of PHP and it was difficult to trace-out. One very useful thing that helped me was using "php-cgi" and passing the query string as an argument eg: php-cgi images.php source=IMG.jpg (that way you get all the error messages wh........

DELETE FROM `wp_comments` WHERE NOT comment_author_email IN ('user@hotmail.com','another@hotmail.com') The above is an example of specific records you type out, but you could also base it on a subquery.........

I just realized I have some blank users which I deleted butI can still login to this dummy account without a password for some reason. mysql -u -p Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5 Server version: 5.1.69 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation an........

LSi Megaraid At first it was configured as a RAID 0, then I deleted the Virtual Disk Group. I thought both drives would be shown and detected in Linux as sda and sdb but it actually shows nothing. To make them work you have to hit Ctrl+R before the system boots (when prompted) and create a Virtual Disk Group. In my case I created each one as RAID 0 (with a single drive only) as I just wanted JBOD but there is no such option or default in these Dell Pe........

This is basically URL decoding to the decimal code but nothing in PHPworks how you'd expect it. Here are online tools to verify and check your work, it's important when querying databases with non-English characters: http://yehg.net/encoding/index.php# http://meyerweb.com/eric/tools/dencoder/ http://www.codetable.net/decimal/65398 Japanese: http://symbolcodes.tlt.psu.edu/bylanguage/japanesechartkatakana.html Charat code for PHP:........

netstat is weak and can't show udp connections and most other protocols, use "ss" which is what netstat should have been: The "-u" switch stands for udp, here's a list of other options: Usage: ss [ OPTIONS ] ss [ OPTIONS ] [ FILTER ] -h, --help this message -V, --version output ver........

If you have a webserver and find you have high IO/lagginess MySQL is one of the first things to check. It turns out MySQL was my problem and it was creating a high load on my server, especially for IO. How to Enable MySQL Slow Query Logging To Find Slow Performance/Queries vi /etc/my.cnf Add this anywhere under [mysqld] #slow queries log-slow-queries = /var/log/mysql/mysqlslowqueries.log long_query_time = 1........

Affected rows: 0 Warning: #1264 Out of range value adjusted for column 'deleteon' at row 1 SQL query: UPDATE `custtable`.`custinfo` SET `deleteon` = '2011-02-29 00:00:00' WHERE `custinfo`.`custid` =105 LIMIT 1 ; This happened after a migration to a new SQL database due to user error. The old database server MySQL 3.23 or 4 allowed an impossible date to be entered by a user. As we know February 29th DOESNOT exist but the database al........

genuine.com/IN: loading master file genuine.com.zone: file not found _default/genuine.com/IN: file not found I always found it silly that no one really talks about this and apparently many like me and even control panels like Plesk were still using hard paths. I always thought "why can't I just specify the name of the zone file and have bind find it". Surely the default search path must be /var/named or somewhere else but there is no such thing.........

I've only used it on Centos, soI thought I'd make a quick Debian guide: Install the DRBD Package apt-get install drbd8-utils Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libswfdec-0.8-0 Use 'apt-get autoremove' to remove them. The following........

The Xen VPSI had was not working properly and when they asked for the login information I found the support was coming directly from India: whois 122.178.148.* [Querying whois.apnic.net] [whois.apnic.net] % [whois.apnic.net node-5] % Whois data copyright terms http://www.apnic.net/db/dbcopyright.html inetnum: 122.178.128.0 - 122.178.191.255 netname:&........

I successfully created a single RAID 1 partition which includes /boot inside it and my root directory through the Debian installer. It said GRUB installed successfully but when I try booting the OS it seems GRUB can't read anything. When trying to boot from GRUB GRUB Loading stage 1.5. GRUB loading, please wait... Error 2 I get "Error 2" when trying to boot Debian. I also notice from a LiveCD that........

PHP cannot access /usr/bin/opensslI have verified the username that runs the process is able to access /usr/bin/openssl and it does exist but the PHP script is saying it doesn't exist: [code:1:1fd0f3abbe] if (!file_exists($OPENSSL)) { //echo "ERROR: OPENSSL $OPENSSL not foundn"; }[/code:1:1fd0f3abbe] I don't get itI can clearly see the contents of /usr/bin by using the PHP system fu........

CREATE Database/Granting PrivilegesCREATE your first database Code: [code:1:0668cd8e74]CREATE database myfirstdb; [/code:1:0668cd8e74] CREATE a user for your first database This one creates the user 'sqladmin' and gives them 'usage' on your new database 'myfirstdb' Code: [code:1:0668cd8e74]mysql> GRANT usage on myfirstdb.* to sqladmin@localhost; Query OK, 0 rows affected (0.00 sec)[/code:1:0668........

MySQL SubQueryI was trying to do a sub-query here but it wouldn't work (Syntax Error) in MySQL for some reason even though based on the SQL standards it should be ok. [i:1268bfa39e][b:1268bfa39e]I found the reason this doesn't work. I am using MySQL 3.23 and I read on the MySQL web site that versions before 4.1 DO NOT SUPPORT SUB-QUERIES so it showed me how to rewrite the following as a LEFT join instead of a sub-query. [/b:1268bfa39e][/i:1268bfa39e]........

This happened with a select statement which writes the result to an external file. I didn't remember the privilege "FILE" must be granted on *.* for this to work successfully, it wasn't actually an authentication issue as it implies since I was already in the SQL prompt and doing the query. SELECT some_id FROM sometable INTO OUTFILE '/tmp/result.txt'........

Backing MySQL Databases Backing Up/Dumping All Mysql Databases To A Single File mysqldump --all-databases -u admin -p > allmysqldatabases.sql The "-all-databases" clause is pretty obvious isn't it? It means that it will backup all databases. The "-u admin" means login using the user "admin", if you h........