Page 1 of 1

MySQL connect ERROR:

PostPosted: Thu Feb 20, 2014 7:03 am
by ruben23
Hi guys,

I have just recently installed latest trunk version of Vicidial:

Version:2.8b0.5
SVN Version: 0
DB Schema Version: 1368
DB Schema Update Date: 2014-02-09 21:01:05
ASterisk 1.8-vici

Unusual thing is when i add users and usergroup upon submit i get this display on screen : USER MODIFIED - ADMIN: JanessaF MySQL connect ERROR: (sample user i add)

same thing on usergroup but when i double check the user and usergroup was addedd somehow successfully with no issue, i just get this display error every time i submit.Any idea guys..? Thanks

Re: MySQL connect ERROR:

PostPosted: Thu Feb 20, 2014 8:44 am
by DomeDan
Post your
admin build.
Install method.
the data entered into the fields when adding the new user
and the last lines of apache access_log when the error occur.

Re: MySQL connect ERROR:

PostPosted: Thu Feb 20, 2014 11:41 am
by ruben23
@DomeDan,

Admin build. <---------- What is this..?

Install Method : Scratch Install - Ubuntu Server 12.04 LTS 64bit
Data entered on the field:
- user ID : LouieE
- pass: photogroup
- Name: Louie
- Level: 1
- Usegroup: AGENT (Then Submit)

Apache_access_log

Code: Select all
- Technical [20/Feb/2014:11:39:43 -0500] "GET /vicidial/admin.php?ADD=0A HTTP/1.1" 200 4079 "http:///vicidial/admin.php" "Mozilla/5.0 (Windows NT 6.1; rv:27.0) Gecko/20100101 Firefox/27.0"
 - Technical [20/Feb/2014:11:40:33 -0500] "GET /vicidial/admin.php?ADD=3&user=LouieE HTTP/1.1" 200 6895 "http:///vicidial/admin.php?ADD=0A" "Mozilla/5.0 (Windows NT 6.1; rv:27.0) Gecko/20100101 Firefox/27.0"
 - Technical [20/Feb/2014:11:40:38 -0500] "POST /vicidial/admin.php HTTP/1.1" 200 3157 "http://xxxx.xxx.xxx.xx/vicidial/admin.php?ADD=3&user=LouieE" "Mozilla/5.0 (Windows NT 6.1; rv:27.0) Gecko/20100101 Firefox/27.0"

Re: MySQL connect ERROR:

PostPosted: Fri Feb 21, 2014 4:34 am
by DomeDan
the admin build can be found on the left bottom side of many pages in the admin interface, like this:
VERSION: 2.8-425a
BUILD: 140206-1357
© 2014 ViciDial Group


Post the last rows of the table: vicidial_admin_log after the error occur
the important column is event_sql so I need all text from that column, so if you use phpmyadmin then you need to select: "Options -> Full texts"
it might contain ip-addresses and passwords that you can replace with XXX YYY or something, there is some ip-addresses in your previous post that you might want to remove