Categories
Fix SQL Tips Web

How to Reset the Primary Key Sequence ID in PostgreSQL

I run into an issue today with PostgreSQL. I had manually entered a row into a table and it caused the primary key to fall out of sequence. To reset the primary key sequence ID on the PostgreSQL table I used the setval and pg_get_serial_sequence functions. Source: How to reset postgres’ primary key sequence when […]

Categories
Fix PHP Web

Xdebug with Built-in PHP Server

When using Xdebug with the built-in PHP server be sure you have the proper configuration in your php.ini file. Will will need at a minimum the following settings: If you run into an issue running Xdebug via PHPStorm, or another IDE, when using the built-in PHP server on macOS, or Ubuntu, you might have a […]

Categories
Fix SQL Web

Fixing MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

To fix, “MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes” on Ubuntu edit your /etc/mysql/mysql.conf.d/mysqld.cnf. Once you have opened the file, increase the max_allowed_packet to a value that works for your environment. For example, in a local development environment, 100M can work. Then restart MySQL. Resources https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes

Categories
Browsers Fix Laravel Mac Web

Getting macOS to trust all your self-signed SSL certificates from Homestead with a single shot

If you want Google Chrome on macOS (previously OS X) to always trust all of your sites hosted on your Laravel Homestead vagrant box add the Homestead  ca.homestead.homestead.crt certificate file to your Mac’s Keychain Access and trust the certificate. Take a look at how this can be done. To import your .csr file as a […]

Categories
Browsers Fix Laravel Mac Web

Stop Chrome & Firefox from blocking HTTPS requests by default for all domains hosted by Homestead

Virtual hosted Homestead SSL URLs in both Chrome and Firefox display an insecure message when visited. In this tutoial we will stop these browsers from blocking HTTPS requests by default for all domains hosted by Homestead. To get started, you simply need to import your certificate authority, .csr, file into Firefox. For Chrome you need […]