MySQL connect ERROR:

Any and all non-support discussions

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

MySQL connect ERROR:

Postby ruben23 » Thu Feb 20, 2014 7:03 am

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
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: MySQL connect ERROR:

Postby DomeDan » Thu Feb 20, 2014 8:44 am

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.
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: MySQL connect ERROR:

Postby ruben23 » Thu Feb 20, 2014 11:41 am

@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"
Last edited by ruben23 on Fri Feb 21, 2014 10:27 am, edited 1 time in total.
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: MySQL connect ERROR:

Postby DomeDan » Fri Feb 21, 2014 4:34 am

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
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


Return to General Discussion

Who is online

Users browsing this forum: njr and 40 guests