Some little questions

pbillx

Joined
Jul 6, 2009
Messages
6
Likes
0
Points
0
#1
Hello @all,
i have some little technical issues

I need to access the mysql from outside, this means not from localhost.
I need this because our interface is a windows software interface for the hospitality accessing the mysql cdr table.

If i try this:

use mysql;
CREATE USER pbillx IDENTIFIED BY 'pbillx';
GRANT ALL ON *.* TO 'pbillx';

i get the errormessage: table mysql.proc_priv does not exist

2. question:
i normaly use nano as text editor. it is not working. Which editor i can use?

Best regards

Fred Montero
PBillX
 

haamed

Joined
Jul 23, 2007
Messages
251
Likes
0
Points
0
#2
about editor, you can "vi" or "vim"
it is installed by default on linux centosB)
 

pbillx

Joined
Jul 6, 2009
Messages
6
Likes
0
Points
0
#3
Thank you for your info. I have resolved the problem by replacing the mysql database with the standard mysql database ( I have not touched asterisk and asteriskcdrdb).
Then you can add users for external access. Also you need to modify the my.cnf and add a entry: bind-address=<ip-of-foreign-machine>


Now it is working fine. Elastix is compatible to PBillX. For edit i use now winscp.

Best regards

Fred Montero
www.PBillX.com
 

vloose

Joined
Dec 2, 2008
Messages
64
Likes
0
Points
0
#4
I personally like vi, but if you like nano, install it. Probably something like "yum install nano.i386" should work.
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,981
Messages
131,060
Members
17,701
Latest member
angel695py
Top