Page 1 of 1

mySQL and MS Sql linked server

PostPosted: Wed Jul 04, 2012 8:28 pm
by Bobking
Hi All

I'm experimenting with mySQL and wanting to update some data through ms sql as a linked server, has anyone had any experience with this. I seem to be getting errors that indicate the user doesn't have permission yet I'm using the osdial user with osdial1234.

Can anyone shed any light as to what could be going wrong or point me to a site that shows how to do this.

Thank you all in advance.

Bob.

Re: mySQL and MS Sql linked server

PostPosted: Thu Jul 05, 2012 11:18 am
by fadmin
You are not giving much of a description what you are observing. Generic statements such as "getting errors" is not useful to anyone as we can't read your mind nor have access to you computers. You see that?

Always include specifics that someone else who don't know squat about what you have, can look at and see what is going on.

Also, NEVER EVER put login information online. Let's say you use the same username somewhere else and that other place opens the door to see what your IP is... It would be a cinch for someone to gain remote access to your system.

You should also know that if the dialer is running and you do anything with MySQL which puts any kind of load on it, it may crash the dialer as everything is VERY time sensitive.

Re: mySQL and MS Sql linked server

PostPosted: Wed Aug 15, 2012 4:00 pm
by Bobking
Thanks for the reply.

Where can I find information on the default usernames and passwords for the various elements of osdial please e.g. the mysql database, the web server etc etc.

Many thanks.

Re: mySQL and MS Sql linked server

PostPosted: Wed Aug 15, 2012 7:16 pm
by fadmin
See /etc/osdial.conf

The web GUI login is not used by SQL, which is why it fails.

This one is vital:
DO NOT PUT LOGIN INFORMATION ON ANY FORUM UNLESS YOU WANT TO BE HACKED.

Also, ALWAYS change the default login when you have installed a program. ALWAYS!!!

Re: mySQL and MS Sql linked server

PostPosted: Thu Aug 16, 2012 5:03 am
by voipessential
@Bobking Did you enable Mysql to be accessible from external hosts?