Q. I have two HDD in my computer: a 80GB SATA II and a 80GB PATA.
I have the default XP installed on 80SATA;
The question is, should I install Linux on the 80SATA, or entirely isolate its operation in the 80PATA?
Linux will be used as server. Thanks.
I have the default XP installed on 80SATA;
The question is, should I install Linux on the 80SATA, or entirely isolate its operation in the 80PATA?
Linux will be used as server. Thanks.
A. How to dual boot Windows XP and Linux (XP installed first)
http://apcmag.com/how_to_dual_boot_windows_xp_and_linux_xp_installed_first.htm
I thoroughly recommend Linux Mint 11. Its easy to install and easy to use plus it comes with much of the software you are likely to need preinstalled
Linux Mint 11 Download
http://www.linuxmint.com/edition.php?id=81
Linux Mint 11 Release Notes/User Guide
http://linuxmint.com/rel_katya.php
You download the ISO. image of any of Linux Mint 11 then you need to create a Bootable LiveDVD
https://help.ubuntu.com/community/BurningIsoHowto
Linux Mint 11 can also be run straight from the LiveDVD from Boot without touching your Hard Drive
LUg.
http://apcmag.com/how_to_dual_boot_windows_xp_and_linux_xp_installed_first.htm
I thoroughly recommend Linux Mint 11. Its easy to install and easy to use plus it comes with much of the software you are likely to need preinstalled
Linux Mint 11 Download
http://www.linuxmint.com/edition.php?id=81
Linux Mint 11 Release Notes/User Guide
http://linuxmint.com/rel_katya.php
You download the ISO. image of any of Linux Mint 11 then you need to create a Bootable LiveDVD
https://help.ubuntu.com/community/BurningIsoHowto
Linux Mint 11 can also be run straight from the LiveDVD from Boot without touching your Hard Drive
LUg.
How to set up a forum/virtual world?
Q. I have come up an idea that i am confident there is a high demand for and that it has not been done. It would require a way, not completely unlike Answers, i suppose, for many users to be able to participate. How would I go about setting something like this up?
A. If you're a non-technical person, then chances are you'd have to hire a programmer. Creating something like Yahoo Answers would be a huge undertaking. It's basically a web application. Other kinds of web applications are things like webmail (Gmail, Hotmail, Yahoo mail, etc.), Google maps, Online calendars, etc. If your project is totally unique, you definitely won't find any ready-made tools out there to solve the problem for you, you'd need to create it from scratch.
If you're technically able, what you need is to choose a hosting platform: Linux or Windows. On Linux, you'd be writing the application is PHP, on Windows, you'd be writing in ASP or ASP.NET. Choice between the two would depend on many things, including: your budget, your familiarity with Linux vs. Windows servers, programming tools and languages (PHP or ASP).
If you can't do it yourself and can't afford to pay a programmer to do it, there are a couple of other options:
1) Create a project on SourceForge.net. SourceForge is an open source software community. Many developers visit there and lend their skills and abilities to various open source projects. Create the project, given lots of detail in the description, and then you can "post" a developers-wanted ad on the site, to try and entice others to help you. The down-side of this procedure is that you couldn't charge for use of the web app, since it's open source, and others could take your code and develop their own competing web communities.
2) If your idea is a business venture, go looking for a developer (programmer) and tell him or her that you'd split or give a percentage of the business to him or her. Then, with your partnetship, you could make it happen.
As the previous poster suggested, if it's just a forum you're trying to create, phpBB is good, as long as you host on Linux servers. There are other good forum packages for ASP, but I won't list them here. However, if you want something customized and different that your typical run-of-the-mill forums, you'd need to create it yourself.
Good luck!
If you're technically able, what you need is to choose a hosting platform: Linux or Windows. On Linux, you'd be writing the application is PHP, on Windows, you'd be writing in ASP or ASP.NET. Choice between the two would depend on many things, including: your budget, your familiarity with Linux vs. Windows servers, programming tools and languages (PHP or ASP).
If you can't do it yourself and can't afford to pay a programmer to do it, there are a couple of other options:
1) Create a project on SourceForge.net. SourceForge is an open source software community. Many developers visit there and lend their skills and abilities to various open source projects. Create the project, given lots of detail in the description, and then you can "post" a developers-wanted ad on the site, to try and entice others to help you. The down-side of this procedure is that you couldn't charge for use of the web app, since it's open source, and others could take your code and develop their own competing web communities.
2) If your idea is a business venture, go looking for a developer (programmer) and tell him or her that you'd split or give a percentage of the business to him or her. Then, with your partnetship, you could make it happen.
As the previous poster suggested, if it's just a forum you're trying to create, phpBB is good, as long as you host on Linux servers. There are other good forum packages for ASP, but I won't list them here. However, if you want something customized and different that your typical run-of-the-mill forums, you'd need to create it yourself.
Good luck!
mySQL: How do you enable remote access to a mySQL database if the database is on a remote server?
Q. The only way I know how to edit the DB is using phpmyadmin. Is there anyway to allow remote access to the DB that way? Or this there another way to enable remote access if the DB is hosted on a remote machine?
A. Modify the IP information according to your scenario.
Step # 1: Login Using SSH (if server is outside your data center)
First, login over ssh to remote MySQL database server:
ssh user@mysql.nixcraft.i
Step # 2: Edit my.cnf File
Once connected you need to edit the MySQL server configuration file my.cnf using a text editor such as vi.
* If you are using Debian Linux file is located at /etc/mysql/my.cnf location
* If you are using Red Hat Linux/Fedora/Centos Linux file is located at /etc/my.cnf location
* If you are using FreeBSD you need to create a file /var/db/mysql/my.cnf
Edit /etc/my.cnf, run:
# vi /etc/my.cnf
Step # 3: Once file opened, locate line that read as follows
[mysqld]
Make sure line skip-networking is commented (or remove line) and add following line
bind-address=YOUR-SERVER-IP
For example, if your MySQL server IP is 65.55.55.2 then entire block should be look like as follows:
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/English
bind-address = 65.55.55.2
# skip-networking
....
..
....
Where,
* bind-address : IP address to bind to.
* skip-networking : Donât listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recommended for systems where only local requests are allowed. Since you need to allow remote connection this line should be removed from my.cnf or put it in comment state.
Step# 4 Save and Close the file
Restart the mysql server, enter:
# /etc/init.d/mysql restart
Step # 5 Grant access to remote IP address
Connect to mysql server:
$ mysql -u root -p mysql
Grant access to a new database
If you want to add a new database called foo for user bar and remote IP 202.54.10.20 then you need to type the following commands at mysql> prompt:mysql> CREATE DATABASE foo;
mysql> GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD';
How Do I Grant Access To An Existing Database?
Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin, To grant access to this IP address type the following command At mysql> prompt for existing database, enter:
mysql> update db set Host='202.54.10.20' where Db='webdb';
mysql> update user set Host='202.54.10.20' where user='webadmin';
Step # 5: Logout of MySQL
Type exit command to logout mysql:mysql> exit
Step # 6: Open port 3306
You need to open TCP port 3306 using iptables or BSD pf firewall.
A sample iptables rule to open Linux iptables firewall
/sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
OR only allow remote connection from your web server located at 10.5.1.3:
/sbin/iptables -A INPUT -i eth0 -s 10.5.1.3 -p tcp --destination-port 3306 -j ACCEPT
OR only allow remote connection from your lan subnet 192.168.1.0/24:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
Finally save all rules:
# service iptables save
A sample FreeBSD / OpenBSD pf rule ( /etc/pf.conf)
pass in on $ext_if proto tcp from any to any port 3306
OR allow only access from your web server located at 10.5.1.3:
pass in on $ext_if proto tcp from 10.5.1.3 to any port 3306 flags S/SA synproxy state
Step # 7: Test it
From your remote system or your desktop type the following command:
$ mysql -u webadmin âh 65.55.55.2 âp
Step # 1: Login Using SSH (if server is outside your data center)
First, login over ssh to remote MySQL database server:
ssh user@mysql.nixcraft.i
Step # 2: Edit my.cnf File
Once connected you need to edit the MySQL server configuration file my.cnf using a text editor such as vi.
* If you are using Debian Linux file is located at /etc/mysql/my.cnf location
* If you are using Red Hat Linux/Fedora/Centos Linux file is located at /etc/my.cnf location
* If you are using FreeBSD you need to create a file /var/db/mysql/my.cnf
Edit /etc/my.cnf, run:
# vi /etc/my.cnf
Step # 3: Once file opened, locate line that read as follows
[mysqld]
Make sure line skip-networking is commented (or remove line) and add following line
bind-address=YOUR-SERVER-IP
For example, if your MySQL server IP is 65.55.55.2 then entire block should be look like as follows:
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/English
bind-address = 65.55.55.2
# skip-networking
....
..
....
Where,
* bind-address : IP address to bind to.
* skip-networking : Donât listen for TCP/IP connections at all. All interaction with mysqld must be made via Unix sockets. This option is highly recommended for systems where only local requests are allowed. Since you need to allow remote connection this line should be removed from my.cnf or put it in comment state.
Step# 4 Save and Close the file
Restart the mysql server, enter:
# /etc/init.d/mysql restart
Step # 5 Grant access to remote IP address
Connect to mysql server:
$ mysql -u root -p mysql
Grant access to a new database
If you want to add a new database called foo for user bar and remote IP 202.54.10.20 then you need to type the following commands at mysql> prompt:mysql> CREATE DATABASE foo;
mysql> GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD';
How Do I Grant Access To An Existing Database?
Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin, To grant access to this IP address type the following command At mysql> prompt for existing database, enter:
mysql> update db set Host='202.54.10.20' where Db='webdb';
mysql> update user set Host='202.54.10.20' where user='webadmin';
Step # 5: Logout of MySQL
Type exit command to logout mysql:mysql> exit
Step # 6: Open port 3306
You need to open TCP port 3306 using iptables or BSD pf firewall.
A sample iptables rule to open Linux iptables firewall
/sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
OR only allow remote connection from your web server located at 10.5.1.3:
/sbin/iptables -A INPUT -i eth0 -s 10.5.1.3 -p tcp --destination-port 3306 -j ACCEPT
OR only allow remote connection from your lan subnet 192.168.1.0/24:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
Finally save all rules:
# service iptables save
A sample FreeBSD / OpenBSD pf rule ( /etc/pf.conf)
pass in on $ext_if proto tcp from any to any port 3306
OR allow only access from your web server located at 10.5.1.3:
pass in on $ext_if proto tcp from 10.5.1.3 to any port 3306 flags S/SA synproxy state
Step # 7: Test it
From your remote system or your desktop type the following command:
$ mysql -u webadmin âh 65.55.55.2 âp
Nec Projector Review
Plastic Shed Reviews
Ati Graphic Reviews
Nurse Uniforms Reviews
Cabochons Reviews
Inflatable Water Slides Reviews
Barcode Scanner Reviews
No comments:
Post a Comment