Explore information related to 14


mysqldump error 1194 table is marked as crashed - Best Fixes ?


This article covers methods to resolve the mysqldump error 1194 for our customers. Generally database administrators use MySQL tables to store some important files along with their professional data or records. Though users store their important data but they are unaware of the situation that they can also lose their important data some day when the database gets corrupt or damaged. 

When MySQL database gets corrupted then it displays several error messages, one such error is "ERROR 1194 (HY000): Table 'table_name' is marked as crashed and should be repaired". And this error is very annoying so its very important to fix MySQL error 1194 as soon as you can.


Main causes of MySQL Error 1194:

  • Due to sudden system shutdown.
  • Virus/malware infection.
  • File system corruption after the newly installed program like hardware or software.

Read More



AWS MySQL error 1419 - Fix it Now ?


This article covers methods to resolve AWS MySQL error 1419. When automated backup is enabled for a MySQL DB instance, it also enables binary logging.

You might receive the following error message when creating a trigger: "ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)".

Read More



HTTP error 403: forbidden yum – Fix this error Now ?


This article covers methods to resolve HTTP error 403 which happens as a result of issues with files in repos.d, permissions or SELinux. 

To fix this error:

Grant read permission for other users inside CentOS/RHEL/OL 6 latest channel directory on local yum server.

Read More



mysqldump error 1146 table doesn't exist – Fix it Now ?


This article covers methods to resolve mysqldump: Got error: 1146: Table doesn't exist. To fix this error, you can simply save the database and dump it with innodb_force_recovery option. Most InnoDB corruptions are hardware-related. Corrupted page writes can be caused by power failures or bad memory. The issue also can be caused by using network-attached storage (NAS) and allocating InnoDB databases on it.

Read More



WHMCS error code 1013 - Fix it Now ?


This article covers WHMCS error code 1013. Basically, this error happens when the external_id entry is missing in psa.clients MySQL table. If the issue appears on WHMCS integrated with Plesk Multi Server, this database update should be done on the management node side.

Read More



MySQLdump: Got error: 1044 when selecting the database - Fix it Now ?


This article covers methods to resolve MySQLdump: Got error: 1044 when selecting the database. 

When this error happens, you will get an error message such as this:

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES


To fix this MySQLdump error: 

1. You can pass the –single-transaction option to mysqldump command:

$ mysqldump --single-transaction -u user -p DBNAME > backup.sql

2. Also, you can simply grant LOCK TABLES to your user:

$ mysql -u root -p

And type:

mysql> GRANT SELECT,LOCK TABLES ON DBNAME.* TO 'username'@'localhost';

Read More



DirectAdmin PhpMyAdmin error 500 - Fix it Now ?


This article covers methods to resolve DirectAdmin PhpMyAdmin error 500. This error happens as a result of a number of reasons that include PHP settings, modsecurity rules and so on.


To resolve this error, In the library is /usr/share/phpmyadmin/libraries/sql.lib.php,

You need to modify the file:

From && ($analyzed_sql_results['select_expr'][0] == '*')))

to && ($analyzed_sql_results['select_expr'][0] == '*'))

Read More



DISM Error 0x800f0906 "The source file could not be downloaded"


This article covers methods to fix DISM Error 0x800f0906. Basically, the failure of the DISM command-line utility will lead us to the DISM Error 0x800f0906.
The DISM (Deployment Image Servicing and Management) command-line utility is an incredibly nifty little tool that can be used to service and repair a Windows installation.
The DISM.exe command failing can be a pretty significant issue, especially if this happens when you desperately need the utility to work its magic.
When the DISM command-line tool fails with error code 0x800f0906, the accompanying error message either states that the source files could not be downloaded or that the files required to repair the store could not be found.

To resolve DISM Error 0x800f0906:

