Page tree
Skip to end of metadata
Go to start of metadata

 

Problem "Access Denied"


A MySQL error occurs when the function "Extract all rows" is used. 


Solution

Allow the MySQL user "xcall" to export data into a file in your mysql instance.

Open the SSH console to xCally server and connect to mysql console:

mysql –u root –p(root password)
GRANT FILE ON *.* TO 'xcall'@'localhost' identified by 'xcall1234';
GRANT FILE ON *.* TO 'xcall'@'%' identified by 'xcall1234';
FLUSH PRIVILEGES;

end restart the httpd service

service httpd restart

Problem secure-file-priv option 

The following MySQL error is displayed when you use the extract all rows function:




Solution

edit the file /etc/my.cnf and add the folliowng row under [mysqld] section:

[mysqld]
secure-file-priv = ""

and restart the mysqld service

service mysqld restart


Important

Stop all the callcenter activities before restarting the MySQL service.