This is an article which is made to show an alternative for describing on how to solve problems where there is an error generated by SSH utility command which is executed to remote several servers. The error is ‘access denied’ as shown below :
user@hostname:/opt$ ssh - l firstname.lastname@example.org
In order to solve the problem, there are several steps which is taken as described below :
1. Check to content of /var/log/secure
Continue reading “SSH Access Denied because Invalid User”
DIA which is stands for Diagram Editor is a multi-purpose editor developed for editing numerous diagram such as ERD (Entity Relationship Diagram), UML or any other diagrams that can be saved and exported to other formats. Moreover, this editor is available in several operating system to be installed.
In this article, there will be steps explained to install DIA in Ubuntu 16.04 Linux Operating System. Below are those steps :
- First of all, the most general step is to update the operating system. The following syntax is the one which is used to perform it :
Below is the execution of the above command in a command prompt :
Continue reading “Installing DIA on Ubuntu16.04”
This is an article which is made to display some sort of explanation on creating an additional table for many to many relationship. As it has already known that creating additional table is necessary to describe a many to many relationship.
The scenario is described in detail as follows :
If there are many users whom are registered to a system where those users are also have lots or more than one roles in the system. Below is actually the scenario for creating the tables. In this context, the database which is used is MySQL. First of all, create the user table :
CREATE TABLE user
id INT NOT NULL AUTO_INCREMENT,
And after that, create the other table which is made to manage the roles available. It is shown as follows :
Continue reading “Create Additional Table for Many to Many Relationship in MySQL Database Server”
This is an article relates on the development of a web-based application using Laravel framework. It is about how to print the possible and available routes which can be used and executed to access certain pages using certain URL address.
To be able to print any available and possible URL address which is provided in the web-based application using Laravel as its framework, a built-in utility such as ‘artisan’ can be very useful to fullfil that purpose. Below is an attempt to do that :
root@hostname:/var/www/html/laravel-project# php artisan routes
Command "routes" is not defined.
Did you mean one of these?
In the above output command, there are actually several possibilities which can be used and it will affect or functioning for different purpose.
For the above purpose which is printing the available and possible route of a web-based application developed using Laravel framework, below is the correct execution command :
Continue reading “Print Available Route in Laravel”
This is another article related to MySQL Database Server on how to actually add field after another field by doing it via command line. That is actually an action which is going to alter or to change the table itself. Since the change is done by executing it from command line without actually using any help from Graphical MySQL Editor, every steps must be done manually. Below are steps which must be done accordingly :
1. First of all, make sure that the service or the port listening for MySQL Database service is alive and it is in the state of listening incoming request. For details, read the article titled ‘Check MySQL Service Status‘ in this link.
2. After checking MySQL Service Status and considering that the service itself is active, try to connect to the MySQL Database Server. Read this article titled ‘Remote Execute MySQL Query via Command Line‘ which can be visited in this link. Basically, either accessing it locally or remotely, it has the same rules and syntax performed.
3. After successfully connecting to MySQL Database Remote console, try to select the associated database which has the table in it.
4. Successfully selecting the database where the table appointed to be altered the last step which is the most important part is the step for altering the table. For an example the following is shown as follows :
A table named ‘user’ and it can be described as follow to see details of fields exist :
mysql> desc user;
| Field | Type | Null | Key | Default | Extra |
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(255) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
4 rows in set (0,01 sec)
Continue reading “Alter Table Add Field after Another Field MySQL example via Command Line”