mysql: ‘%’ doesn’t match localhost and/or hostname
PROBLEM: You granted access privileges to a user connecting from anywhere using this command: mysql> GRANT ALL PRIVILEGES ON *.* TO prueba@'%' IDENTIFIED BY 'password' Then, when you try to…
samba troubleshooting
WARNING: Ignoring invalid value 'share' for parameter 'security' The value 'share' for paramater 'security' is no longer valid for recent versions of Samba, so if you were running an older…
git configuration files
There are three levels of configuration in git: System Values defined at this level will apply to all users. The values are stored in /etc/gitconfig Global Values defined at the…
Cassandra troubleshooting
Execution of 'nodetool status' fails Common error messages: Error: Could not find or load main class Error opening zip file or JAR manifest missing : /usr/local/bin/../ Error occurred during initialization…
git: clone a repository without the project folder
When you clone a remote repository, a folder with the name of the project is created in your local working directory and then the contents of the repository is copied…
MySQL cheatsheet
Show MySQL configuration settings mysql> SHOW VARIABLES; Show MySQL running threads mysql > SHOW PROCESSLIST; Check the status of the tables of a database $ mysqlcheck -c <database>
share multimedia files with Smart TVs
You can easily share your videos, music and pictures stored in your linux box with your Smart TV, all you have to do is configure a DLNA server in linux.…
Samba 4 Active Directory cheatsheet
Transfer FSMO roles Execute from the Samba 4 server you want the roles to be transferred to: samba-tool fsmo seize --role=<role> where <role> can be any of: rid, schema, pdc,…
apache: show loaded modules
There are many ways to list the modules currently loaded in an Apache server, here are 2 of them: Method 1: use apachectl Execute from the command line: apachectl -t…
Migrate OpenLDAP to another server and/or version
If you need to migrate the contents of an OpenLDAP server into another server, then do the following: Copy database contents to a file: # / stop # slapcat >…