Mosecparse / Mysql Issues After Moving Db To Another Drive
Jan 7, 2008
i moved mysql to another drive, and i am getting these errors
/etc/cron.hourly/modsecparse.pl:
DBI connect('modsec:localhost','modsec',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /etc/cron.hourly/modsecparse.pl line 19
Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19.
[root@viper ~]# ls -la /var/lib/mysql/mysql.sock
lrwxrwxrwx 1 root root 23 Jan 6 20:11 /var/lib/mysql/mysql.sock -> /home3/mysql/mysql.sock
the socket exists.
in cpanel - service manager mysql looks as down, and eximstats the same.
any idea where is the config for modsec and chkserv so that i could set the new mysql.sock location? maybe that will work.
My server has 2 drives, running on mysql 4.1.21. Can someone give me detailed instructions on how to move mysql to the secondary drive on the same server? The secondary drive has only /backup
Right now i have a busy running forum Running on a Single Xeon 5335 with 4GB of RAM,
single 73GB SCSI 15K. And the site seems running fine most of the time except at peak.
The load sometime goes up to 8 for about 1 hour. So i am looking to upgrade my server.
The next server i am thinking about is
Single C2Q 9300, 8GB of RAM, 1x750GB SATAII as primary drive for for webserver, 1x150GB Raptor 10K to serve MYSQL only.
I wonder if the HDD performance on my current server server with future server be the same of better? Since the future server has better CPU and RAM, the only thing i worry is the HDD performance.
So in short, Single SCSI 15K V.S Combination of SATA + RAPTOR. What do you guy think?
i am using Litespeed as webserver and i also will be using litespeed on future server.
We have a powerful server for our databases, 8 cores, 4gb ram etc because we have a huge amount of MySQL data. We store the data on a standard SATAII 500GB drive, would we notice a dramatic performance improvement if we stored the data on a SA-SCSI 10/15k drive?
I have a server that is running linux with cpanel and I am running out of space on a partition.
I was getting this error: Drive Warning: /dev/sda3 (/var) is 83% full
I looked in the folder and went to /var/lib/mysql and noticed that I have about 6 databases that are a little over 1 GB each. The sda3 partition only has a capacity for 9.9 GB and I was suggested to configure mysql to hold my databases on another partition that has more space..
1- i did Os Reload with new Hard drive for "home" 2- data "backups" drive lost
3- replaced the old home drive as "/old drive"
4- " /old drive " is now the secondry drive in my server and it has the all sites usres and evry thing
5- what i need , to trasfer, copy this sites from " /old drive " to "home"
but data center said
The /olddrive/home directory contains the contents that were previously in the /home directory. You can copy files from this directory to any other directory on your server.
The command to copy files in the UNIX environment is the "cp" command.
The user directories in /olddrive/home directory contain the web page files for the users. However, simply copying the contents over will not recreate the users or domain entries in DNS/httpd. If you wish these back you will need to recreate them manually or restore them from backups.
The server is displaying these errors when I tried to do an FSCK: Bad inode IO ext3-fs error (device(8,3)) IO Failure
I am having a new primary installed and old primary set as 2nd drive. I need to recover the cpanel domain accounts from this 2nd drive after I mount it with the method below:
mkdir /backup mount /dev/sdb1 /backup
However, how do I actually recover these accounts in an automated process via whm? I've done this before with the same matter (corrupt primary drive, mount as 2nd, etc) but cannot exactly remember the proper steps.
I just purchased a brand new 10K 150GB drive. How can I take an exact copy of my current drive and transfer everything over to the new drive? I think I need to create a snapshop, or mirror it somehow.
What software will do this? I was told trueimage, but its very pricy, is there anything else?
I have a dedicated box and I started getting Input/output errors today.
I tried: # fsck fsck 1.40-WIP (14-Nov-2006) e2fsck 1.40-WIP (14-Nov-2006) /dev/hda2: recovering journal fsck.ext3: unable to set superblock flags on /dev/hda2
then I tried: # fsck -a -t ext3 /dev/hda2 fsck 1.40-WIP (14-Nov-2006) /dev/hda2: recovering journal fsck.ext3: unable to set superblock flags on /dev/hda2
My data is backed up, so was going to ask for a reimage, but is this an indication of bad hardware? Should I ask for a replacement drive? Is there anything else I should try on my own before going to the host?
I have a Win2K3 server which has 2 hard drives. I was considering backup options and I thought that I might try mirroring Drive A ==> Drive B. I would think that, then, if Drive A has a hardware failure, I could simply switch Drive B into the Primary slot (A) and the server would continue to hum along as nothing has happened. This would reduce the downtime, hopefully.
I have 3 questions.
1. Is this idea practical (will it work)? 2. What is a good software program to use fto handle the mirroring? 3. Any considerations, warnings, technical advice in regard to this method?
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
I've got another server comming online shortly which will be used for shared hosting. A Q9550, 8 GB DDRs, 2 1 TB SATA drives in RAID 1. I know everyone has different opinions and reasons for their partitioning decisions, so I wanted to get a feel on how you would partition the drives durring setup, and why you would do it the way you do.
I need your opinion on the best drive configuration for my Dell poweredge 2850 dual 3.0.
I have 6 x 72gb scsi 10k hds, and perc4 raid in server. My os will be Cent os with 4 gigs of ram installed. I want to try to make this server as redundant as possible.
Offsite backup is also in plans. I’m going to use this server for a few sites (5 - 10) that are db driven, and host small video clips as Dolphin Smart Community. Server will be colocated. Please let me know if missed something .
im assembling my server now....waiting on the 90degree connectors. It is as follows:
SUPERMICRO CSE-512L-260B Black 14" Mini 1U Server Case ASUS M2N-MX SE Plus AM2+/AM2 NVIDIA GeForce 6100 Micro ATX AMD Motherboard AMD Athlon 64 X2 4200+ Brisbane 2.2GHz Socket AM2 65W Dual-Core Processor Dynatron A48G 70mm 2 Ball CPU Cooler - Retail 2gb ddr2 6400 ram Seagate 500gb 7200.11 32mb hdd WD 37gb raptor 10k rpm
the wd drive was lying around the house so i figured id add it since i had an extra slot and figured the speed wouldnt hurt.
My question is....how should i partition the drives.? I have 500+gb of space on 2 hard drives. I plan on using centos 5.1 and am downloading the iso now.
Now iam useing 320Gig SATA harddrive as my primary hard drive,i dont use 2rd harddrive,iam haveing pure download site,in TOP command 4.5%wa is this bit high? or can i add 2rd harddisk and move some data to there to reduce wa,but my load of the server is fine or any way to reduce wa?
Just got this server setup, getting some smart errors. Here's a copy of the trouble ticket I posted to the host, they said "If you read through the documentation for smartd you will find that from the results you pasted, your hard disk passed every test. We can give you another hard disk if you want but we will have to charge you 3 credits for the reinstall of the operating system." I could be wrong, maybe everything's fine, but the fact that there are unreadable sectors reported has me a little worried.
Quote:
What is the nature of the problem?
New server, hard drive failing smart tests
What is the error message?
Sep 12 17:51:43 sls-db8p19 smartd[3312]: Device: /dev/hda, found in smartd database. Sep 12 17:51:43 sls-db8p19 smartd[3312]: Device: /dev/hda, is SMART capable. Adding to "monitor" list. Sep 12 17:51:43 sls-db8p19 smartd[3312]: Monitoring 1 ATA and 0 SCSI devices Sep 12 17:51:43 sls-db8p19 smartd[3312]: Device: /dev/hda, 2 Currently unreadable (pending) sectors Sep 12 17:51:43 sls-db8p19 smartd[3312]: Sending warning via mail to root ... Sep 12 17:51:43 sls-db8p19 smartd[3312]: Warning via mail to root: successful Sep 12 17:51:43 sls-db8p19 smartd[3312]: Device: /dev/hda, 2 Offline uncorrectable sectors Sep 12 17:51:43 sls-db8p19 smartd[3312]: Sending warning via mail to root ... Sep 12 17:51:44 sls-db8p19 smartd[3312]: Warning via mail to root: successful
I use the second hard drive as backup drive. Today as normal i check the backup directory and try to use ls command. I got this warning [root@xxxxxx backup]# ls
I want to start selling vps to customers but don't want to over load my existing drive/ server would it be beneficial to sell vps off a second drive so im keeping my shared hosting separate from the vps hosting
My server has 2 drives,one is backup drive. The backup drive seem to be failing so i decide to remove it. However when i remove it,the system can not boot. ANyone got this issue?
I've been on shared hosting for nigh on 3 years now. My site suddenly started growing rapidly recently and my shared host now has requested that I move onto a VPS or Dedicated as soon as possible (I would stay with them, but they don't have VPS options sadly)
My site is an image host, a dynamic image host too.
About 80% of my visits are from the US so I have decided, even though I am UK, that I need a US VPS.
I need it to be cheap, like $30 (To start with, while I gain funds) and generally reliable.
Would anyone know where such VPSs are? I would like 300MB or more RAM and about 5-10GB of disk space. My main issue right now is quality of customer service, I don't want to end up with a company that either has poor customer service or puts extreme restrictions on activity.
I have two reseller accounts at the moment, where all my domains are spread out at the moment. And I have just purchased a VPS from SolarVPS, and I'm awaiting the account details. Is there a way that I can transfer the sites across easily, such as creating a full backup and then restoring on the new VPS, or would I have do it individually for each website?
It's now coming to the point where I really want to consolidate all of our kit (mainly in the UK) and move to our own AS number, now I already know what routing equipment we're going to use and that is appropriate for the amount of traffic we need to carry, but what I'm stuck with now is which transit providers to use. I don't mind spending a reasonable amount on transit, but not stupid amounts. It also doesn't matter where I can pick these up as the plan we have includes our own links between buildings.
First of all let me say this is going to be a very slow process, so please do not PM me with your offers for transit, I'm not interested.
The plans are to peer at a couple of exchanges, most likely LINX and Xchangepoint, and to pick up around 3/4 transit providers. Because most UK traffic goes via peers, what I'm really looking for are the bigger providers to improve transatlantic routes rather than smaller providers which just make the hop count longer, my shortlist is currently:
I'm moving from a VPS to a dedicated server and most of the files/databases have been transferred.
I have a folder (with files) in the /usr/local/ folder of the VPS (chatroom software), is there anyway I can transfer them to the dedicated server in its /usr/local folder through SSH/Telenet?
I have used it before to move my MYSQL database but I was following step-by-step instructions from Vbulletin, I guess this will be different compared to transferring a database backup.
This is a little samba guide from my own experiences of how to map a network drive under windows 2000 to a Linux server. I am not technical expert and this guide is the result from my trail and error.
What's Samba?
Samba allows Linux computers to share files and printers across a network connection. By using its SMB protocol, your Linux box can appear in Windows Network Neighborhood or My Network Places just like any other windows machine. You can share files this way, as well as printers. By using samba on my home network, for example, my Windows machines have access to a printer directly hooked up to my Linux box, and my Linux box has access to a printer directly hooked up to one of my Windows machines. In addition, everyone can access everyone else's shared files. You can see how samba can be very useful if you have a network of both Windows as well as Linux machines.
My OSs
Windows 2000 RHEL 3 (Redhat Enterprise Linus)
My goal
Map a network drive to Linux servers, so that I can access the Linux files under windows 2000.
Installation
Most Linux should have Samba already installed. But if it hasn't install, you can find at in http://rpmfind.net or using up2date command "up2date -i samba". You can also get it at http://www.samba.org
Then you can install it by tying the following Command:
Install:
rpm -i samba.rpm
Upgrade:
rpm -U samba.rpm
Configuration
Samba conf file is located at /etc/samba/smb.conf, allows you to specify which resources on the Linux machine you wish to share and who they can be accessed by.
Samba provide a full version conf if it's fresh install. But most of the times, we don't really need all of these options. So I provide my own conf here, which is rather simple, but it makes things work.
[Downloads] comment = Downloads path = /path_to_your_sharefolder browseable = yes writable = yes public = yes read only = no
[homes] comment = My Home Directory browseable = yes writable = yes public = yes read only = no
[printers] path = /var/spool/samba public = yes guest ok = yes printable = yes browseable = yes writable = yes read only = no
Just replace workgroup to your windows workgroup name, your_windows_machine_IP and /path_to_your_sharefolder. If you don't need printers sharing, you don't need to have printer section.
Setup Samba Users
Since we're using user level security, we need to setup samba users. This can be easily done by using Webmin. You can go to Server --> Samba --> Convert Unix users to Samba users, you can just covert all your existing Linux users and set them password under the icon "Edit Samba users and passwords" later.
If you don't use webmin, you can also type the following command:
Replace username with each of your user's usernames. You will then be prompted to enter a password for this user account.
Samba Service
Now, it's time to start your samba server:
service smb start service smb stop service smb restart
Once the computer is restarted or shutdown, the samba service won't start up again in next boot up. I use webmin to make it startup at boot time.
Windows 2000 Configuration
1. Under windows 2000, you can got to windows explorer --> Tools --> map a network drive 2. select drive letter 3. enter the path (e.g. your_server_ipDownloads) 4. click connect using different user name 5. enter your samba usernaem and password that you just set 6. You can connect to your Linux machine now!
This method work for me. If there is any correction or improvements, please let me know.
