How To Get Started on Ubuntu with gpt-2 OpenAI Text Prediction
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........
MariaDB / MySQL Reset Root Forgotten Password on Centos 7
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........
MySQL Cheatsheet Guide and Tutorial
Create Database:
create database yourdbname;
Show All Databases:
show databases;
Change Database:
use mysql;
Drop / Delete a MySQL Database:
drop database nameofyourdatabase;........
bash how to count the number of columns or words in a line
This is just if we have an output line. wc we know can count lines but the -w flag will count words:
echo "Ihave this line here" |wc -w
5........
PayPal IPN Failed "result: IPN Handshake Invalid"
This is often the result of PayPal's "item name" or another name having invalid characters or not supporting Unicode.
173.0.81.1 - - [17/Jul/2018:13:39:45 -0400] "POST //modules/gateways/callback/paypal.php HTTP/1.1" 406 - "-" "PayPal IPN ( https://www.paypal.com/ipn )"
A good clue is if you check the debug output of the IPNand find a mandatory column empty.
........
MySQL How To Add New Field Column To Existing Table
ALTER TABLE thetable ADD newfield VARCHAR(255)
It's very simple just specify "the table" and then the newfield type........
MySQL How to add a field/column using alter
ALTER TABLE yourtable ADD COLUMN info VARCHAR(255)........
Sipura / Linksys PAP/VOIP/SIP Adapter Issue Can't receiving incoming phone calls and you're behind a NAT router (99% of people)? solution
Sipura / Linksys PAP/VOIP/SIP Adapter Issue
Can't receiving incoming phone calls and you're behind a NAT router (99% of people)?
1. Login to the adapter.
2. Click on "Advanced" (location varies but usually somewhere on top)
2. Click on "SIP"
3. Scroll down to "NAT" (usually at the bottom).
You'll find 2 columns with 4 rows of drop-down boxes (they'........
MySQL Show Print List of Field Names only without other data or attributes
SELECT column_name
FROM information_schema.columns
W........
openoffice calc printing extra blank pages
Make sure that the Page mode is set to landscape and that the columns fall within the margins/boundaries, otherwise this is why there will be blank pages (Print Preview will show you this too).........
MySQL Out of Range Solution for DATETIME field
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........
MySQL TEXT field size length limit reminder, don't truncate your data!
I thought there would be an error message or warning from MySQL in the case that the text you submit is greater than the allowed limit based on the field.
So essentially I submitted text that was about 120,000 characters long, whereas the limit of TEXT is just 65,535 characters! I almost lost half of my data/what I typed without knowing it!
I just altered the field type in my database from TEXT to LONGTEXT. I can't see how LONGTEXT wouldn't be long enough for MOST........
PHP cannot access /usr/bin/openssl
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........