Explore information related to server management


The source file names are larger than is supported by the file system


This article covers methods to resolve Windows error "The source file names are larger than is supported by the file system". Most Windows users encounter this issue when trying to copy or delete a file on the computer and they may receive an error message saying Source Path Too Long with the explanation of the source file name(s) are larger than is supported by the file system.


This Windows error error happens mainly because one or more files that are kept in a series of subfolders that have long names, but Windows only allows 258 characters at most in the folder path subfolder.
This will prevent you from moving the files or folders that are saved in this folder.

To fix this windows error, try the following:

Delete the File/Folder by Bypassing the Recycle Bin
You know that when you delete files from your computer, these files will be first moved to the Recycle Bin and they will stay there until you delete them permanently.
i. Click on the file or folder that is bothered by the Source Path Too Long error.
ii. Press the SHIFT and Delete buttons at the same time to permanently delete the file or folder.

Read More



Recover orphan innodb database from ibd file - How to perform this task


This article covers how to recover the orphan InnoDB database from the ibd file. 


Orphan InnoDB database incident mostly happened when:

1 – user accidentally remove ibdata1 file. (mostly in /var/lib/mysql/ibdata1).

2 – ibdata file courrupted.


To Recover Orphaned InnoDB Tables:

1. Restart the MySQL service to recreate ibdata1, then take a backup of your database folder.

2. Login to MySQL.

3. Create a dummy database with the same name. Then, create a dummy table with the same name as the corrupted one (don’t mind the table structure for now).

4. Stop the MySQL service, copy the .frm file from the backup you took to replace the .frm file.

5. Start MySQL and have a look at the structure of your table - it should now be in place! However, don’t get too happy yet.

6. Issue a SHOW CREATE TABLE statement and copy its contents, then create the table with them.

7. Stop MySQL, copy the .ibd file from the backup directory to /var/lib/database_name and replace the existing .ibd file from the dummy table.

8. Now it’s time for Percona’s tools to shine - download and install the Percona Data Recovery Tool for InnoDB , then run the following (here -o represents the full location of your ibdata1 file, -f represents the full location of your .ibd file, -d represents the database name and -t represents your table name):

ibdconnect -o /var/lib/mysql/ibdata1 -f /var/lib/mysql/database_name/table_name.ibd -d database_name -t table_name

9. Now, run a checksum check against InnoDB - make sure you get no error messages (you might need to run this tool several times):

innochecksum /var/lib/mysql/ibdata1

10. Finally, you should be good to go - simply start MySQL.

Read More



Authentication In Vue Using Vuex


This article covers how to perform Authentication In Vue Using Vuex. 

Using Vuex allows us to store and manage authentication state and proceed to check state in our application using only a few lines of code.


To Set up the application modules:

For this project, we want to create a vue application that has vuex and vue-router. 

i. We will use the vue cli 3.0 to create a new vue project and select router and vuex from the options.

Run the following command to set it up:

$ vue create vue-auth

ii. Follow the dialogue that shows up, add the necessary information and select the options we need and complete the installation.

iii. Next, install axios:

$ npm install axios --save

Read More



About robots txt allow and disallow


This article will guide you on how to create robots.txt and fix #errors related to it. Basically, we can instruct the crawler as to which page to crawl and which page not to crawl using the #robots .txt allow and disallow directives.

Web site owners use the /robots. txt file to give instructions about their site to web robots; this is called The Robots Exclusion Protocol.

The "Disallow: /" tells the robot that it should not visit any pages on the site.

1. The robots. txt file can tell crawlers where to find the XML #sitemap file(s), how fast the site can be crawled, and (most famously) which webpages and directories not to crawl.

2. The robots. txt file, also known as the robots exclusion protocol or standard, is a text file that tells web robots (most often search engines) which pages on your site to crawl. 

3. It also tells web robots which pages not to crawl.

txt file. 

4. The asterisk after “user-agent” means that the robots.

Read More



Install SQL Server 2019 on Linux


This article will guide you the process to install #MSSQL Server 2019 on #CentOS 7 and Ubuntu 16.04.

SQL Server 2019 #Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.

SQL Server 2019 allows us to integrate data from structured and unstructured data sources. 

We can now process diverse big data and relational data sources using Transact-SQL from SQL Server using PolyBase. 

We can see below PolyBase support external databases.

SQL Server Express can be used in production (beware of the limitations, like the 10GB cap), but according to this link Express is available for Linux. SQL Server Express is available to use in Production.

