Tony, Author at Defragged

LastPass Error: We couldn’t contact the server. Check your internet connection and try again.

Posted on August 16, 2022August 16, 2022 by Tony

Have no idea why this started, but it began a couple of weeks ago (August 2022). Today I finally had enough and had to get a solution, it was driving me bonkers.

Tried all the different options I could find, none seemed to work.

The only thing that worked for me was to “remove” the extension, then reinstall it. Reinstalled by going to the Lastpass download page here: https://lastpass.com/misc_download2.php

From there, clicked the “download” button which took me to the web store. You can probably do the same thing by going directly to the web store:https://lastpass.com/misc_download2.php

Other recommendations I found online included:

Basic recommendation:

Rebooting the machine
Clearing the browser cache

Extension specific recommendations:

Refreshing sites and clearing local cache in the plugin (didn’t even know this was a thing):

Click the LastPass icon in your web browser toolbar.
Go to Account Options or click your email at the bottom of this menu > Advanced > Refresh Sites then Clear Local Cache.
Log out and log back in to your LastPass account.

I tried each of these, none of them did the trick. This issue seems to be specific to Chrome, wasn’t able to replicate it in other browsers.

For me, the only solution was to uninstall and reinstall. Be aware that doing this can delete any passwords you added while it was having connection issues, although I found that it was still saving even with the warnings.

I don’t know, weird shit, but hope this helps.

Thanks

prefix “00~” and suffix “01~” added when pasting into MacOS terminal

Posted on July 28, 2022 by Tony

Been dealing with this issue as of late with my MacOS terminal (running MacOS Monterey version 12.4). Have no idea when it started, or why.

Looks something like this:

$ 00~stupidcopy01~

The easiest fix I have seen, that seems to do the trick is to use the “reset” command:

$ reset

It doesn’t hurt to kill your terminal instances.

Have no idea why it started, but I’m glad it’s gone. Was causing issues with passwords.

Thanks, hope it helps.

Git: Message ‘src refspec master does not match any’ when pushing commits in Git

Posted on November 15, 2021November 15, 2021 by Tony

On a recent project, I created a new Git repo and wanted to push my content to the repo from the staging server. You can find a very simple guide on how to do that here.

But as I was trying to push my content to the “existing” repo I was getting this error:

# git push -u origin master
error: src refspec master does not match any.
error: failed to push some refs to 'https://github.com/user/newrepo.git'

I was confused, but then remember seeing this error earlier in the process:

# git commit -m "first commit with content"
On branch master

Initial commit

Untracked files:
        assets/
        index.html

Turns out, the sequencing provided in the instructions was missing a critical step – Add the files you want to push to the repo after you set the origin.

So a simple fix was to add, then commit the files:

root@test:/var/www/test.net# git add .
root@test:/var/www/test.net# git commit -m "first commit"
[master (root-commit) 9dcbcbd] first commit
 135 files changed, 69694 insertions(+)

That should do the trick, and get you the response you’re expecting:

# git push origin master
Username for 'https://github.com':

So if you’re stuck with something similar, try checking that you actually added the files to be committed. 🙂

SQL: Delete all Rows with “foo” in the String

Posted on October 5, 2021October 5, 2021 by Tony

Let’s say you’re building something cool and you try to share this amazing thing with a friend. Then that friend decides to blow your DB up with useless entries. Because that is what friends do.

In such a scenario, you might end up with something like this:

select count(*) from table;
+----------+
| count(*) |
+----------+
|    12687 |
+----------+

If this is you, you might find yourself a bit distraught. But that’s ok, life is not that bad. Hopefully your friend did something like this:

|   12674 | foofoo12664      | foofoo12664@gmail.com        | foofoo12664     | $2y$10$102qeaPYWOzdIrXX2xNTIeOfEjHDKPW9xSRpByRTXas1MgkF7SOby | NULL    |
|   12675 | foofoo12665      | foofoo12665@gmail.com        | foofoo12665     | $2y$10$rcwXM0qSM20OrY8RQIQtU.ztcy5B2kVlT1C09R1ugJudxDBWw.7BK | NULL    |
|   12676 | foofoo12666      | foofoo12666@gmail.com        | foofoo12666     | $2y$10$kCzO15VoVs.l5F2112WY8eAyByLz9Bm1AC/bklQRE3pddWEEjWqHm | NULL    |
|   12677 | foofoo12667      | foofoo12667@gmail.com        | foofoo12667     | $2y$10$lVZVuNIhAwVPTmuJpyyUoO1..HQJhcFmqiGYVBdMCYlLIip4m8xr. | NULL    |
|   12678 | foofoo12668      | foofoo12668@gmail.com        | foofoo12668     | $2y$10$X8RplBFJpeShCg0qnsy64ecloXAtRfotgymi2WR709bTZ6.uN4kem | NULL    |
|   12679 | foofoo12669      | foofoo12669@gmail.com        | foofoo12669     | $2y$10$LVCjD9fqOVXi6A2LVX5FMOSTWnwq5WUK959Kw/M1QeTUsO3qaTBcm | NULL    |
|   12680 | foofoo12670      | foofoo12670@gmail.com        | foofoo12670     | $2y$10$smcLn6eirBkKeZayWVP4mONcoRfEWJOwYRbK08LndCO4F2hJ2Xj.G | NULL    |
|   12681 | foofoo12671      | foofoo12671@gmail.com        | foofoo12671     | $2y$10$mY11LeuTrz4sPLRov2nJceY974TDUIzqzO5spzTkKUDJowMpyszkW | NULL    |
|   12682 | foofoo12672      | foofoo12672@gmail.com        | foofoo12672     | $2y$10$fZJEkthgTXsWHRVYBsQMHuqJFn6FFIHg1vqibm8hqVH4f0yAbuHk2 | NULL    |
|   12683 | foofoo12673      | foofoo12673@gmail.com        | foofoo12673     | $2y$10$1/swwPhmHy66Oole.6Fepeh4hxJDwlOroMlDtCkgggxnsQsjAC86. | NULL    |
|   12684 | foofoo12674      | foofoo12674@gmail.com        | foofoo12674     | $2y$10$Whrwt8j19R4jFC6KdjGLoupsG78mH2fTzXIR78.lfQ/6xtZ/mNc3u | NULL    |
|   12685 | foofoo12675      | foofoo12675@gmail.com        | foofoo12675     | $2y$10$U0o9q3xWAOD2q/L2MBWn/OH4M5mJPODuk07fnfGIbTeKgaLDbBnka | NULL

