Mysql error

[mac123]

need help please.. having problem with my vicidial ver 2.6-393a, cant log in to admin page, already check mysqld tables username and password is match, but still cant log in to admin page, in agent log in, I cant see any campaign., can anyone already encountered this problem?.. Thank You

Invalid Username/Password: |admin|Epho3n1x|

+---------------+---------------+-----------------+---------------+-----------------+------------------+-------------------+------------+------------+-----------------------+-----------------+------------------------+----------------------+-----------------------+-----------------+-----------------------+
| 42 | admin | Epho3n1x | IT | 9 | ADMIN | | | 1 | 1 | 1 | 1

[williamconley]

1) Welcome to the Party!

2) when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) Perhaps the user is not active.

Code: Select all

mysql asterisk -u cron -p1234 -e "select user,pass,user_level,active from vicidial_users where user_level='9'"

[mac123]

here's my server info....

Processor
MemTotal: 3944384 kB
Handle 0x0002, DMI type 2, 8 bytes
Base Board Information
Manufacturer: REDFOX Technologies
Product Name: N61PB-M2S


VERSION: 2.6-393a
BUILD: 130124-1721


we already use this server, but after i change the my public ip address that problem starts.. I cant log in all user that is active. thanks

Code: Select all

+-----------+----------+------------+--------+
| user      | pass     | user_level | active |
+-----------+----------+------------+--------+
| 6666      | Epho3n1x |          9 | Y      |
| rod_admin | admin    |          9 | Y      |
| admin     | Epho3n1x |          9 | Y      |
+-----------+----------+------------+--------+

[modified for legibility - williamconley]

[williamconley]

did you run the script:

Code: Select all

To change the server IP in the database type:
/usr/share/astguiclient/ADMIN_update_server_ip.pl

Also worthy of note: You did not list your installer version or your asterisk version or whether you added any software after the installation. You did list your motherboard, which is very cool.

Consider trying to fill in the blanks in this line, and possibly putting it in your signature (it only takes a couple clicks ...):

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

Also: are you trying to log in as an agent or to the administration panel?

[mac123]

sory for that. here's the details

Vicibox X.X from .iso | Vicidial 2.6-393a Build 130124-1721 | Asterisk Asterisk 1.4.44-| Single Server | No Digium/Sangoma Hardware | No Extra Software After install... cant find Vicibox iso version. this server is 2 running for about 3 years i dunno what version of the installer use im new here in vicidial

tried to run this script /usr/share/astguiclient/ADMIN_update_server_ip.pl

but iget an error


