Configuration file in phpmyadmin will require a blowfish_secret to be set. Ensure to check if the below line is has the needed value. (more…)

Check the connection string that is used for authenticating with MongoDB server. When trying to connect with MongoDB Compass connection may be working and it might fail when connecting via NodeJS code. Check if authSource parameter and the ssl param are properly set. Sample MongoDB URI that works on NodeJS connection setup is shown below: MONGO_URI=mongodb://USER:Password@localhost:27017/SampleDatabase?authSource=admin&readPreference=primary&directConnection=true&ssl=false

Command to establish the SSH Tunnel to MongoDB on remote server $ ssh -L :27018:127.0.0.1:27017 -i /path/serverkey.pem remoteserverUSER@remoteserverIP -N -v -v (more…)

MongoDB known as Mongo, is an open-source document database that is used in a wide variety of modern online applications. It is categorised as a NoSQL database because it does not use the usual table-based relational database structure. MongoDB uses JSON-like documents with dynamic schemas, which implies that, unlike relational databases, MongoDB does not require a schema to be defined before data can be added to a database. You can alter the schema whenever and as frequently as you want without having to build a new database with the revised structure. MongoDB package available in Ubuntu is not managed by MongoDB and we will follow the steps below to install a version managed by MongoDB (more…)

For example, you may have table with varchar, text or longtext fields and you may see garbled data in it. Though the text appears correctly on web pages, inside MySQL junk characters may appear. CREATE TABLE `my_news` ( `nid` bigint(10) NOT NULL DEFAULT '0', `title` text, `short_news` longtext) ENGINE=MyISAM DEFAULT CHARSET=utf8; In order to correct this error, try to alter the table in the following sequence. (more…)

Step 1: Identify the user id for which you want to change the password Step 2: Issue the below MySQL command to update the password for the selected user update wpgi_users set user_pass=MD5('yourpasswordgoeshere') where wpgi_users.id=1