Base de Conocimientos

Install LAMP on CentOS 6.5 (Linux, Apache, MySQL,PHP) ================================ Update system ================================ yum update chkconfig --list chkconfig iptables off if enabled chkconfig ip6tables off if enabled chkconfig --list vi /etc/sysconfig/selinux if enabled change to disabled ================================= Install MySQL Server ================================= yum install mysql mysql-server chkconfig --levels 235 mysqld on service mysqld start mysql_secure_installation ================================== Install httpd server ================================== yum install httpd chkconfig --levels 235 httpd on service httpd start ================================== Install PHP ================================== yum install php /etc/init.d/httpd restart vi /var/www/html/info.php service httpd restart phpMyAdmin 4.5 Released. It is web-based client written in php for managing MySQL and MariaDB databases. It provides a user friendly web interface to access a...

Backup multiple SQL databases This is a query I use to backup all of my lab databases. I use System Center 2012 Orchestrator (SCORCH) to kick off a runbook which executes this query againsy my SQL servers to backup all of the databases. You know as well as I do, there are many ways to accomplish this task...some even easier, however, in attempts to use SCORCH more frequently, I decided to make a RunBook to which performed the job for me. Using SCORCH's "Query Database" activity, I pasted the following code in the query window and set the connection parameters and off it went. You can copy the code below and run it in a SSMS query window and it will work as well.     ]------ Begin Code ------[ --declaring variables DECLARE @dbname VARCHAR(100) -- database name DECLARE @bupath VARCHAR(100) -- path for backup location DECLARE @filename VARCHAR(100) -- filename used for backup files DECLARE @datestamp VARCHAR(25) -- date used for backup file timestamp -- spec...

How to configure SQL Express 2012 to accept remote connections When you try to connect to an instance of Microsoft SQL Server 2012 Express from a remote computer, you might receive an error message. INTRODUCTION Named SQL instances listen on dynamic ports. This is the function of the Sql Server Browser Service to inform the clients of the actual port. The Sql Browser listens on UDP 1434 and answers all client request with the port number the current instance is using. Sql Server Browser service is required for both TCP and named pipes protocols. SQL Server Browser is used by clients transparently and there is no need for special configuration. To configure SQL Server 2012 Express to allow remote connections, you must complete these steps: Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer. Configure SQL server to listen on static port Turn on the SQL Server Browser service. Configure the firewall ...

CentOS 7 / RHEL 7 systemd commands By now, if you’ve played around with CentOS 7 (or RHEL 7), you’ve heard that there are now systemd commands you can start using to start, restart and stop various services. They still have the ‘service’ command included for backwards compatibility, but that may go away in future releases. Here’s a little tutorial to help you learn the systemd commands! Ok, so you’re on your new CentOS 7 (or RHEL 7) system (we’ll just call it CentOS 7 for now to make it easier) and you restarted sshd with the old/familiar ‘service sshd restart’ command and you’re met with this: Redirecting to /bin/systemctl restart sshd.service [root@centos7 ~]# service sshd restart Redirecting to /bin/systemctl restart  sshd.service [root@centos7 ~]# service sshd restart Redirecting to /bin/systemctl restart  sshd.service Now, it still restarted it, but that little note is annoying. It’s basically telling you “hey – things have changed… use systemctl now!” You could now typ...

Putty, the Command Line and NO clicky clicky 5th October 2009 by Greg Ferro The power of the command line I believe that you should only use the mouse when you don’t know what are doing. That is why graphical interfaces exist. If you have a repetitive task, then clicking the same thing over and over shows that you are poor engineer. You need to take control of your tools to work in the smartest way. PuTTY is a fine example of having both options. You can clicky-clicky all you want and waste hours of of your life pushing your mouse around the screen. Or you can run a lot of the repetitive PuTTY actions from the command line. But first thing is to introduce to using the keyboard to get around Windows and open the DOS box. It always surprising how so few people know that Windows can actually be driven using the keyboard and very rarely need to use the mouse. Installation You need to note the directory that you installed PuTTY to, something like this would be the...

Disable or Enable SSH Root Login and Limit SSH Access in Linux by Ravi Saive Last Updated: November 20, 2012 Download Your Free eBooks NOW - 10 Free Linux eBooks for Administrators | 4 Free Shell Scripting eBooks Today, everyone knows that Linux systems comes with root user access and by default the root access is enabled for outside world. For security reason it’s not a good idea to have ssh root access enabled for unauthorized users. Because any hacker can try to brute force your password and gain access to your system. Disable SSH Root Login So, its better to have another account that you regularly use and then switch to root user by using ‘su – ‘ command when necessary. Before we start, make sure you have a regular user account and with that you su or sudo to gain root access. In Linu x, it’s very easy to create separate account, login as root user and simply run the ‘ adduser ‘ command to create separate user. Once user i...