Starting with SQL Server 2017, SQL Server runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. It's the same SQL Server database engine, with many similar features and services regardless of your operating system.

To run a SQL script in #Linux terminal:

1. Open Terminal and type mysql -u to Open the MySQL command line.

2. Type the path of your #mysql bin directory and press Enter.

3. Paste your #SQL file inside the bin folder of mysql server.

4. Create a #database in MySQL.

5. Use that particular database where you want to import the SQL file.

Read More



Benefits of Push notification


This article is about the different benefits of push notifications. Basically, the push #notifications benefits the #website in improving the traffic. 

Push notifications can considerably enhance your customer experience. They're less intrusive than other forms of user engagement and can effectively drive traffic and help users by providing useful information. They allow your users to keep up with the latest updates, promotions, and offers.

Read More



Configure and Use Microsoft SQL Server Management Studio


This article will guide you on how to setup SQL server management studio. SQL Server Management Studio is a free #Windows #application to configure, manage, and administer Microsoft SQL Server (#MSSQL). 

SSMS is available only as a 32-bit application for Windows.

To get SQL Server Management Studio:

1. Go To Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft #SSMS 18. 

2. Below 'Connect to Server' screen will appear. 

3. Server Name defaults to the name selected while installing MS SQL server. 

4. Server type: This is an option to select one out of four available MS SQL services option.

To Enable remote connections to your SQL Server:

i. Open #SQL Server Management Studio.

ii. Right-click your server's name and select Properties.

iii. Tick the checkbox Allow remote connections to this server.

iv. Select OK.

Read More



Modify MSSQL port


This article will guide you on the right steps to change the #MSSQL port using #SQL Server Configuration Manager. 

You can check TCP/IP connectivity to SQL Server by using telnet. For example, at the command prompt, type telnet 192.168. 0.0 1433 where 192.168. 0.0 is the address of the #computer that is running SQL Server and 1433 is the port it is listening on.

