I?ve installed by Webmin a MySQL database in my Suse Linux 8.0. I?ve already created tables, inserted new data, exclude or edited any record on it but in Webmin admin module. How can I access this database from a windows workstation? I?ve tried to establish ODBC connection supplied by MySQL but it seems don?t find any connection. Thanks Gilberto Antonangeli Gerente de Inform?tica / IT Manager HYPERLINK "http://www.thomastecnica.com.br/"Thomas T?cnica Coml. El. Transm. * 55 11 5031-1144 fax 55 11 5031-0677 HYPERLINK "mailto:gilberto@thomastecnica.com.br"gilberto@thomastecnica.com.br --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/2002 -------------- next part -------------- HTML attachment scrubbed and removed
On Fri, Sep 13, 2002 at 02:22:59PM -0300, Gilberto (Thomas T?cnica) wrote about '[Samba] MySQL access':> I?ve installed by Webmin a MySQL database in my Suse Linux 8.0. I?ve > already created tables, inserted new data, exclude or edited any record > on it but in Webmin admin module. How can I access this database from a > windows workstation? I?ve tried to establish ODBC connection supplied by > MySQL but it seems don?t find any connection.This isn't the kind of thing samba is for - You will need to download the mysql windows support drivers from the mysql website in order to be able to connect to your mysql server as a client from windows. Jelmer
You can install the mysqlclient for Windows on your windows box and you
shouldn't even need samba to access it from the windows prompt just like you
do on linux.
To connect to another mysql host (default port:3306) on any network with
mysqlclient:
mysql -u <username> -h <hostname> -p
then enter your password (provided you have the mysql users name and password,
privileges set up correctly) and you'll get the same mysql prompt that you
get on your local machine. Hope this helps.
So, I've been trying to configure my samba on SuSE/8.0 also with no luck
what-so-ever. I can see my linux box in "My Network Places" from my
Win2K box but can't access anything. I get the error message:
\\Linux is not accessable. Network path not found
Can you share some insight as to how you got your suse 8.0 box up with samba????
----- Original Message -----
From: Gilberto (Thomas T?cnica)
To: samba@lists.samba.org
Sent: Friday, September 13, 2002 1:22 PM
Subject: [Samba] MySQL access
I've installed by Webmin a MySQL database in my Suse Linux 8.0. I've
already created tables, inserted new data, exclude or edited any record on it
but in Webmin admin module. How can I access this database from a windows
workstation? I've tried to establish ODBC connection supplied by MySQL but
it seems don't find any connection.
Thanks
Gilberto Antonangeli
Gerente de Inform?tica / IT Manager
Thomas T?cnica Coml. El. Transm.
( 55 11 5031-1144
fax 55 11 5031-0677
gilberto@thomastecnica.com.br
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.386 / Virus Database: 218 - Release Date: 9/9/2002
-------------- next part --------------
HTML attachment scrubbed and removed
I'd try shutting down iptables/ipchains entirely to see if it is indeed a frewall issue (They probably start with ntsysv) Justin Hannus wrote:> > >Make sure you have no firewall running, or that ports 137, 138 and > 139 are open for tcp and udp. > >Also, start with security=share (no security) to make sure you don't > have a user rights issue. > > I have port 139/tcp open (netbios-ssn). I looked in /etc/services and > ports 137-139 are listed both udp and tcp. > I checked out inetd.conf and they weren't listed so I added these lines: > > netbios-ssn stream tcp nowait root /usr/local/samba/bin/smbd smbd > netbios-ns dgram udp wait root /usr/local/samba/bin/nmbd nmbd > > then kill -HUP'd inetd's pid and ran nmap on ports 1-200 and only 139 > is open, 138 and 137 are closed. I have added security = share under > the [globals], I have the most vanilla smb.conf just to try and > connect. I still get the same error from my Win2K box. > Any suggestions?-------------- next part -------------- HTML attachment scrubbed and removed