"Sorry, you are not allowed to login to this campaign"...

Any and all non-support discussions

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

"Sorry, you are not allowed to login to this campaign"...

Postby ScissorHill » Tue Jan 17, 2017 2:07 pm

Hello all,

System configuration:

  • Vicidial VERSION: 2.11-476a
  • BUILD: 150302-0945
  • Asterisk 1.8.32.3
  • CentOS 6.6
  • Linux Kernel 2.6.32-642.1.1.el6.x86_64
(That's all the info I have access to at the moment - apologies if I've missed something pertinent, and please let me know how to get that from CLI!)

The system was working fine until a while ago. Suddenly, newly added users are seeing the
Sorry, you are not allowed to login to this campaign: <campaign id>
error message. Searching the forum reveals that this is most commonly encountered after an upgrade, but no upgrade has happened of late.

Any kind of help in resolving this issue, and suggestions how to avoid it, would be much appreciated. Thanks in advance...!
ScissorHill
 
Posts: 6
Joined: Fri Jan 13, 2017 6:26 am

Re: "Sorry, you are not allowed to login to this campaign"..

Postby mflorell » Tue Jan 17, 2017 4:38 pm

Could be a crashed table or just a permission change in their User Groups setting.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: "Sorry, you are not allowed to login to this campaign"..

Postby ScissorHill » Tue Jan 17, 2017 8:43 pm

Thanks! I should have mentioned earlier: users are being added through the add_user API call. So it's unlikely to be something to do with User Group settings.

If it's a crashed table, any pointers on how it could be diagnosed and repaired - safely?
ScissorHill
 
Posts: 6
Joined: Fri Jan 13, 2017 6:26 am

Re: "Sorry, you are not allowed to login to this campaign"..

Postby mflorell » Wed Jan 18, 2017 8:16 am

try running this script:

# /usr/share/astguiclient/AST_DB_check_tables.pl --help
allowed run time options:
[--quick] = run test in QUICK mode, may not catch all issues
[--email-list=test.com:test2.com] = send email results to these addresses
[--email-sender=vicidial] = sender for the email results
[--test] = test
[--quiet] = quiet
[--debug] = verbose debug messages
[--debugX] = extra verbose debug messages
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: "Sorry, you are not allowed to login to this campaign"..

Postby BoydSmith » Sun Jan 22, 2017 1:47 am

Thanks for the script mflorell, worked perfectly.
Last edited by BoydSmith on Fri Dec 01, 2023 5:15 pm, edited 6 times in total.
BoydSmith
 
Posts: 1
Joined: Sat Jan 21, 2017 3:59 am

Re: "Sorry, you are not allowed to login to this campaign"..

Postby ScissorHill » Tue Jan 24, 2017 1:42 pm

Sorry for the delay in responding, mflorell...!

I can't find the AST_DB_check_tables.pl script under /usr/share/astguiclient. Is this something that's available in a later version (as mentioned above, this server has Vicidial VERSION: 2.11-476a, BUILD: 150302-0945).

If so, would it suffice to download just this one script and run it?

I've been trying to reproduce this issue. It seems to be intermittent, and thus tricky.
Thanks once again.
ScissorHill
 
Posts: 6
Joined: Fri Jan 13, 2017 6:26 am

Re: "Sorry, you are not allowed to login to this campaign"..

Postby mflorell » Tue Jan 24, 2017 2:10 pm

Just upgrade to the most recent svn/trunk version and it will be there.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: "Sorry, you are not allowed to login to this campaign"..

Postby ScissorHill » Wed Jan 25, 2017 4:54 am

mflorell wrote:Just upgrade to the most recent svn/trunk version and it will be there.


I understand it makes sense to upgrade to the latest version, but this might take a while, as it's a production server right now. Question: if I were to just copy this script from the SVN checkout and run it on the server, would it be a bad idea?

Also, I find that the error occurs every time a new user is created. It disappears as soon as I go to the newly created user's user group, and just hit 'submit' without actually changing anything...! Which is actually a bit concerning.

Any help in this regard would be appreciated.
ScissorHill
 
Posts: 6
Joined: Fri Jan 13, 2017 6:26 am

Re: "Sorry, you are not allowed to login to this campaign"..

Postby williamconley » Mon Feb 27, 2017 2:12 am

Code: Select all
mysql asterisk -e "show table status where comment like '%crashed%'" --user=cron -p1234


If it identifies a crashed table, substitute that table for this one:
Code: Select all
mysqlcheck --auto-repair  --user=cron -p1234 asterisk vicidial_log_extended


Check ALL tables (after hours):
Code: Select all
mysqlcheck --all-databases --auto-repair --user=cron -p1234
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 64 guests