| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> arjenAU: no i mean what is the functional significance of having an anonymous user? i just deleted it with mysql_secure_installation.
<0> arjenAU: with the same results
<0> arjenAU: i set up open perms for the user and for the db
<1> so for my case was the sms3 same as the --master-data ?
<2> again, I dunno what webmin does. I do know what the SHOW GRANTS command does that I asked you to execute. I conclude you haven't tried it.
<0> arjenAU: i did the command and i pasted the output above.
<3> when i do a "SHOW PROCESSLIST", i see over 400 sleeping threads... and new connections get an error because of too many connections.. how can i set those sleeping threads to timeout after a shorter time?
<0> arjenAU: btw thanks for your help sir
<2> dtm: so one wonders, what did you do with webmin. perhaps mythtv@'%' or something else. you need to learn to do these things yourself rather than hiding behind whatever webmin does.
<2> dtm: as root you can do SELECT user,host from mysql.user WHERE user='mythtv' to find out
<0> | mythtv | localhost,10.1.1.215 |
<0> same results if i delete the host acl
<2> that host field is invalid
<2> it's nonsense
<2> it can be only a single value. either an IP or localhost or a domain name or whatever. not comma separated nonsense
<2> if webmin did this, bad bad bad.
<2> it webmin allowed this, pretty bad also
<2> UPDATE mysql.user SET host='localhost' WHERE user='mythtv'; and then FLUSH PRIVILEGES; then you should be able to login
<0> arjenAU: i confess. i did it.
<2> so fix it
<4> shame shame
<4> I actually ended up with a 'user'@'host \n<some other stuff' field
<4> that was an adventure
<0> i can do CIDR, right? 10.1.1.0/24
<0> in there
<2> yes
<2> as long as you quote the whole thing
<0> arjenAU: i feel your pain, sir. thanks
<0> like i said, it's the same even when it's blank though.
<0> oh crap it's fixed now.
<0> :-.
<0> it wasn't the perms on the user; it was the perms on the db.
<0> i didn't have any to start with
<0> | mythtv | 10.1.1.24/0 |
<0> ok holy crap i'm tired.
<0> i get halfway dyslexic when i'm tired ;->
<0> btw webmin blocked me from using any spaces ;)
<0> hmm ok when i set that user acl to '10.1.1.0/24' it blocks me but when i set it to blank, i can get in.
<0> oh well!
<2> dtm: you may wish to read the exact errormsg you get.
<0> yeah.
<0> i'm going from localhost to localhost, which is within 10.1.1.0/24
<0> oh. so i need to contact it at 10.1.1.x
<2> are you connecting through IP or socket?
<2> the above doesn't match for socket so you'd get access denied.
<2> only localhost matches both 127.0.0.1 and localhost.
<2> it's all quite logical.
<1> how do i know my replication are working?
<2> qkit: on the slave, SHOW SLAVE STATUS\G
<1> arjenAU: my master show it using the FIle : sms-bin.002 but my slave say Relay_Master_Log_File: sms-bin.001
<1> look funny ...do you think the replication are runign?
<2> funnily enough, show slave status actually shows whether it is.
<2> reading the info may be easier than asking me to use a crystal ball.
<5> whoa
<5> hahaha
<1> ok, cause the File my master are using are sms-bin.002 but the slave are suing the sms-bin.001 in relay_master_log
<2> you're looking at the wrong field
<1> and in the master the show processlist \G; doesnt show any activity....
<1> wait i pastebin a the output, can help have a look ?
<2> sorry got other stuff to do. see this as your challenge for the day. use brain and work it out. it's all there.
<2> looking at bananas when looking for apples is not the way. logic applies.
<3> i tried doing set global wait_timeout=30 on mysql monitor but 'show variables' does not get updated
<6> I want to concat a string field and a numerical field but the numerical fields needs leading zeroes. Suggestions ?
<3> im on 4.1.10
<7> wimpies: conat(...,lpad(num,10),...)
<7> wimpies: check the lpad, I am missing 1 argument
<8> hi
<7> keith: try show global variables
<8> how can i make a backup of the db struct?
<6> ANy idea which section lpad is defined ?
<7> keith: only affect new connections
<7> !m wimpies string functions
<9> wimpies: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<10> lpad(num,10,'0')
<8> how can i make a backup of the db struct?
<10> !man mysqldump
<9> (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<3> ah ok, it does show 20seconds now lokus
<7> xpato: mysqldump there is a option that dump only the structure
<6> Thx ... it works
<0> i can't reach my mysql4 server when i set the user acl to my subnet. i can if that acl is blank. with an acl of 10.1.1.0/24, i get this error: ERROR 1130 (00000): #HY000Host '10.1.1.220' is not allowed to connect to this MySQL server
<4> I'm pretty sure you can't do /24 ...
<0> Darien: arjenAU told me i could :/ but do you suggest another syntax?
<4> 10.1.1.% ?
<7> mysql priv? the host value cannot take edit mask /24
<0> oic
<2> hmm?
<0> arjenAU: you said CIDR syntax was valid for a user acl
<0> 10.1.1.% works! thanks
<7> 192.168.1.0/255.255.255.0 should work
<2> it does, but bitmasks and subnets should also work.
<7> 192.168.0.1/255.255.255.240 does not
<7> according to the manual
<11> hellow does anyone here know how i can make it so mysql does not make huge 1gb -bin. files everyday?
<7> http://dev.mysql.com/doc/refman/5.0/en/connection-access.html
<2> sure if you specify a subnet you specify the base IP not some random IP in theere.
<2> ReaCT: every day?
<11> yes
<11> multiple of em a day
<7> 192.168.0.1/255.255.255.240 is however is a valid netmask, but not accepted by mysql priv
<2> ReaCT: the binlog is written when you do stuff. if you do a lot of stuff, a lot is written. the default maxsize for a single one is 1gb so it goes to the next
<2> lokus: ye but the .0.1 is silly there.
<2> lokus: it'd have to be .0 or smth
<11> yes i have a TON of databases for gameservers which are written to constantly all day
<7> the first 1 is the network address, the first number
<2> ReaCT: this is like going to the supermarket, buying a lot of stuff, and then complaining your receipt is long.
<11> is there a way to stop the creation of the -bin. files?
<7> maybe it should be 0
<2> ReaCT: binlog is necessary for a) backups and b) replication. re a) how lucky do you feel?
<11> i already have backup for it running in crontab every night at midnight
<2> ReaCT: but yes you can switch off binary logging, either completely or per db or even per table. it's just not a very wise thing to do
<2> ReaCT: and how are you doing that backup?
<11> through my webmin control panel, which i then have a crontab who ftp's the backup to my other server
<2> ah webmin user again.
<11> via wget
<2> my point is, have you ever looked at those backup files, know what they contain, and know they can be put back to create a working server ?
<2> or do you just ***UME
<11> i have used them to restore several times (the webmin backups)
<2> ok. fine.
<2> anyway, the point of the binary log is that it syncs with backups (if you do the backup right) and then you can recover from a backup + the rest of the binary log to the current point in time
<2> if you don't have binary logs, you will always restore to somewhere in the past. but heck, it's your system ;-)
<11> yea that would be great if it wasnt filling my hard drive
<11> lol
<11> the .sql file backups are much smaller
<2> you can purge old stuff
<12> is there a reason why it's not working? $query = "INSERT INTO contacts VALUES ($name,$comment)";
<2> ltR^: I'll guess lack of quoting of strings. the usual crap.
<12> what is the proper syntax
<2> ltR^: you quote strings.
<11> yea thats what ive been doing, but the one time i forget it will fill up the sql hard drive and that would be bad
<2> print $query and look at it.
<2> ReaCT: so schedule that purging in a cron
<11> i was going to do that, is it safe to delete the latest purge file while sql is running, or will it crash sql
<2> ReaCT: nonono, you do NOT touch the files directly. there are SQL commands to handle this safely.
<2> ReaCT: me thinks you need some serious education on this stuff. you're dangerous.
<11> PURGE MASTER LOGS
<2> is that a question?
<11> no
<11> thats how i purged them before from sql command line
<2> so?
<11> i was just asking about deleting them directly to see if it were bad or now, which now i know it is
<2> silly question
<11> thanks for your help
<7> deleting directly is not bad, but you need to know which to delete
<2> it's a bad idea.
<2> and a bad habit.
<2> and not necessary since there are good SQL commands for it which are safe, and take into account which file the server is using, and upto which file replication has used
<13> hello
Return to
#mysql
or
Go to some related
logs:
#math
glut.h libraries + ubuntu
#perl
linmodems SM56 dapper
pyparallel examples
COLD REVOLVR
PowerLinkGenerator
kde 3.5.2 automount
#perl
#gentoo
|
|