Vicidial VTIGER 503.Synchronize users with Issues.

[Travis Lambert]

I just started working on using VTIGER, that is with vicidialnow. I put the VTIGER information into VICIDIAL, and when I Synchronize users with Vtiger, I can no longer log into my VTIGER. I have tried the system user name and password, I have tried the extensions with the extensions password, and VITIGER, will not let me login. When I Synchronize it says:

Connected successfully
GROUP- ADMIN: 6

GROUP- FrontlineSales: 7

GROUP- CSD: 8

VDAD:
INSERT INTO vtiger_users SET user_name='VDAD',user_password='$1$VD$Q3Oh/be41YOYRjSO9h73A0',last_name='Outbound Auto Dial',is_admin='off',status='Inactive',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='6',roleid='H5';
INSERT INTO vtiger_users2group SET userid='6',groupid='6';
UPDATE vtiger_users_seq SET id='6';

admin: 1
UPDATE vtiger_users SET user_password='$1$ad$zfuBurifXpQk48FEllHYq1',last_name='Admin',is_admin='on',status='Active' where id='1';
UPDATE vtiger_user2role SET roleid='H2' where userid='1';
DELETE FROM vtiger_users2group WHERE userid='1' and groupid IN('7','8');
INSERT INTO vtiger_users2group SET userid='1',groupid='6';

705:
INSERT INTO vtiger_users SET user_name='705',user_password='$1$70$oBIlqVUxrXJs6GHXyYm7Q/',last_name='Mark Low',is_admin='off',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='7',roleid='H5';
INSERT INTO vtiger_users2group SET userid='7',groupid='7';
UPDATE vtiger_users_seq SET id='7';

706:
INSERT INTO vtiger_users SET user_name='706',user_password='$1$70$Z6B3K2kU1ugqLPhOCphl5/',last_name='Nick Mistakos ',is_admin='off',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='8',roleid='H5';
INSERT INTO vtiger_users2group SET userid='8',groupid='7';
UPDATE vtiger_users_seq SET id='8';

703:
INSERT INTO vtiger_users SET user_name='703',user_password='$1$70$hYfMfExCOJ.JDnTiByWiG/',last_name='Mike Lambert ',is_admin='on',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='9',roleid='H2';
INSERT INTO vtiger_users2group SET userid='9',groupid='6';
UPDATE vtiger_users_seq SET id='9';

704:
INSERT INTO vtiger_users SET user_name='704',user_password='$1$70$I4DUMaHbKPFKDvX2utG7c/',last_name='Collections',is_admin='off',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='10',roleid='H5';
INSERT INTO vtiger_users2group SET userid='10',groupid='6';
UPDATE vtiger_users_seq SET id='10';

710:
INSERT INTO vtiger_users SET user_name='710',user_password='$1$71$nO8zQDdBtV7oPM1SO49xe.',last_name='Travis IT Test',is_admin='on',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='11',roleid='H2';
INSERT INTO vtiger_users2group SET userid='11',groupid='6';
UPDATE vtiger_users_seq SET id='11';

0000:
INSERT INTO vtiger_users SET user_name='0000',user_password='$1$00$4LbfhgZFyx94p0zye9UIU.',last_name='Baisc Agent ',is_admin='off',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='12',roleid='H5';
INSERT INTO vtiger_users2group SET userid='12',groupid='7';
UPDATE vtiger_users_seq SET id='12';

708:
INSERT INTO vtiger_users SET user_name='708',user_password='$1$70$EV4MwXNre/HYxDXyTUiF./',last_name='Shawn Riley',is_admin='off',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='13',roleid='H5';
INSERT INTO vtiger_users2group SET userid='13',groupid='7';
UPDATE vtiger_users_seq SET id='13';

707:
INSERT INTO vtiger_users SET user_name='707',user_password='$1$70$3wRj3HFptLKqo3LWndGxt0',last_name='Carlos',is_admin='off',status='Active',date_format='yyyy-mm-dd',first_name='',reports_to_id='',description='',title='',department='',phone_home='',phone_mobile='',phone_work='',phone_other='',phone_fax='',email1='',email2='',yahoo_id='',signature='',address_street='',address_city='',address_state='',address_country='',address_postalcode='',user_preferences='',imagename='';
INSERT INTO vtiger_user2role SET userid='14',roleid='H5';
INSERT INTO vtiger_users2group SET userid='14',groupid='7';
UPDATE vtiger_users_seq SET id='14';

