The most secure way to to configure mysql is to use the script provided by them called:

mysql_secure_installation.

 

The first function we must conduct is to startup MySQL by issueing the following

command:

 

Quote:NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

 

 

In order to log into MySQL to secure it, we'll need the current

password for the root user.  If you've just installed MySQL, and

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

 

Enter current password for root (enter for none):

OK, successfully used password, moving on...

 

Setting the root password ensures that nobody can log into the MySQL

root user without the proper authorisation.

 

Set root password? [Y/n]y

New password:

Re-enter new password:

Password updated successfully!

Reloading privilege tables..

... Success!

 

 

By default, a MySQL installation has an anonymous user, allowing anyone

to log into MySQL without having to have a user account created for

them.  This is intended only for testing, and to make the installation

go a bit smoother.  You should remove them before moving into a

production environment.

 

Remove anonymous users? [Y/n] y

... Success!

 

Normally, root should only be allowed to connect from 'localhost'.  This

ensures that someone cannot guess at the root password from the network.

 

Disallow root login remotely? [Y/n] y

... Success!

 

By default, MySQL comes with a database named 'test' that anyone can

access.  This is also intended only for testing, and should be removed

before moving into a production environment.

 

Remove test database and access to it? [Y/n] y

- Dropping test database...

... Success!

- Removing privileges on test database...

... Success!

 

Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

 

Reload privilege tables now? [Y/n] y

... Success!

 

Cleaning up...

 

 

 

All done!  If you've completed all of the above steps, your MySQL

installation should now be secure.

 

Thanks for using MySQL!

Attached Files

  mysql_secure_installation.txt (Size: 6.16 KB / Downloads: 23)

I decided I would like to listen to my vast mp3 collection from anywhere. I went with shoutcast as I have several friends that use it and it looked like it would serve my needs perfectly. First you need to get the shoutcast source and to send the stream to the shoutcast server you will need to get sc_trans. I read that you can use winamp to stream to shoutcast but I don't use windows or winamp so I used sc_trans. It takes a playlist of mp3s and sends it to the server. The playlist is just a list of mp3s using full paths. I will include examples at the end of this little explanation.

