lamp

1. 安装apache

1. wget http://www.apache.org/dist//httpd/httpd-2.2.17.tar.gz  # 下载安装包  
2.       
3.     tar jxvf httpd-2.2.14.tar.bz2   #解包  
4.     cd httpd-2.2.14                 #进来准备编译安装apache  
5.     mkdir /usr/local/apache2        #这个目录用来安装apache  
6.     /configure --prefix=/usr/local/support/apache2 --enable-so --enable-dav --enable-dav-fs -enable-maintainer-mode              #编译  
7.     make ; make install;  
8.     id apache  # 检查是否存在apache账户  
9.     useradd apache  # 建立apache 账户  
10.     chown  -R apache.apache /usr/local/support/apache2  # 让apache用apache这个账户权限运行  
11.     vi /usr/local/support/apache2/conf/httpd.conf  
12.     修改User和Group均为apache  

2安装mysql

mysql 5.5 以上的版本比较特殊不像原先的版本一样用configure 而是使用cmake

具体的看下面的操作

1.在安装mysql 之前需要软件:

#groupadd mysql

#useradd -r -g mysql mysql

#yum install gcc gcc-c++ libtool autoconf automake imake libxml2-devel expat-devel ncurses-devel cmake bison

2.解压源码包

#tar -zxvf mysql-5.5.16.tar.gz

#cd mysql-5.5.16

3.cmake进行编辑

 

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data/ -DMYSQL_UNIX_ADDR=/var/tmp/mysql/mysqld.sock -DDEFAULT_CHARSET=utf8 -DEXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DMYSQL_USER=mysql

#make

#make install

#cd /usr/local/mysql

#chown -R mysql .

#chgrp -R mysql .

#scripts/mysql_install_db --user=mysql

#chown -R root .

#chown -R mysql data

#cp support-files/my-medium.cnf /etc/my.cnf

#bin/mysqld_safe --user=mysql & //用netstat -tnl查看一下3306端口

#cp support-files/mysql.server /etc/init.d/mysqld

#cd /usr/local/bin
#ln -fs /usr/local/mysql/bin/mysql mysql

4.把mysql 添加系统服务启动

 

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld

cd /etc/rc.d/init.d

 

chkconfig --add mysqld

5 修改启动脚本

vi /etc/init.d/mysqld

修改

datadir=/usr/local/mysql/var/

改成

datadir=/usr/local/mysql/data/

6. 启动和停止mysql

service mysqld start/stop

7.设置mysql的root密码

/usr/local/mysql/bin/mysqladmin -uroot -p passwd 'mysqlmima'

到此mysql-5.5.16 就安装完毕。记录下希望对大家有帮助。

MySQL: Starting MySQL….. ERROR! The server quit without updating PID file解决办法

 

1 问题

[root@localhost mysql]# /etc/rc.d/init.d/mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
[root@localhost mysql]# /etc/rc.d/init.d/mysql start
Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).                              [FAILED]

 

2 原因

没有初始化权限表

 

3 解决办法

#cd /usr/local/mysql（进入mysql安装目录）
#chown -R mysql.mysql .
#su - mysql
$cd server
$scripts/mysql_install_db

 

4 本人解决过程

[root@localhost ~]# cd /usr/local/mysql

[root@localhost mysql]# chown -R mysql.mysql .
[root@localhost mysql]# su - mysql
[mysql@localhost ~]$ cd /usr/local/mysql
[mysql@localhost mysql]$ scripts/mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:
./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

[mysql@localhost mysql]$ /usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 11767
[mysql@localhost mysql]$ 120502 07:01:17 mysqld_safe Logging to '/usr/local/mysql/data/localhost.localdomain.err'.
120502 07:01:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
[mysql@localhost mysql]$ /etc/rc.d/init.d/mysql status
MySQL running (11830)                                      [  OK  ]
[mysql@localhost mysql]$ /etc/rc.d/init.d/mysql start
Starting MySQL                                             [  OK  ]

3安装python

4下载mysql-python

http://pypi.python.org/pypi/MySQL-python/1.2.4c1#downloads

用vi打开MySQLdb目录中的site.cfg文件，找到“mysql_config=”，修改后面的路径到你机器中mysql_config文件的路径。

mysql_config = /usr/local/support/mysql/bin/mysql_config  # 在site.cfg 里增加这一行 

1. sh setuptools-0.6c11-py2.5.egg    # 安装  
2.     PATH=$PATH:/usr/local/support/mysql/bin/   #增加mysql_config  到系统路径  
3.     echo "/usr/local/support/mysql/lib/mysql/" >> /etc/ld.so.conf  #增加折行到/etc/ld.so.conf 配置文件  
4.     ldconfig # 生效  
5.       
6.     python2.5  setup.py build;python2.5  setup.py install    # 尝试python2.5 编译安装  
7.     测试：  
8.     # python  
9.     >>> import MySQLdb  

 Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "MySQLdb/__init__.py", line 19, in <module>
    import _mysql
ImportError: libmysqlclient.so.18: cannot open shared object file: No such file or directory

错误的原因是未能引入libmysqlclient.so.18库，
查找库文件存在，于是建立链接：
ln -s /usr/local/server/mysql/lib/libmysqlclient.so.18 /usr/lib/libmysqlclient.so.18
问题解决。

5安装mod_wsgi

1. 为Apache的http.conf 添加一行：  
2.    LoadModule wsgi_module modules/mod_wsgi.so

6. 安装Django

[python]  view plain copy

1. wget  http://www.djangoproject.com/download/1.2.5/tarball/  
2.     tar xfz Django-1.2.5.tar.gz  
3.     cd Django-1.2.5  
4.     python2.5   setup.py  install   # 安装   
5.     # python2.5   
6.     >>> import django  
7.     >>>  

7.测试：                                             Source.self@gmail.com

[python]  view plain copy

1. 下面全部在命令行中执行：  
2. # mkdir /htdocs  
3. # cd /htdocs  
4. # /usr/local/support/python/bin/django-admin.py  startproject myproject  
5. # cd myproject  
6. # python manager.py runserver 0.0.0.0:8000  
7. 好了，现在访问 http://服务器IP:8000，看到“It works”了吧　^_^  
8. 正常后，Ctrl + C退出来，刚才那个是Django自带的测试服务器，下面在Apache上开通虚拟主机啦。  

 

8. 配置apache

[xhtml]  view plain copy

1. 54 LoadModule python_module modules/mod_python.so  
2. 55  
3. 56 <Directory "/htdocs">  
4. 57     AddHandler mod_python .py  
5. 58     PythonHandler django.core.handlers.modpython  
6. 59     SetEnv DJANGO_SETTINGS_MODULE myproject.settings  
7. 60     PythonDebug On  
8. 61 </Directory>  
9. 62 Alias /medias /htdocs/mddias  
10. 63 <Location "/medias/">  
11. 64     SetHandler None  
12. 65 </Location>  
13. 66  
14. 67 Alias /media /usr/local/support/python/lib/python2.5/site-packages/django/contrib/admin/media/  
15. 68 <Location "/media/">  
16. 69     SetHandler None  
17. 70 </Location>  
18. 71  
19. 72 <LocationMatch "(?i)/.(jpg|gif|png|txt|ico|pdf|css|jpeg)$">  
20. 73 SetHandler None  
21. 74 </LocationMatch>