DONE

How due I log into my VTIGER? Thanks

[gardo]

You need to upgrade Vtiger and Vicidial to the latest versions. Vtiger is 5.1.0 and Vicidial is 2.2.1. The version of Vtiger that comes with the latest VicidialNOW distribution is quite old (5.0.3) and doesn't have the user synchronization feature with Vicidial. The upcoming release of VicidialNOW (hopefully last week of July or first week of August) will have out of the box integration between Vicidial and Vtiger.

[Travis Lambert]

Thanks Gardo, I just went ahead and installed the new version of VTIGER510. I upgraded to the newest VICIDIAL a few weeks back. See my problem with the Sync was that it would over write any existing user in VTIGERS password or somthing, even on the new one. so what I did was I stayed logged into the VTIGER during the sync, checked to see if the extension were listed in the user table, then went to my asterisk manager.conf and placed the extensions in and secret into the file, saved it reload asterisk, then went back over to VTIGER and made sure all the user extensions were pointed to the asterisk extensions in the manager.conf, logged out and was able to log back in. Everything seemed to work fine. Still testing it though.

One more question when I upgraded VICIDIAL, the old client would not work with the new upgraded VICIDIAL so I switched the directory for the agent to point to agc2, the agc2 works fine an good, my question is what happened to the cool orange GUI?, its all grey looking. I thought the orange was really cool.

Is there a way to custumise the agents dialer screen to your bussness needs, eather a way to rename the fields, or add new fields were it says Name/Address/Phone Number/Postal Code...etc..

Thanks guys the dialer is really cool.. Travis Lambert

[mflorell]

In SVN/trunk we have added custom fields, and you can rename the default fields as well.

[Travis Lambert]

Thanks Matt for letting me no that you can change the fields on vicidial's client interface. I downloaded the newest from svn/Trunk I thought anyways. What file due I need to edit, to make these changes?

Thanks Again Matt

[Travis Lambert]

Thanks Matt for letting me no that you can change the fields on vicidial's client interface. I downloaded the newest from svn/Trunk I thought anyways. What file due I need to edit, to make these changes?

Thanks Again Matt

[mflorell]

You do not edit a file, you enable custom fields in the Admin -> System Settings screen, which is also where you can rename default field names.

[Travis Lambert]

Thanks Matt
I will give that a try and get back with you to let you no how everything went.


Thanks
Travis Lambert

[Travis Lambert]

Ok Matt I am not seeing the custom fields option in the admin > system settings. I due see Enable Custom Dialplan Entry.

I am using version 2.2.1 am I using the SVN/Trunk version?


VERSION: 2.2.1-237
BUILD: 100510-2015

[mflorell]

No, that is not the SVN/trunk version.

http://wiki.vicidial.org/index.php/SVN:howto

[Travis Lambert]

Hey matt if I upgrade to the SVN/Trunk will I lose all my current VICIDIAL settings and campaigns? Or is there a way to back it up?

Thanks
Travis

[williamconley]

/usr/share/astguiclient

there is a backup script ... in fact there are lots of cool scripts in there with detailed usage information inside them.

there is an "UPGRADE.TXT" file in every download of vicidial. it details specifically how to upgrade.

you should run the backup FIRST. copy the data file from the backup OFF the machine. THEN begin the upgrade, which includes modifying your existing mysql database if necessary (in a separate step, look at the instructions).

so far, however, i have not had a backup or upgrade fail. The Vicidial Group has done a good job there.

[Travis Lambert]

Thanks William I will give it a shot. and get back to you guys. When I upgraded the last time I didn't lose anything I was just checking before I got into some thing harry carry.


Thanks
Travis Lambert

[Travis Lambert]

MySQL connect ERROR: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

this just happened out of no were, I simply restarted my machine and then this error message pops up. So I went to see if the mysql damon was running and its not. I suspect this error is due because it can not connect to the mysql database.

[williamconley]

i am guessing that this should be a different thread. not really related to the original post or the other posts that followed.

try rebooting again ... then post your entire configuration and start a new thread.