Thursday, March 28, 2013

STATUS CODE 48: A Status 48 "Client hostname could not be found" message occurs during backup.

Problem:

STATUS CODE 48: A Status 48 "Client hostname could not be found" message occurs during backup.

 

Solution:

1. Ensure that all servers and clients are added to name service tables or local hosts file

2. Verify that name resolution is valid (hostnames are case-sensitive depending on the OS used). Try to "ping" the client from the server where this error occurs. Use the hostname for the client, as specified in the NetBackup Policy for the failing backup.

OR



1. Add host name/IP entries for the Master Server, Media Server and Client in their respective /etc/hosts files.
   Location of host file:

   UNIX:   /etc/hosts

   Windows:  %SystemRoot%\system32\drivers\etc\hosts

Ensure that all hosts involved have host entries for both themselves and one another.

                                       ************************
Thanks,
Big B

 

 

Wednesday, March 13, 2013

Mysql ERROR 1418

If get the error like above simply follow the below step to resolve it.

MySQL Error 1418
ERROR 1418 (HY000) at line 5: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Type below command in your mysql command prompt:

# mysql -u root -p
 
MySQL> SET GLOBAL log_bin_trust_function_creators = ON;
OR
MySQL> # SET GLOBAL log_bin_trust_function_creators = 1;
 
********************