To specify a port in SQL Server Management Studio (#SSMS)?

1. You'll need the SQL Server Configuration Manager. 

2. Go to Sql Native Client Configuration, Select Client Protocols.

3. Right Click on #TCP / #IP and set your default port there.

Read More



Plesk MSSQL remote connection


This article will guide you on how to enable and resolve #MSSQL related #errors. MSSQL remote connection is disabled in #Plesk servers by default.

To enable remote connections to MS SQL server:

1. Connect to the server via RDP.

2. Press the Start button, go to Microsoft SQL Server XXXX (where XXXX is the MSSQL version) and click the SQL Server XXX Configuration Manager.

3. Open the SQL Server Configuration Manager (Local) > #SQL Server Network Configuration menu and click the Protocols for MSSQLSERVERXXXX (where XXXX is the MSSQL version).

4. Make sure that the TCP/IP protocol has the Enabled status

5. Double-click the TCP/IP protocol, go to the IP Addresses tab and scroll down to the IPAll section.

6. Specify 1433 in the TCP Port field (or another port if 1433 is used by another MS SQL Server) and press the OK button:

Note: the specified port, e.g, 1433, must be opened in the firewall.

Read More



Configure Reporting Services in SQL Server


The article will guide you on the steps to follow to configure #reporting services after renaming the #SQL server. Also , you will learn how to rename the SQL server instance. 

To Configure #Report Server After Renaming SQL Server #Instance:

1. Go to #Database Setup page. 

2. Enter SQL Server name in Server Name and then click Connect. 

3. If Reporting Services is configured using the server name, you must update the database connection information whenever the server name is changed.

To change the service account for SQL Server Reporting Services:

i. Open Reporting Services Configuration Manager, and then connect to the instance of SQL Server Reporting Services.

ii. Click #Microsoft service Identity on the left pane.

iii. Change the account and the password in the Account text box and the Password text box, and then click Apply.

Read More



Lets encrypt new auth status 429 error


This article will guide you on methods to troubleshoot and fix 429 error which occurs due to creation of multiple #SSL #certificates for a #domain. 

1. 429 means you went over the rate #limits. 

2. You issued 5 certificates in the last week.  This is why you get a #429 answer.

3. You need to wait two days to get another one. do you have access to the certificates you issued?

Read More



Using FreeBSD Single-User Mode to recover from File System Corruption


This article will guide you on how to recover from #File #System #Corruption Using FreeBSD's Single-User Mode.

While #filesystem corruption is never a good thing, it doesn't necessarily mean that all of your important data was lost. The success of your #recovery #operations comes down to a number of factors, such as how quickly the filesystem noticed the corruption, how widespread the issue was, and what files were affected.

Corrupted files are computer files that suddenly become inoperable or unusable. There are several reasons why a file may become corrupted. In some cases, it is possible to recover and fix the corrupted file, while at other times it may be necessary to delete the file and replace it with an earlier saved version.

To fix corrupted files in #Windows 10:

1. Use the #SFC tool.

2. Use #DISM tool.

3. Run SFC scan from Safe Mode.

4. Perform SFC scan before Windows 10 starts.

5. Replace the files manually.

6. Use System #Restore.

7. Reset your Windows 10.

Read More



How to modify MSSQL Database Autogrowth Configuration


This article will guide you on how #MSSQL Database Autogrowth Configuration works. Therefore do not rely on the default #SQL Server Data and Log file Autogrowth value and must always set it to more realistic values depending upon the usage of the database.

To see data file growth in SQL #Server:

1. Connect to a SQL instance and right-click on a database for which we want to get details of Auto Growth and Shrink Events. 

2. It opens the disk usage report of the specified #database. 

3. In this #disk usage report, we get the details of the data file and log file space usage.

To Change default database location via SQL Server Management Studio:

i. Right Click on Server and Select "Properties".

ii. In the "Server Properties" dialog box, navigate to "Database Settings" tab and data/log files location under "Database default locations" group. 

iii. Click on "OK" to apply changes.

Read More



SQL Server and create a database on Ubuntu How to install


This article will guide you on how to #install MS SQL on #Ubuntu Server 18.04. 

To Install #Microsoft SQL Server 2017:

1. Visit Microsoft's official SQL Server 2017 download page.

2. Select the edition you want to #download. 

3. Click Download now below your selected edition. 

4. The wizard will prompt you to select an installation type. 

5. On the next page, select a directory for the installation folder.

To connect to the SQL Server using #SSMS:

i. From the Connect menu under the Object Explorer, choose the #Database Engine.

ii. Then, enter the information for the Server name (localhost), Authentication (SQL Server Authentication), and password for the sa user.

iii. Click the Connect button to connect to the SQL Server.

Read More



Manage a Linux Server with systemd


Like the init #daemon, #systemd is a daemon that manages other daemons, which, including systemd itself, are background #processes. systemd is the first daemon to start during booting and the last daemon to terminate during shutdown.

This article will guide you on how to manage #Linux server using systemd. Additionally, we saw the different commands used to Manage Linux serves with systemd. While systemd is compatible with SysV and Linux Standard Base (LSB) init scripts, systemd is meant to be a drop-in replacement for these older ways of getting a Linux system running.

To start (activate) a service , you will run the command 'systemctl start my_service. service', this will start the service immediately in the current session. 

To enable a service at boot , you will run 'systemctl enable my_service. service'.

Read More



Steps to deploy DACPAC with SSMS


This article will guide you on the steps to deploy DACPAC which involves registering a DAC instance by storing the DAC definition in the #msdb system database. 

A DAC is a self-contained unit of #SQL Server #database deployment that enables data-tier developers and database administrators to package SQL #Server objects into a portable artifact called a #DAC package, also known as a #DACPAC.

Read More



Outsourcing server administration Best Services


In conclusion, #outsourcing server #administration provides 24×7 server monitoring by an #Expert Team at an #affordable cost. We specialize on #Hosting #Tech #Support, IT Infrastructure Management, IT Infrastructure Support, #Linux Server Managed #IT Services, #Outsourced Web Hosting Support, Server Management, Server Monitoring, Server Support, System Administration, #Whitelabel #Helpdesk Support

Read More



Advantages of using our Server Management Services


Ibmi Media Server administrators will help you install, configure, and maintain various types of hardware and software, which often involves creating user accounts, carrying out backup and recovery functions, and monitoring the performance of servers at all times. Our Support Experts will take care of configuring, managing, and implementing operating systems.

Read More



RM cannot remove read-only file system tips to fix


This article will guide you on how to fix 'rm cannot remove the read-only file system' error  by simply removing files from the read-only file system.

Read More



How to install Homebrew on mac


This article will guide you on how to install Homebrew on Mac.

Read More



PuTTY Fatal Error Connection timed out


This article will help to fix "PuTTY Fatal Error: Connection timed out" which occurs when the IP address of the host and virtual machine does not belong to the same subnet.

Read More



Too many open files Linux


This article will guide you on how to fix Linux error "Too Many Open Files" and method of changing the default limits set by Linux.

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com






Focus on your business, not your servers.

Click Here to Learn More