vicidial.org

Posted: **Sun Feb 15, 2015 9:49 pm**

When I try to login "thufir" and "thufirphone" I get:

Code: Select all: Sorry, your phone login and password are not active in this system, please try again:

phones and users:

Code: Select all: MariaDB [asterisk]> MariaDB [asterisk]> select user_id, user, user_level, user_group, phone_login, active from vicidial_users; +---------+--------------+------------+------------+-------------+--------+ | user_id | user | user_level | user_group | phone_login | active | +---------+--------------+------------+------------+-------------+--------+ | 1 | 6666 | 9 | ADMIN | | Y | | 2 | VDAD | 1 | ADMIN | NULL | N | | 3 | VDCL | 1 | ADMIN | NULL | N | | 8 | thufir_hawat | 1 | AGENTS | thufirphone | Y | +---------+--------------+------------+------------+-------------+--------+ 4 rows in set (0.00 sec) MariaDB [asterisk]> MariaDB [asterisk]> select login, extension, fullname, pass, status from phones; +-------------+-----------+---------------------+----------+--------+ | login | extension | fullname | pass | status | +-------------+-----------+---------------------+----------+--------+ | gs102 | gs102 | Test Admin Phone | test | ADMIN | | callin | callin | Dial-in Agent Phone | test | ACTIVE | | misc_phone | 201 | sip201 | password | ACTIVE | | thufirphone | thufir101 | atreides | password | ACTIVE | +-------------+-----------+---------------------+----------+--------+ 4 rows in set (0.00 sec) MariaDB [asterisk]>

I'm following the managers manual. I grabbed the svn repo for the sample data, and imported it (I think) into the database correctly with the web interface:

Code: Select all: MariaDB [asterisk]> MariaDB [asterisk]> select lead_id, entry_date, modify_date, status, user, vendor_lead_code, source_id, list_id, phone_number, alt_phone, email from vicidial_list; +---------+---------------------+---------------------+--------+------+------------------+-----------+---------+--------------+------------+---------------+ | lead_id | entry_date | modify_date | status | user | vendor_lead_code | source_id | list_id | phone_number | alt_phone | email | +---------+---------------------+---------------------+--------+------+------------------+-----------+---------+--------------+------------+---------------+ | 1 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 2 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 3 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 4 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 5 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 6 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 7 | NULL | 2015-02-13 08:45:03 | NEW | NULL | NULL | NULL | 101 | 7275551212 | NULL | test@test.com | | 8 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100001 | 10001 | 107 | 7275551213 | 7275551212 | test@test.com | | 9 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100002 | 10002 | 107 | 7275551213 | 7275551212 | test@test.com | | 10 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100003 | 10003 | 107 | 7275551213 | 7275551212 | test@test.com | | 11 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100004 | 10004 | 107 | 7275551213 | 7275551212 | test@test.com | | 12 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100005 | 10005 | 107 | 7275551213 | 7275551212 | test@test.com | | 13 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100006 | 10006 | 107 | 7275551213 | 7275551212 | test@test.com | | 14 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100007 | 10007 | 107 | 7275551213 | 7275551212 | test@test.com | | 15 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100008 | 10008 | 107 | 7275551213 | 7275551212 | test@test.com | | 16 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100009 | 10009 | 107 | 7275551213 | 7275551212 | test@test.com | | 17 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100010 | 10010 | 107 | 7275551213 | 7275551212 | test@test.com | | 18 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100011 | 10011 | 107 | 7275551213 | 7275551212 | test@test.com | | 19 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100012 | 10012 | 107 | 7275551213 | 7275551212 | test@test.com | | 20 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100013 | 10013 | 107 | 7275551213 | 7275551212 | test@test.com | | 21 | 2015-02-13 10:11:29 | 0000-00-00 00:00:00 | NEW | | 100014 | 10014 | 107 | 7275551213 | 7275551212 | test@test.com | | 22 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100001 | 10001 | 107 | 7275551213 | 7275551212 | test@test.com | | 23 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100002 | 10002 | 107 | 7275551213 | 7275551212 | test@test.com | | 24 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100003 | 10003 | 107 | 7275551213 | 7275551212 | test@test.com | | 25 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100004 | 10004 | 107 | 7275551213 | 7275551212 | test@test.com | | 26 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100005 | 10005 | 107 | 7275551213 | 7275551212 | test@test.com | | 27 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100006 | 10006 | 107 | 7275551213 | 7275551212 | test@test.com | | 28 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100007 | 10007 | 107 | 7275551213 | 7275551212 | test@test.com | | 29 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100008 | 10008 | 107 | 7275551213 | 7275551212 | test@test.com | | 30 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100009 | 10009 | 107 | 7275551213 | 7275551212 | test@test.com | | 31 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100010 | 10010 | 107 | 7275551213 | 7275551212 | test@test.com | | 32 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100011 | 10011 | 107 | 7275551213 | 7275551212 | test@test.com | | 33 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100012 | 10012 | 107 | 7275551213 | 7275551212 | test@test.com | | 34 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100013 | 10013 | 107 | 7275551213 | 7275551212 | test@test.com | | 35 | 2015-02-13 10:12:43 | 0000-00-00 00:00:00 | NEW | | 100014 | 10014 | 107 | 7275551213 | 7275551212 | test@test.com | +---------+---------------------+---------------------+--------+------+------------------+-----------+---------+--------------+------------+---------------+ 35 rows in set (0.00 sec) MariaDB [asterisk]> MariaDB [asterisk]> select list_id, list_name, campaign_id from vicidial_lists; +---------+----------------------+-------------+ | list_id | list_name | campaign_id | +---------+----------------------+-------------+ | 999 | Default inbound list | TESTCAMP | | 998 | Default Manual list | TESTCAMP | | 101 | dummy_list | dummy | | 107 | test list | TESTCAMP | +---------+----------------------+-------------+ 4 rows in set (0.00 sec) MariaDB [asterisk]>