In this scenario you can see common each row has similarities (i.e., “foofoo”). Because of this you can open your terminal and use the “Delete” command like this:

DELETE FROM table WHERE usersUid LIKE 'foofoo%';

This will remove each record in the table. This is what you need to know of the command above:

table	the table storing the data;
usersUid	the column you are going to query;
%	his operator is the wildcard, in my scenario I wanted it to delete every row that started with “foofoo” because that was the syntax they used. If I used the % operator before the query words, it would look for that syntax anywhere in the string.

You can then buy your friend a bag of coal for the holidays.

Cheers.

Creating a Keystore for Android Apps on Windows

Posted on September 22, 2021September 22, 2021 by Tony

If you’re building Android apps for the Android or Amazon Playstore you will need to sign your apps with a certificate. To do this, you will need a Keystore file. There are a lot of instructions on how to do this on a Mac, but if you’re on a Windows machine it’s a labyrinth of useless information.

This is a simple guide on how to create a keystore using Windows, here is what you will need:

Operating System	Windows 10
Java	Java SDK 17 (or latest version)

Yes, you need Java so just do it.

By default, the installation will go to: C:\Program Files\Java\ (remember this)

NOTE: Open Command prompt as Administrator, not doing this will generate a permission error.

In your command prompt, navigate to the bin folder. For me, it was:

cd "c:\Program Files\Java\jdk-17\bin"

From here, you can now run the keytool application like this:

keytool -genkey -v -keystore my-release-key.keystore -alias [change this value] -keyalg RSA -keysize 2048 -validity 10000

Set the -alias to whatever you’re going to call it. For instance it could “tonys-androidapp“.

NOTE: You can set the path where you want to store the .keystore by doing something like this

-keystore “C:\Users\Tony Perez\[Path to Keystore]\my-release-key.keystore”

It will prompt you to provide your keystore password:

Enter keystore password:
Re-enter new password:

Save this, you will need it. Fill out the rest of the information as you see fit:

What is your first and last name? Tony Perez
What is the name of your organizational unit? Engineering
What is the name of your organization? Tony Codes, LLC
What is the name of your City or Locality? Texas
What is the name of your State or Province? Texas
What is the two-letter country code for this unit? US
Is CN=Tony Perez, OU=CleanBrowsing, O=CleanBrowsing, L=Texas, ST=Texas, C=US correct? yes

That’s it, now you have a new keystore that you can use to sign your apps.

Cheers!

NET::ERR_CERT_COMMON_NAME_INVALID When Moving SSL Certs Between Servers

Posted on June 1, 2021April 28, 2022 by Tony

Been doing a lot of spring cleaning lately and every now and then I stumble into walls that send me down rabbit holes. Sucks for me, but it’s great for you. I use this site to document the process for myself, and in the process share some tips for anyone that might need it.

How to capture POST Requests on Webserver / Website

Posted on May 27, 2021April 28, 2022 by Tony

Sometimes you just want to see what someone is sending to your website. But how? Access logs by themselves can be pretty vanilla, you can see that a user made a POST request, but what exactly did they send?

Caution: This could include sensitive information like log in credentials, credit card information, and other sensitive data. Oh yeah, it will create massive log files that could create Disk I/O issues as well. Recommend doing this in a testing, troubleshooting, capacity only.

You can see what’s in the POST request by using the dumpio module for Apache

ERROR 1064 (42000) at line 1 – Passing MySQL Create User Arguments via SSH

Posted on May 25, 2021April 28, 2022 by Tony

I was recently building a script to help move things from one server to another and in the process stumbled into a very annoying problem when passing MySQL arguments to a remote server via SSH.

Desired outcome: Create a new user in a remote DB using SSH.

In practice, this should be extremely simple. If you do this on the server, you could execute a command like this:

mysql --user="root" --password="[pass]" --execute="create user 'testing'@'localhost' identified by '123';"

You would now have a new user in your database called testing and it’s password would be 123.

Can’t Scroll in Windows Subsystem for Linux

Posted on May 11, 2021May 28, 2021 by Tony

I don’t know when it started, but at some point in 2021 I was not able to scroll inside my linux terminal on Windows. I really don’t care why it started, but I do know the fix.

After banging my head on a wall, and living with it for a few months, I decided enough was enough.

Working with Merge Conflicts in Git

Posted on May 7, 2021May 28, 2021 by Tony

There are instances while working with a shared repo that your Pull Request will hit a conflict with the master repo and that will prevent your PR from being merged.

The easiest way to resolve this is going to be via your terminal.