change / replace text in linux without open the file

 sed -i 's/short_open_tag = Off/short_open_tag = On/g' /etc/php/5.6/cli/php.ini  in this command, am changing just Off to On in php.ini file. its works fine in ubuntu. Cheers....!!! #sed -i 's/original/new/g' file.txtExplanation:    sed = Stream Editor    -i = in-place (i.e. save back to the original file)    The command string:        s = the substitute command        original = a regular expression describing...

Read More

Default my.cnf content of maria-db

  # The MariaDB configuration file## The MariaDB/MySQL tools read configuration files in the following order:# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,# 2. "/etc/mysql/conf.d/*.cnf" to set global options.# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.# 4. "~/.my.cnf" to set user-specific options.## If the same option is defined multiple times, the last one will apply.## One can use all long options that the program...

Read More

Where is the mysql root password located in ubuntu after ispconfig installation

  Please find the password in this file. root@akwal:~# cat  /usr/local/ispconfig/server/lib/mysql_clientdb.confit will be like this:  Cheers....!!!...

Read More

ERROR 1118 (42000) at line 33: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

ERROR 1118 (42000) at line 33: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.  This generally happens, when innodb_strict_mode is active, make it off / deactivate using this command in sql prompt,  MariaDB [(none)]> SET GLOBAL innodb_strict_mode = 0;Query OK, 0 rows affected (0.000 sec)then it will works,That's it.Cheers...!...

Read More

ISPConfig fail to create MySQL database

 It is because ISPConfig can’t connect to MySQL server for creating new MySQL database.To fix, edit file /usr/local/ispconfig/server/lib/mysql_clientdb.conf e.g:root@akwal:~# vi /usr/local/ispconfig/server/lib/mysql_clientdb.confand update the new root password.<?php$clientdb_host                  = 'localhost';$clientdb_user                  = 'root';$clientdb_password         ...

Read More

How to Fix SQL CRC Error?

  Can be check through the following basic commands: Step 1: The root cause of the CRC error is an I/O subsystem issue, it is necessory to fix the storage issues by run the CHKDSK command to fix the cyclic redundancy check error in SQL.Run the CHKDSK utility on the disk where database stored with the /F parameter. Below is a screenshot of the command to check and fix the F: drive: Step 2: A complete disk de-fragmentation is recommended...

Read More

install php imagick php7.4

  How to install php imagick on php7.4?  First you check, is imagick is install on the server or not, have few method to check it.1. using command line, (connect the server using ssh), after successful connection, type command:# php -m|grep imagick2. using web, for this create a file info.php and paste this code to check which php extensions are installed.vi info.php and paste this code there.  <?phpphpinfo( );?> save...

Read More