CentOS 5 :: What Needs To Be Installed For A Working Webserver/database
Aug 9, 2009
I have a dedicated server running Centos 5.2. I have a Wordpress MU site that's setup over apache 2, mysql 5, php5, and I use phpmyadmin as well. I'm able to read the database as my website appears perfectly fine, however, I can not write to it. What exactly do I need to install on my Centos sever to allow my site to interface with the database? I've used shared servers and VPS's with no problems but this just won't work. The support team seems clueless and I'm ready to ask them to reinstall my entire OS and everything else again.
I am looking for advice on a what I am sure is a very basic procedure but I have never had to set this up before and am not sure where to start.
I am running 2 CentOS5.3 boxes. I have one webserver connected to the internet and behind a firewall. I would like to set up the 2nd server (database) behind the webserver and completely inaccessible from the internet. Ideally so it can only be accessed by first ssh'ing onto the webserver and then ssh'ing from there onto the database. The webserver connecting locally to database.
From what I have seen it looks like I need to set this up using NAT but I have never done this and do not know what is involved. Can someone point me in the right direction and optimally outline the steps I need to take to hook this up? Do I need to worry about any specific hardware configuration as well?
The issue is i am using the RHEL server as my webserver and database centre. Now its a brand new formatted server with good amount of RAM and the usage is not much. Its being accessed locally over the LAN. But still i can see speed deficiency. Some of the pages do not get loaded and some times i can see the delays in loading the new pages. Any idea y is it so? Or is there anything i can do to increase the speed?
I try to update my kernel to 2.6.18.128.4.1.el5 using # yum update
After # yum update # rpm -qa kernel*|sort gives the following: kernel-2.6.18-128.1.14.el5 kernel-2.6.18-128.1.16.el5.centos.plus kernel-2.6.18-128.4.1.el5.centos.plus kernel-2.6.18-92.1.18.el5 kernel-2.6.18-92.el5 kernel-devel-2.6.18-128.1.14.el5 .....
This my grub.conf: # Note that you do not have to rerun grub after making changes to this file # NOTICE: You have a /boot partition. This means that all kernel and initrd paths are relative to /boot/, eg. # root (hd0,0) # kernel /vmlinuz-version ro root=/dev/VolGroup00/LogVol00 # initrd /initrd-version.img #boot=/dev/hda default=1 timeout=5.....
yum update installed: CentOS (2.6.18-128.4.1.el5.centos.plusxen) and CentOS (2.6.18-128.4.1.el5.centos.plus)
both are not working. I have to run the system using: 2.6.18-128.1.14.el5. Upon trying again #yum update it says that no packages are marked for update. Can I manually install the desired kernel? Do you know a reason why yum update is not automatically installing the proper kernel?
The other day there were a number of updated needed on my server which I installed with yum (the software updater GUI). Now my websites are not coming up even on the server using http://localhost
I reviewed the info and found that httpd was updated to 2.2.3-45 and am suspecting that this is the cause of the issue. So my silly little question is how do I roll back this update?
Ok let's say I have Apache Webservers on 2 different machines within my network, I have http://outterABC.com setup at dyndns.org to point to my modem at home, and my router forwards Port 80 to the ServerA Machine (i.e. 192.168.0.3). I can access my webpage I setup for the Server A Machine.
But what I want to try and do is somehow access my ServerB machine's website that is on my same network. I tried something like this http://ServerB.outterABC.com and the apache page came up with something like the page wasn't available. I want to access the content of the ServerB website, but because I have only one router, i can only forward Port 80 site traffic to my ServerA machine's website. I'm sure it's a different syntax I should use but i'm just not sure what I should enter to bring up the apache root web page for the Server B website via http://outterABC.com
I tried setting up DNS A records on ServerA, but I don't think it will work with what i'm trying to do above.
Long term Fedora user, I have recently decided to set up a small shuttle computer as a media centre (using mythTV), data store/NAS (so all my data is centralized), mini web server, etc. After installing I had the fun of trying to get my audio working correctly (which I did eventually .. after finding out I unplugged the audio after the second reboot and solved it after somewhere). After this, I got internet video searching working through mythTV using adobe Flash. I then went to bed only to find the internet not working (can't telnet, can't traceroute, can't anything). This is both as the mythtv user I have set up and as root.
The setup I have is: PC -> router -> interweb 192.168.1.7 -> 192.168.1.1 -> interweb
I also have a laptop (F12) which is on 192.168.1.5. The laptop has access to the internet just fine (no problem at router / interweb). I have the only access to the router and disabled any ISP access (no changes in router). I have the only access to the PC (no changes in PC). I have set SElinux to permissive (no selinux issues). I have temporarily disabled iptables on the PC (not firewall issue).
So, I decided to look at the differences between my two machines on the network. Initially the PC was missing the route: 169.254.0.0 0.0.0.0 255.255.0.0 U 1002 0 0 eth0 I changed the services on startup so thet 'NetworkManager' was off, but 'network' started (exactly like my laptop). I turned off avahi-daemon, and any other network sort of daemon which doesn't match my laptop (which I have also customized).
I then set my eth0 config file to this: Code: # nVidia Corporation MCP77 Ethernet DEVICE=eth0 HWADDR=00:30:1B:47:C4:FF ONBOOT=yes BOOTPROTO=none TYPE=Ethernet DNS1=192.168.1.1 USERCTL=yes IPV6INIT=no # DEFROUTE=yes IPV4_FAILURE_FATAL=yes # NAME="System eth0" # UUID=5fb06bd0-0bb0-7ffb-45f1-d6edd65f3e03 IPADDR=192.168.1.7 NETMASK=255.255.255.0 NM_CONTROLLED=yes GATEWAY=192.168.1.1 MTU=1432 # PREFIX=24
Commented out any lines which I didn't recognize. So, right now netstat -rn returns: Code: Destination Gateway Genmask Flags MSS Window irtt Iface 192.168.1.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0 169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 eth0 0.0.0.0 192.168.1.1 0.0.0.0 UG 0 0 0 eth0
/etc/sysconfig/network: Code: NETWORKING=yes HOSTNAME=sophie And to me everything looks OK.
I even have inter-communication working fine (I can SSH between the two servers no problems - 192.168.1.7 <-> 192.168.1.5). I can do DNS queries from both just fine (nslookup google.com returns fine). I just can't get any information back from the net. Would it be work me doing a tcpdump or wireshark dump etc ('tcpdump > file' would be easier for me)?
So in my first ever attempt at Linux (and servers) I was able to set up a working web server that is visible from outside my network and created a simple PHP page thanks to this tutorial. I installed MySQL and have some experience with MS SQL but have no clue how to get started setting up databases and writing procedures in MySQL. I know all the syntax about writing scripts for MySQL (assuming it's the same as SQL) but I don't know how to get started. Do I need to be on the web server or can I do it remotely? Is there a front end GUI that everyone uses?
Im running drupal on my webserver and, this morning all of the sudden I went to edit a node and now I cant load the website in my browser at all. I can ping the machine and SSH into it fine, but it will not load the website in chrome or IE, I have no idea whats going on here.
Edit: I did a 'service httpd restart', it took 3mins to restart, is this normal? After I did that it loaded once, not even all of the page, now its doing the same thing again.
I use VPS because when i was on share hosting. My website was hacked by hacker. Now i'm using VPS. I want to ask how to update webserver application such as Mysql, phpMyAdmin, lighttpd I use centOS 5 i386 and i use Kloxo Panel. I was already installed Mybb.
not able to installed openfire database setting standarad connection below error i have got, if anybody has installed openfire thenchecked error log but no use )A connection to the database could not be made. View the error message by opening the "/logs/error.log" log file, then go back to fix the problem.
I previously installed centos using DHCP. Now I purchased a domain name and want to set it up as a webserver. if I choose the static ip address based on the existing DNS server given to me by the domain company, it will ask for the subnet mask, default gateway and i do not have them.
I am trying to configure a BIND DNS server to handle three websites on my home network, (my site, my sons site and our test site). Since my ISP uses dynamic DNS, we are using DNS2GO to redirect our traffic, 9EACH SERVER HAS IT'S OWN VERSION OF dns2go running).My problem is that I can't figure out how to configure BIND since I don't have a static IP to enter into the named.conf or reslov.conf configuration files.
Im trying to make a webserver at home. I have a static IP Address of my ISP (o2) I have built a server ( 2.8 p4HT, 2GB Ram, 500GB HDD) Just to test... But, i dont know what to do in the IP Address settings for the IPv4 ( I think thats what it is) Do i put my static IP address in my ISP gave me, or the local IP of the server ( Wich is 192.168.1.72) Im realy confused. Ive tried everything i can think of, Reinstalled the os about 40 times up to now...
I have 4 centos5 apache webservers all on the same network, recently, 2 of the webservers have stopped being able to ping or browse one particular website where feeds are obtained from this site. I have checked and firewall and selinux settings are disabled. The two webservers are able to ping and browse other sites. Dns settings are the same for all 4 servers. traceroute for working and not working webservers are the same.
I know I've got inotify-tools installed; I've got a daemon that runs and it's using inotifywait to move some files around.
This thing is: 12:20:16 /home/barrie $ >> dpkg --get-selections | grep inotify* 12:20:29 /home/barrie $ >> aptitude show inotify-tools Package: inotify-tools New: yes State: not installed Version: 3.12-1 Priority: optional Section: misc Maintainer: Peter Makholm <peter@makholm.net> Uncompressed Size: 115k Depends: libc6 (>= 2.6-1), libinotifytools0 Description: command-line programs providing a simple interface to inotify inotify-tools is a set of command-line programs for Linux providing a simple interface to inotify. These programs can be used to monitor and act upon filesystem events. inotify-tools consists of two utilities: inotifywait simply blocks for inotify events, making it appropriate for use in shell scripts. inotifywatch collects filesystem usage statistics and outputs counts of each inotify event.
12:20:40 /home/barrie $ >> It's not showing up as installed! If not how to get the list of installed packages 'reloaded'. I've googled for hours and reloading the installed packages doesn't look promising!
I've just installed Xubuntu 10.10 and I installed phppgadmin on it but when I connect to postgres it automatically closes the session and I can not access the database. I tried via pgadmin3 graphically and there is not problem.
I have setup a Linux Centos with apache server on it in a home network. Everything works fine. When I access the webserver I put in the address bar the IP address of the server which is 192.168.0.150 and when hit enter, it prompts the page where I have to put login information. The login information is set to: username: admin@localhost.local password: *************
It takes long time for authentication go through and load the page eventhough I am accessing the site in a same home local area network with fast ethernet connection. How can I change the localhost.local to something else like maybe [URL] instead and if I have to change settings in other files as well?
I am new to Linux and ave installed Ubuntu on my system along with Windows XP (Dual boot). I would like to find out if there is a way to share a database between these two operating systems.
Currently, I have a Microsoft Access database which I would like to use in either OS. I understand that Access probably won't work in Linux so I am willing to go to a different DB application as long as I can access it from both operating systems. Database is very simple. It allows you to input into an Access Form and then allows you to print a simply one page report based on the data just entered.
I an running a script Database backup script in my server.It is thworing error ,i have checked permissions for root@localhost , root has all privileges.
### MySQL Server Login Info ### MUSER="user" MPASS="password" MHOST="localhost"
[code]....
and it is throwing error
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
This situation after a mains power failure took server down.Log oonto server with root, go to Admin > users and get this message:" The user database cannot be read. This problem is most likely caused by mismatch between /etx/password and /etc/shadow or /etc/group and /etc/gshadow. The program will exit now."
I am trying to get a script to run, that will backup all my databases. The script is called automysqlbackup.sh (chmod 744), I have filled in the blanks and placed this into /etc/cron.daily I have checked that crond is running. Nothing happens, the databases are not backed up. I am at a loss, can anyone tell me what i am doing wrong. The script is shown below:
I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard
100m ext2 boot 2000m swap * / ext3
now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?
I have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
I just installed mysql and need to move the databases to a new location.I say 'no problem' I shutdown mysql (service mysqld stop) I configure my.cnf to point to the new location, which in my case is: /mnt/data/mysql. I know not very original naming. I do the old chown -R mysql:mysql /mnt/datal/mysql AND I copy all the files over (cp -R /var/lib/mysql /mnt/cgsvol/mysql) chmod 777 /mnt/data/mysql I ensure the chown worked (ls -a -l) and the files are there from the old directory. I can't load the daemon again. I check the log (/var/log/mysqld.log) and it can't write any test file to that directory.
(log file exact data). 091107 23:22:21 mysqld started 091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$ 091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
I would like to install this software on linux server for purpose of system reporting. I have all the installation software and the system's specification is based on system need.
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
I have created a website in php.wamp server is used to run the site.i created the database in phpmyadmin using mysql.These all were done in windowsXP.Now I want to import it into redhat linux system.how can I import database and its tables to rhel4 inorder to working the website properly
