Unable to connect to mongolab, Getting MongoError: auth failed

Make sure you are using the database username and password not the account username and password from Mlab. In MLab, formerly MongoLab, do the following Navigate to Users Add Database User Choose your username and password Now you can test this on the shell with mongo ds061374.mlab.com:61374/yourdb -u <dbuser> -p <dbpassword>

grabbing first row in a mysql query only

To return only one row use LIMIT 1: It doesn’t make sense to say ‘first row’ or ‘last row’ unless you have an ORDER BY clause. Assuming you add an ORDER BY clause then you can use LIMIT in the following ways: To get the first row use LIMIT 1. To get the 2nd row you can use limit with an … Read more

Passing just a type as a parameter in C#

There are two common approaches. First, you can pass System.Type This would be called like: int val = (int)GetColumnValue(columnName, typeof(int)); The other option would be to use generics: This has the advantage of avoiding the boxing and pr

Encrypt Password in Configuration Files?

A simple way of doing this is to use Password Based Encryption in Java. This allows you to encrypt and decrypt a text by using a password. This basically means initializing a javax.crypto.Cipher with algorithm “AES/CBC/PKCS5Padding” and getting a key from javax.crypto.SecretKeyFactory with the “PBKDF2WithHmacSHA512” algorithm. Here is a code example (updated to replace the less secure MD5-based variant): One problem remains: Where … Read more

Call to undefined method mysqli_stmt::get_result

Please read the user notes for this method: http://php.net/manual/en/mysqli-stmt.get-result.php It requires the mysqlnd driver… If it isn’t installed on your webspace you will have to work with bind_result() & fetch()!

PyQt is thread-safe to the same extent that Qt is thread-safe. The Qt docs will tell you which parts of their API are guaranteed to be so, and under what circumstances.

Cross-thread signals are thread-safe, so calling the updatePB method in your example is okay. Your ConnDisconn method is not thread-safe, but that has got nothing to do with PyQt or Qt – it’s just a consequence of how you wrote it. The serialEnabled attribute could be read/written by two threads simultaneously, so the behaviour is strictly undefined. A thread-safe way of … Read more