phone login and password not active

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

phone login and password not active

Postby THUFIR » 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
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm

Re: phone login and password not active

Postby DomeDan » Mon Feb 16, 2015 3:33 am

you're not mixing up phone "Login Password" with phone "Registration Password"?
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: phone login and password not active

Postby THUFIR » 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!
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm

Re: phone login and password not active

Postby DomeDan » 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?
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: phone login and password not active

Postby THUFIR » 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?
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm

Re: phone login and password not active

Postby DomeDan » 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
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: phone login and password not active

Postby THUFIR » 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 :)
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm

Re: phone login and password not active

Postby THUFIR » 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.)
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm

Re: phone login and password not active

Postby DomeDan » 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
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: phone login and password not active

Postby THUFIR » 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.
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm

Re: phone login and password not active

Postby DomeDan » 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 ;)
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: phone login and password not active

Postby THUFIR » 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 :)
ViciBox Redux v.6.0.3-141118 from .iso | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | AMD Phenom(tm) II X6 1090T Processor | 8GiB RAM
THUFIR
 
Posts: 109
Joined: Fri May 02, 2014 10:46 pm


Return to Support

Who is online

Users browsing this forum: Majestic-12 [Bot] and 42 guests