STARTING DATABASE TABLES UPDATES PHASE...
DBI connect('::3306','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389
Couldn't connect to database: Access denied for user 'root'@'localhost' (using password: NO) at /usr/share/astguiclient/ADMIN_update_server_ip.pl line 389, <STDIN> line 7.

[williamconley]

OK: So you do not know what method was used to build the server. Did you have someone else build the server or sell you one?

As a rule, when you run the admin update server ip script, it is expected to automatically acquire database credentials from /etc/astguiclient.conf

Please check inside this file for your DB credentials and see if something is "wrong". You should be able to log in to the MySQL server using the credentials in that file:

Code: Select all

mysql asterisk -u {USER} -p{PASS}

mysql = name of database program we are starting
asterisk = name of database in which we ordinarily keep our data (that can be changed, but honestly I've only seen it named something other than asterisk once in six years)
-u = a switch meaning "the next item is my user name"
{USER} = example: cron (without the { } curly brackets, of course)
-p = a switch meaning "the next items is my password"
{PASS} = example: 1234 (also without the { } curly brackets, but also NO SPACE between the "-p" and the "1234"!!

final example:

Code: Select all

mysql asterisk -u cron -p1234

In many cases, by the way, cron and 1234 should be the entries. If your astguiclient.conf files has other values ... consider trying cron and 1234 for user and pass to see if that fixes a few things.

Next: If you did not build this system, is it possible you have (in some unknown fashion) annoyed the IT person who built it, causing him/her to lock you out?

If so, you may want to build a new server (start with the .iso and instructions at Vicibox.com ... it is MUCH easier than it used to be, thanks to Kumba's hard work, it can actually be installed by almost anyone!)

[mac123]

i know the password of mysql its admin.. but how can i enter the password when i run this script /usr/share/astguiclient/ADMIN_update_server_ip.pl also i tried to log-in as ucron and 1234 in mysql.. and it is acessible

we built the system but the .iso is missing and i forgot what is the version of the installer.. i cant built a new due to recordings and sql reports i need it.. thats why i need to repair this server, also tried to access phpMyAdmin ... tried to edit user admin for credentials. but still i cant log in to admin page. using those credential..

[williamconley]

the update script gets its credentials from the file i mentioned earlier. if those cred's are wrong, it will fail.

so check /etc/astguiclient.conf and see if those creds are wrong. that's the basic cred file for vicidial, without it ... everything fails.

[mac123]

Thank you.. problem solved... my /etc/astguiclient.conf has an Empty records,, i wonder why it is happen... by the way thank you.....

[williamconley]

Could be you installed from an earlier vicidialnow or goautodial. That has happened on a few boxes (and sent us several clients ... as a result). We prefer Vicibox.com's .iso (unless you NEED CentOS). ... it has been tested by significantly more users.

[mac123]

if im not mistaken that is vicibox and update to a new version.. with open suse OS, this server is running before just only happen when i change our public ip address.

[mac123]

another issue.... hehehe.. this is my back up server can you check why my realtime reports is like this? no agent name lack of information...... thanks in advance

SESSIONID | STATUS | MM:SS | CAMPAIGN | CALLS | HOLD | IN-GROUP
+-----------+----------+---------+------------+-------+------+------------------
| 8600068 | READY | 0:01 | CAMP_001 | 190 |
| 8600066 | READY | 0:00 | CAMP_001 | 141 |
| 8600061 | PARK A | 7:26 | CAMP_001 | 121 |
| 8600058 | INCALL A | 6:15 | CAMP_001 | 126 |
| 8600062 | INCALL A | 0:50 | CAMP_001 | 799 |
| 8600064 | INCALL M | 0:33 | CAMP_003 | 132 |
| 8600052 | INCALL M | 0:32 | CAMP002 | 137 |
| 8600053 | INCALL M | 0:20 | CAMP002 | 198 |
| 8600056 | INCALL A | 0:13 | CAMP_001 | 179 |
| 8600063 | INCALL A | 0:08 | CAMP_001 | 131 |
| 8600051 | INCALL M | 0:04 | CAMP002 | 192 |
| 8600065 | PAUSED | 228:53 | CAMP_003 | 0 |
| 8600060 | PAUSED | 0:40 | CAMP_003 | 147 |
| 8600057 | PAUSED | 0:49 | CAMP_003 | 77 |
+-----------+----------+---------+------------+-------+------+------------------

[williamconley]

whenever you change your ip it is possible to break the ip during the ip update script ... but we've never found the bug (or proven that there technically is one, because we cannot ever dupe the problem ... just that an occasional client has this issue). so ... next time, look there first

your permissions (for your user, under users) have been modified to exclude your permission to see this data. it has been blocked. if you modify your user, you will see it.

Search for "block" on your user page.

[mac123]

Alright Thanks....


Hmmmm all angents(Users) Realtime Block User Info is set to zero....? is it a bug? or something thanks

[williamconley]

i'm not sure why you are checking "all" agents. it affects only the user viewing the page. ie: YOU. The user you have logged in as is the one who cannot see the data. So that user likely has "blocked". Not any others. The block command does not stop others from seeing this user ... it blocks THIS user from viewing the information. LOL.

[mac123]

Thanks to all you already saw the complete info..

thanks for this thread

viewtopic.php?t=20083