How do I get the user to login? I'm going through the manual again and reading through old forum posts; but have already checked that passwords and user names align. See also:

http://wiki.vicidial.org/index.php/VICI ... _try_again

Could this be a result of:

Code: Select all: tleilax*CLI> tleilax*CLI> sip show peers Name/username Host Dyn Forcerport ACL Port Status 201/201 (Unspecified) D N 0 UNKNOWN babytel/<private> 198.38.7.11 D N 5060 UNKNOWN gs102/gs102 (Unspecified) D N 0 UNKNOWN thufir101/thufir101 (Unspecified) D N 0 UNKNOWN 4 sip peers [Monitored: 0 online, 4 offline Unmonitored: 0 online, 0 offline] tleilax*CLI>

or the VOIP client config??

ViciBox Redux v.6.0.3-141118

Posted: **Mon Feb 16, 2015 3:33 am**

you're not mixing up phone "Login Password" with phone "Registration Password"?

Posted: **Mon Feb 16, 2015 4:25 am**

Pretend I'm an idiot, and that I am mixing them up, and that I'm right now referencing the manual and double checking...

and here's what I found:

Code: Select all: MariaDB [asterisk]> MariaDB [asterisk]> select login, extension, pass, status, active, phone_type, login_user, login_pass from phones; +-------------+-----------+----------+--------+--------+---------------------+------------+------------+ | login | extension | pass | status | active | phone_type | login_user | login_pass | +-------------+-----------+----------+--------+--------+---------------------+------------+------------+ | gs102 | gs102 | test | ADMIN | Y | Grandstream BT 102 | NULL | NULL | | callin | callin | test | ACTIVE | Y | Dial-in agent phone | NULL | NULL | | misc_phone | 201 | password | ACTIVE | Y | SIP | | | | thufirphone | thufir101 | password | ACTIVE | Y | dummy | | | +-------------+-----------+----------+--------+--------+---------------------+------------+------------+ 4 rows in set (0.01 sec) MariaDB [asterisk]>

However, when I look in the Administration GUI, I checked that I just have password "password" across the board. So, to that specific question, no, because all the passwords are "password" for that very reason. However, that seems a strange result set above; login_user isn't populated!

Posted: **Mon Feb 16, 2015 4:45 am**

it looks ok

conf_secret is the column for "Registration Password"

So if you use this: /agc/vicidial.php?relogin=YES&phone_login=thufirphone&phone_pass=password

then you get the message: "Sorry, your phone login and password are not active in this system, please try again" right?

Posted: **Mon Feb 16, 2015 2:16 pm**

That's quite interesting, what you can do with the URL's. Yes, same error:

