“The certificate chain was issued by an authority that is not trusted” when connecting DB in VM Role from Azure website

You likely don’t have a CA signed certificate installed in your SQL VM’s trusted root store. If you have Encrypt=True in the connection string, either set that to off (not recommended), or add the following in the connection string: SQL Server will create a self-signed certificate if you don’t install one for it to use, but it … Read more

Git error on git pull (unable to update local ref)

My team and I ran into this error, unable to update local ref, when doing a pull in SourceTree. Update 2020: Per @Edward Yang’s answer below, @bryan’s comment on this answer, and this question/answer you may need to run both git gc –prune=now and git remote prune origin. Running only the former has always worked for me but based on ppl’s responses … Read more

What is process.env.PORT in Node.js?

In many environments (e.g. Heroku), and as a convention, you can set the environment variable PORT to tell your web server what port to listen on. So process.env.PORT || 3000 means: whatever is in the environment variable PORT, or 3000 if there’s nothing there. So you pass that to app.listen, or to app.set(‘port’, …), and that makes your server able to … Read more

How to record Android device’s screen on Android version below 4.4 (KitKat)

This only work in KitKat and via ADB only. This does not work below Kitkat. To start recording your device’s screen, run the following command: adb shell screenrecord /sdcard/example.mp4, This command will start recording your device’s screen using the default settings and save the resulting video to a file at /sdcard/example.mp4 file on your device. When you’re … Read more

java.io.IOException: Broken pipe

The most common reason I’ve had for a “broken pipe” is that one machine (of a pair communicating via socket) has shut down its end of the socket before communication was complete. About half of those were because the program communicating on that socket had terminated. If the program sending bytes sends them out and … Read more

org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set

First remove all of your configuration Spring Boot will start it for you. Make sure you have an application.properties in your classpath and add the following properties. If you really need access to a SessionFactory and that is basically for the same datasource, then you can do the following (which is also documented here although for XML, not JavaConfig). That way … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)