Difference between revisions of "ROUNDCUBE"

From SPGC Document Wiki
Jump to: navigation, search
(→‎RC_user_name_contact_update)
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Support | System Support]]
 +
 
=='''Creating RC User'''==
 
=='''Creating RC User'''==
  
Line 22: Line 24:
  
 
> Click which department
 
> Click which department
−
 
 
=='''RC_user_name_contact_update'''==
 
=='''RC_user_name_contact_update'''==
 
CREATE TABLE roundcubemail.contacts_02132013 LIKE roundcubemail.contacts;
 
CREATE TABLE roundcubemail.contacts_02132013 LIKE roundcubemail.contacts;
Line 34: Line 35:
 
/* Update Usename*/
 
/* Update Usename*/
  
−
  UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD VERSION:3.0
+
  UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD  
 +
VERSION:3.0
 
N:Gamboa;Wilbert Mark; D.;;
 
N:Gamboa;Wilbert Mark; D.;;
 
FN:Wilbert Mark D. Gamboa
 
FN:Wilbert Mark D. Gamboa
Line 41: Line 43:
 
words = ' Marissa F. Venus cnc_ar_asst5@local.com'
 
words = ' Marissa F. Venus cnc_ar_asst5@local.com'
 
  WHERE email = 'audit_auditor6@local.com'
 
  WHERE email = 'audit_auditor6@local.com'
−
 
 
/*Robin Ramos*/
 
/*Robin Ramos*/
 
  UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD
 
  UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD
Line 86: Line 87:
 
words = ' e502ic@local.com'
 
words = ' e502ic@local.com'
 
  WHERE email = 'e502ic@local.com'
 
  WHERE email = 'e502ic@local.com'
−
 
−
 
  
 
   /*e310ic*/
 
   /*e310ic*/
Line 112: Line 111:
 
words = ' katrina a. quaron e495mo@local.com'
 
words = ' katrina a. quaron e495mo@local.com'
 
  WHERE email = 'e495mo@local.com'
 
  WHERE email = 'e495mo@local.com'
−
+
 
−
+
 
     /*e501ta*/
 
     /*e501ta*/
 
   SELECT * FROM roundcubemail.contacts WHERE email = 'e501ta@local.com'
 
   SELECT * FROM roundcubemail.contacts WHERE email = 'e501ta@local.com'
Line 131: Line 129:
 
SELECT * FROM roundcubemail.identities WHERE  
 
SELECT * FROM roundcubemail.identities WHERE  
 
UPDATE roundcubemail.identities SET email = 'sapcd13@local.com' WHERE user_id = '154'
 
UPDATE roundcubemail.identities SET email = 'sapcd13@local.com' WHERE user_id = '154'
−
 
  
 
mey_oebg_bill_sup
 
mey_oebg_bill_sup
Line 150: Line 147:
 
SELECT * FROM myclearance.`users` WHERE username = 'cgvasquez'
 
SELECT * FROM myclearance.`users` WHERE username = 'cgvasquez'
 
UPDATE myclearance.`users` SET active = 'N' WHERE username = 'cgvasquez'
 
UPDATE myclearance.`users` SET active = 'N' WHERE username = 'cgvasquez'
−
 
  
 
CREATE TABLE roundcubemail.contacts_06172013 LIKE roundcubemail.contacts;
 
CREATE TABLE roundcubemail.contacts_06172013 LIKE roundcubemail.contacts;
 
INSERT INTO roundcubemail.contacts_06172013 SELECT * FROM roundcubemail.contacts;
 
INSERT INTO roundcubemail.contacts_06172013 SELECT * FROM roundcubemail.contacts;
−
 
  
 
SELECT * FROM roundcubemail.contacts WHERE email = 'cgvasquez@local.com'
 
SELECT * FROM roundcubemail.contacts WHERE email = 'cgvasquez@local.com'
Line 166: Line 161:
 
mv maildir Mdir_old
 
mv maildir Mdir_old
 
cp -v -R /home/sap_mdc2/Maildir .
 
cp -v -R /home/sap_mdc2/Maildir .
−
 
  
 
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Line 177: Line 171:
 
SELECT * FROM myclearance.users_02012013 WHERE username IN ('e488sh','e488ic','e488ta','e488so','e488em','e488mo','e488ic2','e488asm2')
 
SELECT * FROM myclearance.users_02012013 WHERE username IN ('e488sh','e488ic','e488ta','e488so','e488em','e488mo','e488ic2','e488asm2')
  
 +
UPDATE myclearance.users SET `password` = MD5('init1234') WHERE username = 'e401ic'
  
−
 
+
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Support | System Support]]
−
UPDATE myclearance.users SET `password` = MD5('init1234') WHERE username = 'e401ic'
+

Latest revision as of 09:14, 1 September 2016

Main Page > Application Development Team > System Support

Creating RC User

Follow the steps below:

> OPEN 202.2.2.89/apps/myuser-util

> Input username and password.

> Click Add User

> Fill out the fields needed and then click save.

After creating the account be sure that the account was added to the addressbook for contact information of the newly created account. To do this:

> Go to roundcube.

> Use this user: Username : imail Password: useradmin > Next click the addressbook placed above the module.

> Click which department

RC_user_name_contact_update

CREATE TABLE roundcubemail.contacts_02132013 LIKE roundcubemail.contacts;

INSERT INTO roundcubemail.contacts_02132013 SELECT * FROM roundcubemail.contacts

SELECT * FROM roundcubemail.contacts WHERE email = 'audit_auditor6@local.com'

Wilbert Mark D. Gamboa

