| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> noo as in free to a good home
<0> I index the db
<1> in a master/slave situation, you issue a bad command like drop table 'non-existent' table, does that command still get executed on the replication server?
<1> Jymmm: what ya doing here?
<2> slummin, hunting down RainMkr
<1> heh
<3> Is it possible to make mysql listen on more than tcp socket?
<1> not here at the moment, it seems :)
<3> Or do I need to do Crazy iptables Redirection...
<1> tw-nym: you want it to listent to different ports or just different IP's?
<3> 2 out of 6 ip addresses and none of the others.
<1> iirc, it listens on * so any ip will work that is known to the machine
<3> I can't allow it to listen on the other 4 so * won't work for me.
<1> i dont know of a setting off hand that limits the ips it listens to
<3> It'd be easier if it allowed more than one socket but I bet that increases the server complexity significantly.
<0> kramba its running at www.collection.archivist.info
<1> i would look at blocking *:3306 on those other ip's you dont want access from via your iptables
<1> i dont think there is that fine tuning to how mysql listens on tcp
<1> the permissions are usually handled via what user@host can connect
<3> When given the option of 1 redirect vs 4 drops, I choose the simpler solution.
<2> Alter the bind addresses in the mysql configuration
<2> no need to muck with iptables
<2> tw-nym becasue I can't find the **** in the mysql manual (POS), this should give you the right idea.... http://www.devside.net/web/server/windows/mysql
<2> bind-address=localhost
<2> # --bind-address=127.0.0.1
<2> # [Note that any IP address can be specified]
<1> hmm
<1> tw-nym: yeah it looks like mysqld has a bind-address option that seems the simplest option
<4> 11:36 * Isotopp is also slightly drunk.
<4> that scared me for a second ;)
<4> until I realized it's a different time zone ;)
<1> you havn't been stlightly drun at 11:36?
<4> not today :)
<1> hehe
<3> jymmm: Bind address only accepts 1 address. I need 2 (and only 2) of six.
<0> 1 or all only
<5> tw-nym: Don't bind it to any address then
<0> time somebody fixed that its a common request
<3> Because of the way virtual hosting is set up, that's not an option, nor do I have the authority to make that kind of change. There will be a listening port collision if I don't bind to an address.
<5> archivist: Fix what?
<0> selecting ips to bind to
<5> I thought all services can only bind to one interface, no?
<6> Just a quick question, on MySQL 5 with the No Backslash Escape option enabled, how would one insert a '?
<5> Prepared statement?
<7> ''
<6> ahh
<8> "'"
<0> \'
<3> Sockets themselves can only bind to one or all ip addresses. Mysql seems to only support one socket. It appears I'm SOL. Thanks for the suggestions everyone.
<3> (one tcp socket)
<6> archivist: that won't work with No Backslash Escape
<7> tw-nym: bind to all interfaces, and use a filewall
<7> *firewall
<9> NeoThermic: QUOTE(some sql....);
Return to
#mysql
or
Go to some related
logs:
could not load OpenGL subsystem quake3 ubuntu
floccinoccinihiliphification
beginner matematics
nibble_read ubuntu
err+17+grub
php5-cgi cpu load
#ubuntu
#gaim
d2gs 1.11
#kde
|
|