Watch4net: How to increase the default allowed length for email address; Default User Email Address limit of 50 is too short

Products

• VMware

Issue/Introduction

Symptoms:


How to increase the default allowed length for email address in Watch4net

Watch4net APG User Email Address has a default character limit of 50, need to have at least 128

Environment

VMware Smart Assurance - Watch4Net/M&R

Resolution

To increase Watch4net APG User Email Address character limit, do the following: 

1. Stop the backend service:
   
   /opt/AGP/bin/manage-modules.sh service backend stop
   
    
2. Log into MySQL. In Watch4net 6.x, MySQL is here: 
   
   /opt/APG/bin/mysql-client.sh
   
    
3. • User: apg
   • Database: master
   • pwd: <your pwd>
     
      
4. Run the following at the MySQL prompt:
   
   mysql> desc users;
   mysql> alter table users modify email varchar(128) ;
   mysql> desc users;
   
    
5. Exit MySQL and restart the backend service.