Uninstall the KB3022345 Update
1. Press the Windows key on your keyboard to open the Start menu, and either click Control Panel, or type in Control Panel and open the result, depending on which version of Windows you’re using.
2. Switch to Icons view, in the top right corner of Control Panel, and open Programs and Features from the list.
3. On the left side, click on the View installed updates
4. You will see a search box in the top right corner, type KB3022345 to find the update with less effort.
5. When you've found it, right-click it, and choose
6. Once everything is done, reboot your device.

Read More



IMAP server wants to alert you to the following error


This article will guide you the different causes for the error 'your IMAP server wants to alert you to the following'.

IMAP #Error code #0x800cccdd appears alongside the message "Your IMAP server closed the connection", which signifies that the "Send/Receive" feature—a setting that retrieves your #Outlook mail whenever connected to the Internet in order to keep your mail synced—has failed.

The error message "Your account temporarily blocked for #IMAP use. This may be happen if you exceed the maximum number of simultaneous IMAP connections allowed. Kindly try after some time" occurs when the mail client or different mail clients are trying to establish too many connections to IMAP server.

A server connection timeout means that a server is taking too long to reply to a data request made from another device. Timeouts are not a reply message: they show up when there isn't a reply and a server request is not fulfilled in a predetermined length of time.

To fix the mail server is not responding:

1. Check your internet connection.

2. Check your #SMTP server details.

3. Verify all usernames and passwords.

4. Check your SMTP server connection.

5. Change your SMTP port.

6. Control your #antivirus or #firewall settings.

Read More



OpenLDAP and phpLDAPadmin on Linux


This article will guide you on how to install #OpenLDAP and phpLDAPadmin on #Ubuntu. Also, we covered the prospective error affacting OpenLDAP and phpLDAPadmin and its solution as well.

#LDAP (Lightweight Directory Access Protocol) is an open and cross platform protocol used for directory services authentication. LDAP provides the communication language that applications use to communicate with other directory services servers.

#Kerberos is used to manage credentials securely (authentication) while LDAP is used for holding authoritative information about the accounts, such as what they're allowed to access (authorization), the user's full name and uid.

To access #phpLDAPadmin:

Point your browser to http://IP_OF_SERVER/phpldapadmin (IP_OF_SERVER is the actual IP address of your LDAP server). 

From the main window, click the login button in the left pane. 

When prompted, you will log into your DN and enter the password for the admin user created during the slapd reconfiguration.

Read More



Reporting services configuration manager


This article will guide you on how to setup reporting services configuration manager. Report Manager is Web based interface that can be used to perform different tasks such as. Administer the Report Server,View the Reports and Manager the Report, and so on. You need to have the URL to access the Report Server by using Report Manager interface.