http://picpaste.com/vici.png

is there a log of that login error, perhaps?

Posted: **Tue Feb 17, 2015 2:56 am**

make sure you're not mixing uppercase and lowercase characters in the username
is "thufir" lowercase in the agent list?

upgrade to the latest svn revision, matt recently patched that issue (if that's your case)

try to allow all campaigns temporary for the user group too

Posted: **Wed Feb 18, 2015 9:29 am**

I have to upgrade svn yet. However, I was in asterisk, just learning the CLI, and see:

Code: Select all: tleilax*CLI> tleilax*CLI> sip show users Username Secret Accountcode Def.Context ACL Forcerport 201 password 201 default No Yes thufir101 password thufir101 default No Yes babytel fdlfjdslk; default No Yes gs102 X58sKpZCcDfcGT0 gs102 default No Yes tleilax*CLI>

which is interesting. That seems to be saying that the user is thufir101, and not, as I've been thinking, thufir...?

copy/paste plus I filled in some gaps, from the admin GUI:

Code: Select all: User Number: thufir_hawat HELP Password: password HELP Strength: Force Change Password: HELP Last Login Info: 2015-02-15 22:19:27 - 0 - 192.168.1.2 HELP Full Name: thufir HELP User Level: HELP User Group: HELP Phone Login: thufirphone HELP Phone Pass: HELP

Just thought that was interesting. Also:

Code: Select all: tleilax:/etc/asterisk # tleilax:/etc/asterisk # cat sip-vicidial.conf ; WARNING- THIS FILE IS AUTO-GENERATED BY VICIDIAL, ANY EDITS YOU MAKE WILL BE LOST register => babytel:test@10.10.10.16:5060 ; VICIDIAL Carrier: BABYTEL - babytel ; free trial [babytel] disallow=all allow=ulaw type=friend username=1234567890 secret=hjhkl8557685 host=sip.babytel.ca dtmfmode=rfc2833 context=trunkinbound type=friend host=dynamic canreinvite=no context=default [201] username=201 secret=password accountcode=201 callerid="sip201" <234567890> mailbox=201 type=friend host=dynamic canreinvite=no context=default [gs102] username=gs102 secret=X58sKpZCcDfcGT0 accountcode=gs102 callerid="Test Admin Phone" <> mailbox=102 context=default type=friend host=dynamic [thufir101] username=thufir101 secret=password accountcode=thufir101 callerid="atreides" <123> mailbox=123 context=default type=friend host=dynamic ; END OF FILE Last Forced System Reload: 2015-02-13 08:45:03 tleilax:/etc/asterisk #

took me a little while to find that, but it's nice to know where those files are, at least

Posted: **Thu Feb 19, 2015 2:13 am**

DomeDan wrote:make sure you're not mixing uppercase and lowercase characters in the username
is "thufir" lowercase in the agent list?

upgrade to the latest svn revision, matt recently patched that issue (if that's your case)

try to allow all campaigns temporary for the user group too

I logged in with user "123" and phone "123" with all passwords of "password" -- phew. Success!

I'm not quite sure that I upgraded the db correctly, but I did upgrade the svn trunk and followed other directions.

Thanks for letting me bounce around. I'm going to try some other logins and see how that goes. (And, the hopper was empty, but that's different thing.)

Posted: **Thu Feb 19, 2015 2:36 am**

User Number: thufir_hawat

thufir_hawat is your user login not thufir.

about the db, if you are on for example version 2.8-425a, then you should run the scripts upgrade_2.8.sql and upgrade_2.10.sql to make all the necessary changes to the database

Posted: **Thu Feb 19, 2015 3:30 am**

ok. thank you. random question: how do I delete a phone through ViciDial? I'm trying to update the phone list to make it a bit more rational.

Posted: **Thu Feb 19, 2015 5:43 am**

At the bottom of the page where you edit a phone there is a link called "DELETE THIS PHONE"

it feels like you should take a look at the manager manual or read it again if you have it

Posted: **Fri Feb 20, 2015 6:04 am**

Well, veering off topic. For some reason user 6666 didn't have

Code: Select all: AGC Admin Access

enabled to delete phone...fixed.

In any event, thank you for the help

vicidial.org

phone login and password not active

phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active

Re: phone login and password not active