/etc/my.cnf is used to set global options mysql-data-dir/my.cnf is used to set server-specific options (RedHat defaults to/var/lib/mysql) or ~/.my.cnf to set user-specific options.
My original post suggestion of/etc/my.cnf works fine, but it opens you up to the potential security issues discussed above, as isil so wisely suggested. I believe the proper thing to do is to put your my.cnf file in/var/lib/mysql. Thanks for the correction.
This is why the replicate user only gets issued the FILE privilege, like the tutorial mentions:
GRANT FILE ON *.* TO replicate@ip_address IDENTIFIED BY 'password';
Although, you are correct, as this is a potential problem to be aware of, as listed in the MySQL documentation:
"Don't give the file privilege to all users. Any user that has this privilege can write a file anywhere in the file system with the privileges of the mysqld daemon! To make this a bit safer, all files generated with SELECT... INTO OUTFILE are readable to everyone, and you can't overwrite existing files. The file privilege may also be used to read any file accessible to the Unix user that the server runs as. This could be abused, for example, by using LOAD DATA to load `/etc/passwd' into a table, which can then be read with SELECT."
Minidisc's employ the SCMS (Serial Copy Mangement System) copy protection scheme, which basically means you can't make a digital copy of a digital copy. You can read a short CDR versus Minidisc review here and you can find out information about the Prospec MSP-730 SCMS "stripper" right here. The MSP-730 basically outputs unlimited SCMS bits to allow you to copy digital copies. I believe the article is a bit old, so there may or may not be other products like the 730 available. According to the article, the DMCA made this product illegal, but perhaps you could find someone somewhere still selling them, I haven't looked so I don't know. If you're intested in knowing more about the Minidisc, you can also check out the Minidisc FAQ.
I was wondering about this myself. At home, I have the first commercially available recordable mini-disc Sony released. I'm not sure if the no digital output is a recent phenomenon or what? I don't recall it not having a digital output, but I'd have to have the unit in front of me to see for sure...I think I paid like $500 for it when I bought it back in 1994 or so, and I don't think I've even used it since '95.:o) I'll have to dig that thing out of the closet when I get home from work, I think it's right next to my Sega Genesis and my 3D0.
I guess what I got most out of the article is that we are stifling progress in order to make a few people rich. I never really thought about it in those terms before. Help! Help! I'm being repressed!
I just have to rave about the database replication included with MySQL, what a fantastic feature. If you are interested in setting up replication yourself, you should read the nice tutorial on it over at PHPBuilder. The tutorial can be found here.
The replication feature has been changed a little since the tutorial was written, so you may want to check out the documentation at the MySQL site. Here's a copy of my own/etc/my.cnf file from both machines, which are setup for 2-way replication, for reference (perhaps I'll get around to posting a tutorial of my own later today on The Linux Pimp
Main server/etc/my.cnf file [mysqld]
log-bin
master-host=ip_address_of_backup
master-user=replicate
master-password=your_password
server-id=1
This is great news for the entire community. When I first used Enlightenment a good while ago, I was extremely impressed by it's configurability and the sheer volume of themes available for it, but my one complaint was its "sluggishness" as compared to AfterStep or WindowMaker.
I'm glad to hear that the project is still alive and doing so well and that this issue is being resolved. He's always been very passionate about E and no matter what window manager you use, you have to appreciate this kind of enthusiasm he has for his project. It's this kind of attitude that helps to continually drive the whole Linux community forward.
Since the inception of mankind, who has commited more insideous acts of vileness? Lone individuals or governments? The killing of Millions of Jewish persons in WWII Germany? Tell me, who wages war and has the power, and uses this power, to march tens of millions of human beings to the front lines of horrific trench warfare battles to be slaughtered for some "just cause" or to simply control some piece of property somewhere?
Certainly child molesters and serial killers commit deplorable acts against individuals, but they don't frighten me in the least as compared to a controlling and all powerful government who commits equally deplorable acts against entire nations!
I see a lot of people discussing the fact that you can only use Linux tools for the design, and this is definitely a limiting factor, but only if you're not already familiar with some of the great graphics tools for Linux. Most everyone here had heard of or used the Gimp, but don't forget that Blender provides a nice rich set of 3D tools under Linux, which allows you to create pretty cool images like this image from Manu Batot. There's also a nice simple sunset animation made with Blender that I downloaded right here.
I used to be the Systems Admin for a special effects company and we did a symposium a while back on HDTV. We had JVC and Sony and a few other manufacturers loan us equipment so we could show our clients how great it all was. We even had one of those DVHS machines from JVC.
Some clients left impressed, while others left scratching their heads, but I think the most interesting thing about HDTV, is that while we had some large screen $10,000 HDTV's to display some of the video, we were also using standard Dell monitors to display HDTV signals as well. The picture quality is great, though limited to the 21 inches or so of the monitors we had on hand. Now if I just had a 40 inch "monitor" I'd be all set for the HDTV "revolution" if and when it ever arrives.
That's probably true. Someone else mentioned here that sometimes he'll call tech support and get someone who obviously can't help him, so he'll hangup and call back again in the hopes of getting a better "tech support" person. I've actually done that on several occasions myself. That said, I still like my "packetstorm" phrase:O)
As a Systems Administrator myself, it's painfully obvious that others here have run into the same problem I have when I call technical support. You have to take those extra few minutes of time to convince the fellow geek on the other end that you are indeed a member of "geekdom". I propose that we have a secret geek codeword that can immediately identify each of us as a member of the geek commmunity, kind of like fraternities all have secret handshakes. Hmmm...let me get the ball rolling here, I propose the phrase "I hear there's going to be a packet storm at midnight.". Any other suggestions?
Sounds very promising if this does indeed come to pass. I wonder why the EUV LLC (which consists of Intel, AMD, Micron and Lawrence Livermore National Laboratories among others) seem to be waging their bets on Extreme Ultraviolet Lithography instead of looking at these new technologies? This new Lithography process is supposed to give us 10Ghz chips in the not so distant future. Then again, maybe these won't cost $15 a piece, so that could be the reason right there.
Angry Penguins practice UltraViolent Lithography! The Linux Pimp
I clicked on reply for the wrong story...this is perfectly on topic for this story, which is just below this one. That'll teach me to use several computers at once:O)
I hope this doesn't mean that when all these Direct Marketers get Slashdotted with bricks and sheetmetal in their envelopes they stop sending out envelopes but start calling me. I hate junkmail, but I really hate tele-marketers.
I was thinking about this a while back, and unfortunately, I believe it may be illegal, according to many EULA's, (end user license agreements) for money to change hands when playing many popular video games. I know you can't charge people to play certain videogames, and I think some licenses extend that to gambling as well. Unfortunately, I don't have a copy of any gaming EULA in front of me at the moment. Could someone confirm my thoughts on this...
"In November the group approved seven suffixes:.aero,.coop,.info,.museum,.name,.pro, and.biz..."
The majority of these names make no sense to me. I know what each name represents, but my question is why? Do the members of ICANN actually use the Internet? I thought for sure they would approve a.sex or a.xxx TLD, considering the sheer volume of pornography on the Internet, and how everyone seems to think we should do something about it. A.xxx TLD sure would help us admins with firewalling rules. Wouldn't even have to worry too much about enforcing compliance either, seems like anyone who runs a porn site would actually want to have a.xxx domain.
I've been running my own ISP now for about two years and tackled this same question at startup. I initially started off using a program called Optigold that was decent, though not OpenSource. The great thing about it was the amount of feedback that users could contribute to the development of the package, and updates came out for the package constantly. The software is also free to use until you have more than 100 customers, which is a very fair pricing scheme I thought. Optigold is, however, tied to Filemaker Pro which may be good or bad depending on your past experience. I had done database administration in the past using Filemaker, so at the time it was a good decision.
That said, I have since switched to just using Quickbooks Pro, for no other reason than it's very simple and straightforward. I can also charge credit cards right from the Quickbooks interface, which makes it very convenient. All the other packages I've tried (including Freeside and Rodopi) simply included too many features for my very simple needs, or required software I didn't want to run (Microsoft SQL server). I even started writing my own system in PHP, but abandoned the project because it simply wasn't worth my time. Anyhow that's my experience with the matter. As you mentioned needing Radius support, Quickbooks is probably too basic for your needs, as it's geared to generic services and not Internet Services billing, but Optigold may fit the bill. Good Luck.
Hate SPAM? Dont we all! Well now you can actually do something to prevent spamming! That's right, but this offer won't last forever, so act now before it's too late. For the introductory low, low price of only $19.95, you can rest assured that you will never receive another SPAM email again. Simply send your Visa or Mastercard number to this address. Hurry, before it's too late!
Penguins love Salmon, but hate the taste of SPAM. The Linux Pimp
I realize that this can be countered somewhat by proper shielding, but a powerful Electro Magnetic Pulse weapon could effectively send a nations military back into the stone age, or at least the WWI and WWII era. This could drastically effect modern warfare as we know it today. This site has a great overview and discussion of EMP technology.
I think if this type of weapon were exceptionally effective, it would force humans to basically bring back good ole trench warfare or at least rethink our current mechanized strategies which rely heavily on centralized command and information dissimination and analysis. While no war is a good war, modern tools of destruction, such as laser guided "smart" bombs have certainly helped to reduce casualties of civilians and other non-miliarty personnel. This could be a very powerful weapon indeed for the country that perfects it.
Hoards of mechanized penguins at your command! The Linux Pimp
I'll make this short and sweet (like my ex-girlfriend). Being a Geek does not in any way make you unpopular, it never has. I consider myself to have been "born Geek"(started programming BASIC in 6th grade), but I was always very popular in school (voted best personality senior year, toot! toot!, and even played College football for a Division 1 school). Anyhow, it's the stereotypical traits that some geeks have (anti-social, fearing parties, bad dressing, etc...) that make them unpopular with the masses, or perhaps they make themselves unpopular because of these traits. The important thing to remember, is that not all geeks have these traits (I'm shy, but not necessarily anti-social. I sit in front of the computer for 12 hours a day, but I also like playing golf and funneling beer).
I think what makes a person a Geek is, perhaps, above average intelligence, and more importantly, genuine curiousity about the world that surrounds them. I'd also add to that an internal need to discover how things function and how to make those functions function better or differently. Looking back on my definition, that sounds a great deal like the definition of a scientist. Luckily for us Geeks, scientists are "valued" by society.
Slashdot Mirror
mysql-data-dir/my.cnf is used to set server-specific options (RedHat defaults to
~/.my.cnf to set user-specific options.
My original post suggestion of /etc/my.cnf works fine, but it opens you up to the potential security issues discussed above, as isil so wisely suggested. I believe the proper thing to do is to put your my.cnf file in /var/lib/mysql. Thanks for the correction.
GRANT FILE ON *.* TO replicate@ip_address IDENTIFIED BY 'password';
Although, you are correct, as this is a potential problem to be aware of, as listed in the MySQL documentation:
"Don't give the file privilege to all users. Any user that has this privilege can write a file anywhere in the file system with the privileges of the mysqld daemon! To make this a bit safer, all files generated with SELECT ... INTO OUTFILE are readable to everyone, and you can't overwrite existing files. The file privilege may also be used to read any file accessible to the Unix user that the server runs as. This could be abused, for example, by using LOAD DATA to load `/etc/passwd' into a table, which can then be read with SELECT."
Minidisc's employ the SCMS (Serial Copy Mangement System) copy protection scheme, which basically means you can't make a digital copy of a digital copy. You can read a short CDR versus Minidisc review here and you can find out information about the Prospec MSP-730 SCMS "stripper" right here. The MSP-730 basically outputs unlimited SCMS bits to allow you to copy digital copies. I believe the article is a bit old, so there may or may not be other products like the 730 available. According to the article, the DMCA made this product illegal, but perhaps you could find someone somewhere still selling them, I haven't looked so I don't know. If you're intested in knowing more about the Minidisc, you can also check out the Minidisc FAQ.
I was wondering about this myself. At home, I have the first commercially available recordable mini-disc Sony released. I'm not sure if the no digital output is a recent phenomenon or what? I don't recall it not having a digital output, but I'd have to have the unit in front of me to see for sure...I think I paid like $500 for it when I bought it back in 1994 or so, and I don't think I've even used it since '95. :o) I'll have to dig that thing out of the closet when I get home from work, I think it's right next to my Sega Genesis and my 3D0.
This way to the egress of repression > The Linux Pimp
The replication feature has been changed a little since the tutorial was written, so you may want to check out the documentation at the MySQL site. Here's a copy of my own /etc/my.cnf file from both machines, which are setup for 2-way replication, for reference (perhaps I'll get around to posting a tutorial of my own later today on The Linux Pimp
Main server /etc/my.cnf file
[mysqld]
log-bin
master-host=ip_address_of_backup
master-user=replicate
master-password=your_password
server-id=1
Backup server /etc/my.cnf file
[mysqld]
log-bin
master-host=ip_address_of_main_server
master-user=replicate
master-password=your_password
server-id=2
I'm glad to hear that the project is still alive and doing so well and that this issue is being resolved. He's always been very passionate about E and no matter what window manager you use, you have to appreciate this kind of enthusiasm he has for his project. It's this kind of attitude that helps to continually drive the whole Linux community forward.
Certainly child molesters and serial killers commit deplorable acts against individuals, but they don't frighten me in the least as compared to a controlling and all powerful government who commits equally deplorable acts against entire nations!
Peck of Penguin Picasso's The Linux Pimp
Some clients left impressed, while others left scratching their heads, but I think the most interesting thing about HDTV, is that while we had some large screen $10,000 HDTV's to display some of the video, we were also using standard Dell monitors to display HDTV signals as well. The picture quality is great, though limited to the 21 inches or so of the monitors we had on hand. Now if I just had a 40 inch "monitor" I'd be all set for the HDTV "revolution" if and when it ever arrives.
High definition Penguins. The Linux Pimp
That's probably true. Someone else mentioned here that sometimes he'll call tech support and get someone who obviously can't help him, so he'll hangup and call back again in the hopes of getting a better "tech support" person. I've actually done that on several occasions myself. That said, I still like my "packetstorm" phrase :O)
We're all geeks over here>>> The Linux Pimp
Angry Penguins practice UltraViolent Lithography! The Linux Pimp
I clicked on reply for the wrong story...this is perfectly on topic for this story, which is just below this one. That'll teach me to use several computers at once :O)
Penguins a go-go. The Linux Pimp
This sounds horribly dangerous, I hope Linux never gets this "feature".
Geiger counters be damned! The Linux Pimp
Penguins play for keeps. The Linux Pimp
Penguins and jailbirds. The Linux Pimp
The majority of these names make no sense to me. I know what each name represents, but my question is why? Do the members of ICANN actually use the Internet? I thought for sure they would approve a .sex or a .xxx TLD, considering the sheer volume of pornography on the Internet, and how everyone seems to think we should do something about it. A .xxx TLD sure would help us admins with firewalling rules. Wouldn't even have to worry too much about enforcing compliance either, seems like anyone who runs a porn site would actually want to have a .xxx domain.
Penguins run around naked everyday! The Linux Pimp
That said, I have since switched to just using Quickbooks Pro, for no other reason than it's very simple and straightforward. I can also charge credit cards right from the Quickbooks interface, which makes it very convenient. All the other packages I've tried (including Freeside and Rodopi) simply included too many features for my very simple needs, or required software I didn't want to run (Microsoft SQL server). I even started writing my own system in PHP, but abandoned the project because it simply wasn't worth my time. Anyhow that's my experience with the matter. As you mentioned needing Radius support, Quickbooks is probably too basic for your needs, as it's geared to generic services and not Internet Services billing, but Optigold may fit the bill. Good Luck.
to the wristband by tapping their fingers in various rhythms.
How am I gonna explain this to the FBI when I start
playing air guitar to Limp Bizkit and I accidentally break into the Pentagon.
Penguin phone home. The Linux Pimp
Penguins love Salmon, but hate the taste of SPAM. The Linux Pimp
related to Yahoo now offends me greatly,
I demand that all traces of "Yahoo"
be removed from the Internet.
Smelly fish don't offend Penguins. The Linux Pimp
I think if this type of weapon were exceptionally effective, it would force humans to basically bring back good ole trench warfare or at least rethink our current mechanized strategies which rely heavily on centralized command and information dissimination and analysis. While no war is a good war, modern tools of destruction, such as laser guided "smart" bombs have certainly helped to reduce casualties of civilians and other non-miliarty personnel. This could be a very powerful weapon indeed for the country that perfects it.
Hoards of mechanized penguins at your command! The Linux Pimp
I think what makes a person a Geek is, perhaps, above average intelligence, and more importantly, genuine curiousity about the world that surrounds them. I'd also add to that an internal need to discover how things function and how to make those functions function better or differently. Looking back on my definition, that sounds a great deal like the definition of a scientist. Luckily for us Geeks, scientists are "valued" by society.
Pimps are Geeks too. The Linux Pimp