/* Update Usename*/ 

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N:Gamboa;Wilbert Mark; D.;; FN:Wilbert Mark D. Gamboa EMAIL;type=INTERNET;type=HOME:audit_auditor6@local.com END:VCARD',`name` = 'Marissa F. Venus',firstname = 'Marissa F.',surname = 'Venus', words = ' Marissa F. Venus cnc_ar_asst5@local.com' 

WHERE email = 'audit_auditor6@local.com'

/*Robin Ramos*/ 

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N:Acejo;Rafael;;; FN:Rafael Acejo EMAIL;type=INTERNET;type=HOME:audit_auditor6@local.com END:VCARD',`name` = 'Rafael Acejo',firstname = 'Rafael ',surname = 'Acejo', words = ' Rafael Acejo audit_auditor6@local.com' 

WHERE email = 'audit_auditor6@local.com'

/*e311asm*/ SELECT * FROM roundcubemail.contacts WHERE email = 'e311asm@local.com' 

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N: ; ;;; FN: EMAIL;type=INTERNET;type=HOME:e311asm@local.com END:VCARD',`name` = ,firstname = ,surname = , words = ' e311asm@local.com' 

WHERE email = 'e311asm@local.com'

/*e317sh*/
SELECT * FROM roundcubemail.contacts WHERE email = 'e317sh@local.com'

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N: ; ;;; FN: EMAIL;type=INTERNET;type=HOME:e317sh@local.com END:VCARD',`name` = ,firstname = ,surname = , words = ' e317sh@local.com' 

WHERE email = 'e317sh@local.com'

 /*e502ic*/
SELECT * FROM roundcubemail.contacts WHERE email = 'e502ic@local.com'

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N: ; ;;; FN: EMAIL;type=INTERNET;type=HOME:e502ic@local.com END:VCARD',`name` = ,firstname = ,surname = , words = ' e502ic@local.com' 

WHERE email = 'e502ic@local.com'

 /*e310ic*/
SELECT * FROM roundcubemail.contacts WHERE email = 'e310ic@local.com'

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N:Porras;Andrew ;;; FN:Andrew Porras EMAIL;type=INTERNET;type=HOME:e310ic@local.com END:VCARD',`name` = 'Andrew Porras',firstname = 'Andrew ',surname = 'Porras', words = ' andrew porras e310ic@local.com' 

WHERE email = 'e310ic@local.com'

  /*e495mo*/
SELECT * FROM roundcubemail.contacts WHERE email = 'e495mo@local.com'

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N:Quaron;Katrina ;A. ;; FN:Katrina A. Quaron EMAIL;type=INTERNET;type=HOME:e495mo@local.com END:VCARD',`name` = 'Katrina A. Quaron',firstname = 'Katrina ',surname = 'Quaron', words = ' katrina a. quaron e495mo@local.com' 

WHERE email = 'e495mo@local.com'

   /*e501ta*/
 SELECT * FROM roundcubemail.contacts WHERE email = 'e501ta@local.com'

UPDATE roundcubemail.contacts SET vcard = 'BEGIN:VCARD

VERSION:3.0 N:Foronda  ;Fiona Alyssa ;H. ;; FN:Fiona Alyssa H. Foronda EMAIL;type=INTERNET;type=HOME:e501ta@local.com END:VCARD',`name` = 'Fiona Alyssa H. Foronda ',firstname = 'Fiona Alyssa ',surname = 'Foronda ', words = ' fiona alyssa h. foronda e501ta@local.com' 

WHERE email = 'e501ta@local.com'

Update Email Identities

SELECT * FROM myclearance.users WHERE username = 'mey_oebg_bill_sup'

SELECT * FROM roundcubemail.identities WHERE UPDATE roundcubemail.identities SET email = 'sapcd13@local.com' WHERE user_id = '154'

mey_oebg_bill_sup

Update Quata Per User

SELECT * FROM myclearance.`users` WHERE username = 'rmdessi11'


UPDATE myclearance.users SET quota = '3400' WHERE username = 'rmdessi11'

UPDATE myclearance.users SET PASSWORD = MD5('init1234') WHERE username = 'ragarfin' UPDATE myclearance.users SET PASSWORD = '8b686d7b4302b99d6c2c8e939ed6832a' WHERE username = 'ragarfin'


8b686d7b4302b99d6c2c8e939ed6832a

Deactivate an Account

SELECT * FROM myclearance.`users` WHERE username = 'cgvasquez' UPDATE myclearance.`users` SET active = 'N' WHERE username = 'cgvasquez'

CREATE TABLE roundcubemail.contacts_06172013 LIKE roundcubemail.contacts; INSERT INTO roundcubemail.contacts_06172013 SELECT * FROM roundcubemail.contacts;

SELECT * FROM roundcubemail.contacts WHERE email = 'cgvasquez@local.com' DELETE FROM roundcubemail.contacts WHERE email = 'cgvasquez@local.com'

Transfer email to a new created acount

cd /home cd /sap_is1 ls Maildir mv maildir Mdir_old cp -v -R /home/sap_mdc2/Maildir .

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

chown -R -v sap_is2:users Maildir

Update Password

/*reseting/updating password*/

INSERT INTO myclearance.users SELECT * FROM myclearance.users_02012013 WHERE username IN ('e488sh','e488ic','e488ta','e488so','e488em','e488mo','e488ic2','e488asm2')

UPDATE myclearance.users SET `password` = MD5('init1234') WHERE username = 'e401ic'

Main Page > Application Development Team > System Support

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=ROUNDCUBE&oldid=3942"