How to access to Elastix's mysql from outside

kalderista

Joined
Oct 21, 2008
Messages
179
Likes
0
Points
0
#1
I will apreciate any information for this issue. I want to access to the mysql database of elastix from a worksation. I'm trying to conect a report manager but I have no idea what parameters I need.

I'm trying to connectto it but it seems it's not allowed in elastix distribution by default.

Any idea? Documentation?

Thanx
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#2
The documentation is all at mysql:

http://dev.mysql.com/doc/

your version is:

mysql -V

basically you need to add a user with as little permissions as possible with access to as few tables as necessary, then allow tcp 3306 through your firewall.
 

kalderista

Joined
Oct 21, 2008
Messages
179
Likes
0
Points
0
#3
But do I have to configure "bind-address = 0.0.0.0" somewhere?
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#4
I don't understand your question, bind-address of "what" to "everywhere" ?
 

kalderista

Joined
Oct 21, 2008
Messages
179
Likes
0
Points
0
#5
I mean,

is there any conf file lyke my.conf hwere I have to allow external connections? is it allowed by default? Just set permissions on database user?

Thanx dicko!
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#6
The user you will create to make the connection will have the permission to access your box from wherever you give that user permission to do so and with whatever permissions you give him, (provided your router allows that access), just try the mysql documentation. you will find it very informative.

By default the only account is root from localhost (127.0.0.1) I suggest you do not under any circumstances expand the privileges of that account

dicko
 

apmuthu

Joined
Aug 1, 2009
Messages
60
Likes
0
Points
0
#7
Use phpMyAdmin (browser based access) or for Windows based access use SQLyog (www.webyog.com) and upload their tunnel file or use SSH access method and access the MySQL DB even as root!
 

kalderista

Joined
Oct 21, 2008
Messages
179
Likes
0
Points
0
#8
I've tried it and it works, thank you.

Anyway, it should be nice to connect to the DB from the LAN...
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#9
That's why and when you create an account with well considered permissions.

be careful of phpmyadmin, if you're not aware of it's intrinsic security issues check your http/*_error_log s for drive-by attempts at that web directory (or one like it), If you do use it please read their own documentation as to securing it. Presenting the mysql root user on a web page open to anyone is a trainwreck waiting to happen.

JM2CWAE
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,902
Messages
130,886
Members
17,563
Latest member
dineshr
Top