Hello,
Good post, but not what i'm looking for.
Well, Postgresql seems to be the winner, at least for
handling network addresses.
(Don't take me wrong. I'm not saying Postgresql is better RDBMS)
Thanks.
On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
js wrote:
> Hi Baron.
> Thanks f
Hi,
js wrote:
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
Very true, I didn't quite understand the syntax you were using. But you can still use
bitwise arithmetic to work around this. Scott Noyes wrote a nice
> -Original Message-
> From: js [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2007 15:31
> To: MySQL List
> Subject: Network address functions in MySQL?
>
>
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you to do
>
> inet '192.168.1/24' >> inet '192.168.1.
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hello,
js wrote:
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you to do
>
>
Hello,
js wrote:
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' >> inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
Yes. Have a look at the inet_ntoa() and i
On Saturday 17 December 2005 21:43, [EMAIL PROTECTED] wrote:
> I think the most likely culprit will be an unexpected reverse DNS result.
> Here are the other likely reasons to get an access denied error:
> http://dev.mysql.com/doc/refman/4.1/en/access-denied.html
>
> To the server, does the machine
Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote on 12/17/2005 02:12:38
PM:
> I'm trying to access a database over my local network.
>
> On the server, I had applied the following commands:
>
> shell > mysql -u root -p
> mysql> GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED
BY
>
I would like to thank you all for the help and the
explanations.
I think I'll stick to the option of having the
database behind the firewall. The problem is I don't
control that part of the company, as you can imagine
so I'll have to ask the network administrators for
that.
Just want to resume wh
ODBC, the connection is made and everything is happy.
>
> Just my $.02
> J.R.
>
> -Original Message-
> From: Ruben Carvalho [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 06, 2005 1:20 PM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: R
.
Just my $.02
J.R.
-Original Message-
From: Ruben Carvalho [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 06, 2005 1:20 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Network drive
I don't have a web server, I mean, I have a standalone java application
running i
I don't have a web server, I mean, I have a standalone
java application running in my clients and the
application calls the database.
Is there any way of having "something" listening to my
application calls in my open machine (outside the
proxy) and this "something" would then call the
database r
Ruben Carvalho wrote:
Well, thank you very much for your explanation.
My problem is I would like to have the data files
being saved in a machine behind a proxy but the server
running in a machine outside the proxy (the clients
don't have access to the machine behind the proxy).
Any ideas? Thank
Ruben Carvalho <[EMAIL PROTECTED]> wrote on 07/06/2005 12:54:24
PM:
> Well, thank you very much for your explanation.
>
> My problem is I would like to have the data files
> being saved in a machine behind a proxy but the server
> running in a machine outside the proxy (the clients
> don't have
Well, thank you very much for your explanation.
My problem is I would like to have the data files
being saved in a machine behind a proxy but the server
running in a machine outside the proxy (the clients
don't have access to the machine behind the proxy).
Any ideas? Thank you
--- [EMAIL PROTECT
Ruben Carvalho <[EMAIL PROTECTED]> wrote on 07/06/2005 11:06:10
AM:
> I think I haven't understood your question. I guess
> that in case of a network failure you can have the
> same behavior as a power shutdown.
>
> About the networked drives? Anyone?
>
>
> --- Martijn Tonies <[EMAIL PROTECTED
I think I haven't understood your question. I guess
that in case of a network failure you can have the
same behavior as a power shutdown.
About the networked drives? Anyone?
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi Ruben,
>
> > I would like to make a short, quick and simple
> > quest
Hi Ruben,
> I would like to make a short, quick and simple
> question.
>
> Is it possible to have the following line:
>
> innodb_data_home_dir="X:/data/"
>
> in a my.ini config file?
>
> I'm using windows XP, mysql 4.1.12, X: is a mapped
> network drive to a Linux folder using samba, all the
> per
es" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 03:42
Subject: Re: network interfaces
> Hi Dan,
>
> Instead of skip-networking, use bind-address in my.cnf:
>
> bind-address=192.168.0.1
>
> I think you can just specify 1 IP lik
Hi Dan,
Instead of skip-networking, use bind-address in my.cnf:
bind-address=192.168.0.1
I think you can just specify 1 IP like that. So... you either have 1)
listening on no IP (skip-networking), 2) listening on 1 IP
(bind-address), or 3) listening on all IPs (the default).
BTW, I think even w
Hello.
On Tue 2002-12-10 at 21:30:21 -0800, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am wondering about the case where a client sends
> mysql_query("commit")
> but never gets a response.
>
> Is the transaction complete, or not? Perhaps the "commit" was lost in the
> network -- but, on the othe
KSausW,
Monday, July 29, 2002, 12:47:30 PM, you wrote:
K> How can I grant a privilege to a specified user to a specific DB?
K> If I grant
K> Host="%"
K> User="joe"
K> in the user table, "joe" can access a l l DBs on the server - even the
K> "mysql"-DB.
Table 'user' stores global privil
Pada Mon, 29 Jul 2002 11:47:30 +0200
KSausW <[EMAIL PROTECTED]> menulis :
> How can I grant a privilege to a specified user to a specific DB?
> If I grant
> Host="%"
> User="joe"
> in the user table, "joe" can access a l l DBs on the server - even the
> "mysql"-DB.
grant on . to @ ide
Network access or remote access is handled by the OS such as Linux.
All you need to do is make sure you have a user setup that is allowed to
access the database from those locations. Example:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFI
Steve,
Monday, July 22, 2002, 3:39:52 AM, you wrote:
SD> I am a MySQL newbie and can not seem to find the documentation that
SD> explains how to allow network or remote access to a running MySQL
SD> server. It does not seem to be in the my.cnf file or in the manual???
SD> I am sure this is a
Hi,
If you mean how to connect to a MySQL server from a
remote machine in a local network, you only need to
include the computer (or ip address) of the server in
the HOSTNAME. You also have to make sure that the user
in the connection string, has permission to access the
database, you should go t
look at the grant syntax in the manual.
Steve Dickey wrote:
> I am a MySQL newbie and can not seem to find the documentation that
> explains how to allow network or remote access to a running MySQL
> server. It does not seem to be in the my.cnf file or in the
> manual??? I am sure this is a
Neil Freeman writes:
> Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to
> work though :(
>
Hi!
Try putting both basedir and datadir on X: ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to
work though :(
Miguel Angel Solorzano wrote:
> At 16:00 04/02/2002 +, Neil Freeman wrote:
> Hi!
>
> I did the test in my small network and works. The only care I
> did is to mapped the network drive, assign
At 16:00 04/02/2002 +, Neil Freeman wrote:
Hi!
I did the test in my small network and works. The only care I
did is to mapped the network drive, assign a letter (in my case
F). Please take a look if effectively you had mapped the drive
X (trying to access the X drive with an DOS prompt).
Reg
Neil,
Tuesday, February 05, 2002, 11:19:35 AM, you wrote:
NF> That's a bit of a pain :) Any idea if this will be supported at some point?
Apparently it will not be supported. Disk file system differs
from networking file system. MySQL will not work via networking file system.
NF> Cheers, Neil
That's a bit of a pain :) Any idea if this will be supported at some point?
Cheers, Neil
Victoria Reznichenko wrote:
> Neil,
>
> Monday, February 04, 2002, 6:00:18 PM, you wrote:
> NF> Hi,
>
> NF> Ideally I wish to keep all of my database files on a network drive
> NF> (X:\). Using WinMySQLAdmi
How about using Ora_Logon to connect to an oracle db? It is the
prescibed procedure. mysql_pconnect ist used to connect to mysql
dbs.
> $db = mysql_pconnect ("anothermachine:oracleport", "user", "passwd") or
> die ..
> I need to connect to an oracle DB - can I? Or do I have to run a ?cgi?
>
On 4/9/01 4:36 PM, "Cory Whitesell" <[EMAIL PROTECTED]> wrote:
> I have been happily using a program I developed that uses mysql to store
> technical support articles that I ancounter regularily. A new person is
> starting work here tomorrow, so suddenly, I need this to work over the
> network. T
33 matches
Mail list logo