SQL Server Reporting Services (#SSRS) is a reporting #software that allows you to produce formatted reports with tables in the form of data, #graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users.

Report server items are always stored in libraries or in a folder within a library. 

When you access the SharePoint site, you see the Browse page and the Library Tools tab.

In #Reporting Services, URLs are used to access the Report Server Web service and the web portal. A test link of the URL appears on page when you define the URL so that you can immediately confirm that the settings you specified result in a valid connection.

To connect to Reporting Services Configuration Manager:

1. Click Start, then click #Programs, then click #Microsoft #SQL Server, then click Configuration Tools, and then click Report Server Configuration Manager. 

2. The Report Server Installation Instance Selection dialog box appears so that you can select the report server instance you want to configure.

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



Microsoft SQL server error 18470 How to fix it


This article will guide you on the different factors that causes SQL server error: 18470 and also how to fix this #error.

In SQL Server Configuration Manager, in the left pane, click SQL Server Services. In the results pane, right-click SQL Server (#MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.

User gets the #Microsoft SQL Server Error: 18470. This may happen if the SA (System Administrator) user account is disabled in #SQL Server. It can be verified by trying to log in to SQL Server Management Studio (#SSMS) using the SA account. In the Login Properties screen, select Status on the left side.

To Microsoft SQL Server Error 18456:

1. Log In with Remote Desktop.

2. Run Microsoft SQL Server Management.

3. Checking the Server Authentication Mode.

4. Restart the SQL Service.

5. Checking SQL User Permissions.

6. Mapping the User to the #Database.

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



SQL server Error 1053


This article will guide you on different methods of fixing error #1053 SQL server which occurs when attempting to pause or stop the SQL Server service in the #Windows Services Console. 

The most common cause of this error is when one of the files needed by sql server was not on a shared resource, and Sql Server, once failed to the other node, couldn't access it.

The #SQL #Server Agent error log may include a path or a file name that is not correct.

In this case, verify that the path and file name for SQLAgent.out is valid:

1. In SQL Server Enterprise Manager, expand the Management folder.

2. Right-click SQL Server Agent, and then click Properties.

3. Under Error Log, make sure that the path that is specified next to File Name is valid.

4. Make sure that the file name is SQLAGENT.out.

Read More



Update Ubuntu from 16 04 to 18 04 via command line


This article will guide you on steps to #upgrade #Ubuntu #version.

To update Ubuntu using #terminal:

1. Open the terminal application.

2. For remote server use the ssh command to login (e.g. ssh user@server-name )

3. Fetch update software list by running #sudo apt-get update command.

4. Update Ubuntu #software by running sudo apt-get upgrade command.

5. Reboot the Ubuntu box if required by running sudo reboot.

Read More



Windows update error 0x80041014


This article will guide you on steps to resolve Windows update error #0x80041014 which occurs due to different reasons.
To use the troubleshooter to fix problems with #Windows Update, use these steps:
i. Open #Settings.
ii. Click on #Update & #Security.
iii. Click on Troubleshoot.
iv. Under the "Get up and running" section, select the Windows Update option.
v. Click the Run the #troubleshooter button. Source: Windows Central.
vi. Click the Close button.

Read More



Missing DLL files errors on Windows 10


This article will guide you on how to resolve #Windows Missing DLL files. A recent #application #installation sometimes overwrites an existing DLL file with an incompatible or invalid DLL file. A malicious #program has deleted or damaged a #DLL file.
To add a missing . DLL file to Windows:
i. Locate your missing . dll file at the DLL Dump site.
ii. Download the file and copy it to: "C:\Windows\System32".
iii. Click Start then Run and type in "regsvr32 name_of_dll. dll" and hit enter.

Read More



How to configure Redis as PHP Session Handler on Ubuntu 14 04


This article will guide you on the steps to configure Redis as a #PHP Session Handler.  #Redis is a powerful and fast key-value storage service. It can also be used as a #session handler for PHP, enabling scalable PHP #environments. Redis server can be used as a session handler for a PHP application running on Ubuntu and it is a data structure server. 

All of the data is stored in #RAM, so the speed of this system is phenomenal, often performing even better than #Memcached.

Redis is much more than a cache. But unlike a cache, Redis lets you operate on the values. There are 5 data types in Redis - Strings, Sets, Hash, Lists and Sorted Sets. Each data type exposes various #operations.

Read More



SQL server error 17 Steps to fix it


This article will guide you on the steps to fix 'SQL Server does not exist or access denied' error which occurs when the computer running #Microsoft #SQL Server is not reachable.

Read More



SQL Server error 14265 How to fix


This article will guide you on the steps to fix SQL Server #error 14265 which occurs when the #SQL Server #Agent service auto restarts the SQL #Server.

Read More



Fix Microsoft SQL Server Error 14258


SQL Server error 14258 triggers when a job is trying to run in the affected SQL instance.

Read More



Solve phpMyAdmin Timeout error 1440 session


We have dealt with numerous cases of MySQL and phpMyAdmin Errors and support request from our customers regarding Databases related errors as part of our Linux Support Services.

Read More



Fix Error sql72014


Most Clients often experience SQL server error in the process of creating a new database, importing, exporting and doing other sql query actions on their database.

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