First you should create a user to run the server and sc_trans { useradd shoutcast } You really don't want this to be ran as the root user for safety sake. Now that you have your user created you need to become that user with su { su - shoutcast } this will give you a login shell as the shoutcast user. Now let's grab the files you will need { wget [/url]http://www.shoutcast.com/downloads/sc1-9-5...x-glibc6.tar.gz && wget http://grep420.net/linux/sc_trans_040.tar.gz } Now that you have the files you need lets get them untar'd and gunzip'd. { tar -xvzf shoutcast-1-9-5-linux-glibc6.tar.gz && tar -xvzf sc_trans_040.tar.gz } First lets make this easier to work with { mv shoutcast-1-9-5-linux-glibc6 shoutcast } { mv sc_trans_040 sc_trans }

Now let's get started with the configuration. { cd shoutcast } Now you need to open the server configuration file in your text editor of choice. I use vi, so I would type vi sc_serv.conf you can usually find nano on your system if you are unable to figure out vi, or type vimtutor for a quick lesson on the basics of vi. Now that you have sc_serv.conf open you need to set a few values for this to work the way you want.

 

# sc_serv.conf

MaxUser=20 # set this to the maximun number of people you want to connect to the stream

Password=YourPassword # this is the password you use in the sc_trans.conf file

PortBase=8000 # this is the port it will listen on

AdminPassword=MyPassword # this is your admin login for the web based admin tool

 

That's all you really need to edit in the server conf. Save that file and go configure sc_trans. { cd ~/sc_trans } You will need to edit sc_trans.conf the same way we did sc_serv.conf

 

#sc_trans.conf

PlaylistFile=/home/shoutcast/playlist.lst # this is your list of mp3s you want to stream

ServerIP=localhost # most likely this is what you want

ServerPort=8000 # this is the port that you set in sc_serv.conf

Password=YourPassword # this is the password you set from above in sc_serv.conf, not the admin

StreamTitle=blah # set this to what you want displayed in the players

StreamURL=http://grep420.net # set this to your domain or the site you want

Shuffle=1 # set this to 0 if you don't want it to shuffle, it will play each sonf from your list in order

 

The playlist is very simple. It is just a list of each mp3 you want to stream. It needs full paths and the user shoutcast will need read access to the files. { chmod 755 /nfs/mp3 }

 

#example playlist.lst

/nfs/mp3/tool/pushit.mp3

/home/shoutcast/music/sublime/santeria.mp3

/home/flukex/mp3/Madonna/likeavirgin.mp3

 

Now you have them configured, here is the last tricky part. If you are using NAT ip's behind a linux router/gateway you will need to forward some ports to the internal ip of the shoutcast server. I will give you an example.

 

# iptables example is assuming eth0 is your external interface on the router/firewall box.

/sbin/iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 8000 -j DNAT --to 192.168.1.10:8000

/sbin/iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 8001 -j DNAT --to 192.168.1.10:8001

 

Now lets start the server. { cd ~/shoutcast && ./sc_serv sc_serv.conf & } and sc_trans { cd ~/sc_trans && ./sc_trans sc_trans.conf & } You will start to see the output of what is happening in your terminal. Now login to the web tool and check the status. Open your browser to the servers ip on port 8000 { [url=http://192.168.1.10:8000]http://192.168.1.10:8000 } You should be able to click on admin login and use the password you set in sc_serv.conf above.

 

I hope this works for you as easily as it did for me, and if I left anything out please feel free to post your questions here.

I cannot find ANY easy directions/guide for installing the ndis utility. I have a Linksys WMA54G pcmcia card in a Dell Latitude C400 running Fedora Core 3. I looked at the ndis website, but am lost - I tried the instructions from that site, but to no avail...

 

PLEASE HELP!!

 

Thanks in advance!!!

hi guys

 

sorry about the site downtime (a few hours today)

 

due to the electricity cutting out several times in a row over the space of two hours due to a snow storm here in Sweden.

 

hopefully things should stabilise now,

 

ps. if anyone would care to donate and ship an UPS to me then please let me know (one that can power a pc for up to 30 minutes or so)

 

let me know if you can, it would support a good cause (this site !) and it would power a smoothwall server (regular PC)

 

mucho's gracias to anyone who can, and of course i'll make sure you are rewarded ;)

 

anyweb

Hi!

 

I have a RedHat 9.0 on my other computer. I want to run a server on that computer. The services that i want are: http,ssh,ftp. Cause of that, i decide to install all internet packages that had on RedHat install.

[to make a ideia i screen it: www.s0nc.net/internetservices.png (don

How do you change your computer name on fedora core 3? I tried doing it the gentoo way but that did not work. Thanks :)

Hello Glad I found this site.I'm pretty new to Linux I've been using it for about a week now.Well heres my problem.When I first installed Linux it was SuSE Personal 9.1 and when I would go to my networking I could access my WinXP pc.I have 2 pcs and the one I'm trying to get on is more of a back up for me to keep files on.Well now I've installed SuSE 9.2 Pro since it has most of the packages I wanted.I can see the Sabma installed and I go to netowrking and see the windows icon but when I try to enter it tells me it can't find the workgroup I'm trying to connect to.How can I go about getting this going again??

 

SuSE linux is on the following

Pent 4 2.0 gig hrz

512 ram

Nvida mx400 agp 64 megs ram

40 gig maxtor hd

sound blaster audigy sound card

 

the WinXP is

 

pent 4 1.6 gig hrz

256 ram

nvida pci mx400 32 megs ram

20 gig hard drive

on board sound

 

Also I am connect using a Belkin router.

 

Thanks.

Hi,

 

I am looking to do the following:

 

Create a bootable USB key with grub/lilo to pick different linux images.

 

These images will be 4 different kickstarts of various flavours of redhat.

 

Ideally the key would be setup as follows. Has anyone had any luck doing this? I am kinda stuck ;(

 

/

/ws3/vmlinuz

/as3/vmlinuz

/rh73/vmlinuz

rh9/vmlinuz

 

Thanks!

As you may have noticed, there is now a scripts section here you can ask questions about scripts, post your custom scripts you feel might be useful to others etc etc..

 

greetz anyweb

Resource.hh: In constructor `Resource<T>::Resource(ResourceManager&, T, const std::string&, const std::string&)':

Resource.hh:74: error: invalid use of undefined type `struct ResourceManager'

Resource.hh:59: error: forward declaration of `struct ResourceManager'

Resource.hh: In destructor `virtual Resource<T>::~Resource()':

Resource.hh:77: error: invalid use of undefined type `struct ResourceManager'

Resource.hh:59: error: forward declaration of `struct ResourceManager'

make[3]: *** [basemenu.o] Error 1

make[3]: Leaving directory `/home/raven/fluxbox-0.1.14/src'

make[2]: *** [all-recursive] Error 1

make[2]: Leaving directory `/home/raven/fluxbox-0.1.14/src'

make[1]: *** [all-recursive] Error 1

make[1]: Leaving directory `/home/raven/fluxbox-0.1.14'

make: *** [all] Error 2

 

Thanks for all help,

Raven Manor