Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]
I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.
070130 17:59:41 mysqld started
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 mysqld ended
how I would repair that to get mysql to start again?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Table Marked As Crashed.
I have a table that is showing MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired) I've repaired it via mysqlcheck --repair --all-databases that didn't work. I've tried find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r as well with no luck. I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated. It's like there is a table where this data is kept, but I've looked and can't find anything.
View Replies!
View Related
MySQL Table Crashed
Table '231_message' is marked as crashed and should be repaired I haven't ever had this happen, is all my data truely lost or can i 'repair' it i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame ) either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
View Replies!
View Related
How To Delete Some Crashed/messy MySQL DB
When I try to remove a DB it is giving this error into phpMyAdmin: #1051 - Unknown table 'seccion,anuncio,lengua,ciudad,email' After mysql check the errors are: Repairing tables user_db.anuncio error : Table 'user_db.anuncio' doesn't exist user_db.ciudad error : Table 'user_db.ciudad' doesn't exist user_db.email error : Table 'user_db.email' doesn't exist user_db.lengua error : Table 'user_db.lengua' doesn't exist user_db.seccion error : Table 'user_db.seccion' doesn't exist user_dbTest.anuncio error : Table 'user_dbTest.anuncio' doesn't exist user_dbTest.ciudad error : Table 'user_dbTest.ciudad' doesn't exist user_dbTest.email error : Table 'user_dbTest.email' doesn't exist user_dbTest.lengua error : Table 'user_dbTest.lengua' doesn't exist user_dbTest.seccion error : Table 'user_dbTest.seccion' doesn't exist How this can be fixed and the MySQL DB to be dropped ?
View Replies!
View Related
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Server Crashed
my linux server crashed today. I found these are the last line in the log file just before i crashed. Mar 8 07:21:00 myserver xinetd[5376]: warning: can't get client address: Connection reset by peer Mar 8 07:21:13 myserver xinetd[5395]: warning: can't get client address: Connection reset by peer
View Replies!
View Related
Server Crashed
I've been with 3 dedicated hosts since 2005 and my sever experienced the first ever crash yesterday. I wanna know if any of you have experienced a crash once and not have it happen again after that time. As this is the first occurence, I'm feeling uneasy about the server stability.
View Replies!
View Related
Apache Crashed - Any Ideas?
This morning, apache crashed on the server that I assist a friend of mine (junglecat here) with. We finally managed to get it up and going - for some odd reason, restarting apache/httpd via Cpanel wouldn't get it going, but SSHing and typing via command line would. I downloaded the apache error log, and it's CHOCK full of this, repeating over and over (and over) again: DBD::mysql:t bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first) at email.pl line 55. DBD::mysql:t fetch failed: fetch() without execute() at email.pl line 56. Use of uninitialized value in concatenation (.) or string at email.pl line 59. Use of uninitialized value in concatenation (.) or string at email.pl line 61. Use of uninitialized value in concatenation (.) or string at email.pl line 76. Have tried searching and either I'm not using the correct terms, or this doesn't happen that much (I am betting on the former). Any ideas?
View Replies!
View Related
E-mails Are Getting Marked As Spam
One of my e-mail addresses - steve@acme.ie - is regularly marked as spam. My mail server is not blacklisted. My e-mails are always plaintext, and only sometimes have URLs in them. Looking at my mail server health everything looks ok except for what I assume are reverse DNS entries for my domain. So I'm guessing this is the problem. So... 1. Do I need to ask my hosting company (I have a dedicated server with the planet) to set up reverse DNS entries for all my domains, or can I do this manually? Note I use my own DNS server, I do not use the hosting company's DNS server. 2. Will it be a problem that all my domains (dublinjobs.ie, acme.ie, etc.) use the same IP?
View Replies!
View Related
Email Sent Being Marked As Spam
One of my clients is trying to send an email to someone who has barracuda spam filter on their systems. the spam filter is rejecting the email and marking the IP address as poor. The IP address that it is rejecting is not the address of the SMTP server but the PC address (Outlook client). is this normal to check the client pc IP address and not the SMTP server? The response from the spam filter includes a link to check the IP address which reports the IP address status as "poor". The problem is this IP address is a dynamic IP assigned by the clients ISP. I tried a couple of IP addresses within the same subnet and they all seem to be marked as poor. Does anyone have any suggestions on how I can fix this issue?? I have included the (masked) response from the spam filter below: Code: From: Mail Delivery System [mailto:Mailer-Daemon@my.webhostsserver.com] Sent: 21 May 2009 12:51 To: clientemail@clientdomain.com Subject: Mail delivery failed: returning message to sender This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: to@emailaddress.com SMTP error from remote mail server after end of data: host mail3.emailaddress.com [193.XX.XXX.91]: 554 Service unavailable; Client host [my.webhostserver.com] blocked using Barracuda Reputation; [url] ------ This is a copy of the message, including all the headers. ------ Return-path: <clientemail@clientdomain.com> Received: from [82.XXX.XXX142] (helo=JohnD) by my.webhostsserver.com with esmtpa (Exim 4.69) (envelope-from <clientemail@clientdomain.com>) id 1M76nq-0002SF-Jh; Thu, 21 May 2009 11:51:17 +0000 From: "John Doe" <clientemail@clientdomain.com> To: "'Paul Smith'" <to@emailaddress.com> Cc: "'Someone Else'" <someoneelse@adomain.com> Subject: Week commencing the 30th June Date: Thu, 21 May 2009 12:51:09 +0100 Message-ID: <003601c9da0a$7365a865$5a30f920$@jdoe@clientdomain.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0037_01C9DA12.D53A1060" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcnaCm5j32za/IgbRHavuUl2ZVBwWA== Content-Language: en-gb
View Replies!
View Related
Phpmotion Causes Server Crashed
about a video sharing website. I found phpmotion [url] and thinking about using this script, not only it is free but also it has the funtion that alow direct transfer video files from youtube to my server. Moreover, the phpmotion community is lovely. The problem is that my hosting provider said this script is bad. Quote: While it will run on our servers I have heard nothing but bad things about this software on our servers. For quite a while it has caused issues to the point of crashing our servers but just recently (in the last couple days) we have found ways to put limits on our systems which should effect other programs/processes which will prevent this software from crashing our servers so whether or not this would be ok to run on our servers is a big *maybe* Alot of the issues appear to be related to the fact the software runs php by executing it via shell using the php executable which isn't really good considering that on our servers it will always make it use php4 which might not be what your site is running. PHPMotion is pretty much the only software I have heard discussed and has caused major issues on our servers so if you could avoid it I would definitely suggest you do! If you asked me about any software which is reported to have/cause problems on our servers without even mentioning phpmtion I would have answered phpmotion as that is the only one I have heard of which causes tons of issues. my questions are: 1. Do you have the same experiences with phpmotion? 2. How can I reduce the problem? 3. If phpmotion is really bad, which video sharing script should be recommended?
View Replies!
View Related
SPF (Email Marked As Spam)
I have a dedicated server in which i host 4 web sites using plesk one of them is mysite.com. That one is also set for ns1.mysite.com ns2.mysite.com. (all domain names below are just example names) Dns records for my apple.com orange.com and banana.com uses ns1.mysite.com and ns2.mysite.com my name server is also in the same machine. In orange.com dns settings are as follows. Code: 80.111.11.11 / 24PTRorange.com orange.com.NSns1.mysite.com. orange.com.NSns2.mysite.com. orange.com.A80.111.11.11 orange.com.MX (10)mail.mysite.com. orange.com.TXTv=spf1 a mx include:gmail.com,yahoo.com,hotmail.com ~all ftp.orange.com.CNAMEorange.com. mail.orange.com.A80.111.11.11 webmail.orange.com.A80.111.11.11 www.orange.com.CNAMEorange.com. 80.111.11.11 is dedicated ip for orange.com. The PROBLEM: The thing is whenever the server sends email it is flagged spam by yahoo, hotmail etc. I have created SPF for my orange.com but it is still marked as spam... I have checked dns report for both mysite.com and orange.com but they seem to be OK with no warnings either. I want to create a spf record or make somthing so the emails does not marked as spam.
View Replies!
View Related
Retrieve Data From Crashed Server
Does anyone know of any services that can help retrieve data from a crashed server. The server is managed but the support are saying that they are having problems retriving the data. The server had an os reload and they can't slave the old disk.
View Replies!
View Related
Recover Data From Crashed Server
I have a crashed HD that I want to recover the data. I wonder if there is any method or software out there that can do this for me. The hard drive is installed with centos and uses ext3 filesystem. I have tried doing a mount, not if it is done correctly, but I only see "lost+found" on the hard drive. Usually when this happens on my hard drive w/ windows, I use some data recovery software to extract the data. I don't know which software will do this for me on an ext3 filesystem running centos.
View Replies!
View Related
Email From Server Is Marked As Spam
I just installed the latest version of PHPList (Email manager program) on our client's dedicated server. The dedicated server is using Linux with Apache and PHP version 4.4.4. When I try to subscribe to the newsletter I am suppose to receive a confirmation email. Unfortunately my company's email host blocks this email thinking it's spam and I so I never receive the confirmation email. I then installed the exact same version of PHPList on a shared server with Linux, Apache, and PHP 4.4.4. Using this setup I received the confirmation email. So it seems like the server is the problem and not the software. The IP address of the dedicated server is not blacklisted. Actually the IP address just came into existence in January 2007. It really makes no sense to me why emails coming from the dedicated server are marked spam, but emails coming from the shared server are fine. Both servers are hosted by Hostgator. I am clueless as to what action to take next. Are there any server settings that could fix this problem? Any ideas is greatly appreciated.
View Replies!
View Related
My Server Marked As Abuse: Spam
I have a client on my server from ThePlanet. That client sends a newsletter once a week to about 50,000 recipients with a program that i built. The list was purchased from a company that sells targeted directory listings. Each email has a very clear opt out link, and one click takes them off the list. There is also a direct link to the contact form, as well as the information of the company sending the mass emails (me). This should satisfy all regulatory requirements to comply with existing laws. Now, these emails have been sent once a week for about a month now. Today, ThePlanet issued a support ticket entitled "Abuse: Spam Source". It seems that there was a problem from aol, and one of the emails was redacted. Reading through ThePlanet terms of service, it seems that they only allow closed system mass mailings. So now I am faced with a problem, because I have a client who expects to send out emails next week with a system i built, and I have a hosting provider that is demanding some sort of "proof" that these emails are solicited. For the record, this newsletter isn't junk spam like selling viagra or pumping a stock. It is a free weekly summary of significant new york appellate cases, and it has been very well received by the attorneys on the mailing list. There have been ridiculously few opt outs ( < 2%), and there have been literally *hundreds* of emails coming back to show their gratitude for the free service. Not even one comment has been negative. So what can I do now? A significant number of attorneys on this list are expecting the newsletter, but it cant be sent due to this problem. The best that I could come up with so far is to send an "Opt in" mass email, where users must click the link to opt in, and everyone else would be removed from the mass email. I could then use the unique keys used for opt ins as "proof" for ThePlanet that the emails are solicited.
View Replies!
View Related
Server Crashed: Kernel Panic
Today my server just crashed instantly... It was running fine with a load of 0.12 but then it went down all the sudden. After a reboot I checked the /var/log/messages file and saw this: Code: Mar 23 15:57:00 alpha kernel: Unable to handle kernel NULL pointer dereference at virtual address 00000020 Mar 23 15:57:00 alpha kernel: printing eip: Mar 23 15:57:00 alpha kernel: c017292b Mar 23 15:57:00 alpha kernel: *pde = 2085d001 Mar 23 15:57:00 alpha kernel: Oops: 0000 [#1] Mar 23 15:57:00 alpha kernel: SMP Mar 23 15:57:00 alpha kernel: Modules linked in: ipt_TOS iptable_mangle ip_conntrack_ftp ip_conntrack_irc ipt_LOG ipt_limit ipt_multiport ipt_state ip_conntr ack ipt_owner ipt_REJECT iptable_filter ip_tables autofs4 i2c_dev i2c_core sunrpc md5 ipv6 dm_mirror dm_mod button battery ac uhci_hcd ehci_hcd e1000 floppy ext3 jbd ata_piix libata sd_mod scsi_mod Mar 23 15:57:00 alpha kernel: CPU: 0 Mar 23 15:57:00 alpha kernel: EIP: 0060:[<c017292b>] Not tainted VLI Mar 23 15:57:00 alpha kernel: EFLAGS: 00010246 (2.6.9-42.0.3.ELsmp) Mar 23 15:57:00 alpha kernel: EIP is at dnotify_flush+0xe/0x70 Mar 23 15:57:00 alpha kernel: eax: c0446c40 ebx: ca05dd80 ecx: 0046ef00 edx: f1d95300 Mar 23 15:57:00 alpha kernel: esi: 00000000 edi: ca05dd80 ebp: f1d95300 esp: eb3f3fa0 Mar 23 15:57:00 alpha kernel: ds: 007b es: 007b ss: 0068 Mar 23 15:57:00 alpha kernel: Process httpd (pid: 28057, threadinfo=eb3f3000 task=efaf03b0) Mar 23 15:57:00 alpha kernel: Stack: ca05dd80 00000220 f1d95300 eb3f3000 c015a7e5 0000020f bff65b64 bff65af0 Mar 23 15:57:00 alpha kernel: c02d47cb 0000020f 0046eff4 08cd4e6c bff65b64 bff65af0 bff615b8 00000006 Mar 23 15:57:00 alpha kernel: c02d007b 0000007b 00000006 0032a7a2 00000073 00000246 bff61598 0000007b Mar 23 15:57:00 alpha kernel: Call Trace: Mar 23 15:57:00 alpha kernel: [<c015a7e5>] filp_close+0x49/0x5f Mar 23 15:57:00 alpha kernel: [<c02d47cb>] syscall_call+0x7/0xb Mar 23 15:57:00 alpha kernel: [<c02d007b>] packet_rcv+0x17e/0x307 Mar 23 15:57:00 alpha kernel: Code: 00 89 c3 85 d2 74 0e 8b 42 04 8b 12 25 ff ff ff 7f 09 c1 eb ee 89 8b 34 01 00 00 5b c3 55 89 d5 57 89 c7 56 53 8b 40 08 8 b 70 10 <0f> b7 46 20 25 00 f0 00 00 3d 00 40 00 00 75 4d 8d 46 68 e8 fb Mar 23 15:57:00 alpha kernel: <0>Fatal exception: panic in 5 seconds Mar 23 16:06:46 alpha syslogd 1.4.1: restart. So it seems like httpd crashed my server? I checked the Apache error_log and noticed lines like these: Code: *** glibc detected *** free(): invalid pointer: 0x08872c98 *** [Fri Mar 23 15:57:03 2007] [error] [client x.x.x.x] Premature end of script headers: /home/user/public_html/forum/index.php [Fri Mar 23 15:57:03 2007] [error] [client x.x.x.x] File does not exist: /home/user/public_html/500.shtml When I look at the whole error_log it seems like such errors appear frequently and for different websites and PHP applications. This isn't the only glibc error, there's also stuff like "*** glibc detected *** corrupted double-linked list: 0x088e0bb8 ***". I have recently installed eAccelerator and searched the web: I'm not the only one who has such problems with eAccelerator. Do you think these glibc errors may have caused the server to crash? Also, lately I noticed a lot of lines like these in the /var/log/messages file: Code: Mar 23 15:47:45 alpha kernel: post_create: setxattr failed, rc=122 (dev=sda7 ino=4318565) and Code: Mar 23 15:50:56 alpha ntpd[2958]: sendto(66.111.46.200): Operation not permitted I've done some Google'ing on the first error and it seems like someone with the same error got it fixed by running a filesystem check... By the way /dev/sda7 is my /home directory. But in order to run a filesystem check I need to disable all services and unmount /home? That's kind of a pain in the ***... In general, how long do you think it takes to run a filesystem check? Here's information about my /home partition: Code: /dev/sda7 198G 71G 118G 38% /home
View Replies!
View Related
Gmail Marked Email As Spam
my perfectly legitimate emails are being marked as spam. I have no clue why. I run postfix, all hostnames are supposedly configured correctly. Here's the headers Quote: Delivered-To: email@mapletip.com Received: by 10.114.121.9 with SMTP id t9cs693254wac; Sat, 4 Aug 2007 18:44:05 -0700 (PDT) Received: by 10.90.54.4 with SMTP id c4mr3981359aga.1186278245304; Sat, 04 Aug 2007 18:44:05 -0700 (PDT) Return-Path: <email@mapletip.com> Received: from localhost.localdomain (251.102.232.72.static.reverse.ltdomains.com [72.232.102.251]) by mx.google.com with ESMTP id 6si5888223agb.2007.08.04.18.44.04; Sat, 04 Aug 2007 18:44:05 -0700 (PDT) Received-SPF: pass (google.com: domain of emailsupport@mapletip.com designates 72.232.102.251 as permitted sender) Received: from www.mapletip.com (localhost.localdomain [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id 7AB1448224 for <life@mapletip.com>; Sat, 4 Aug 2007 20:44:23 -0500 (CDT) Date: Sat, 4 Aug 2007 20:44:23 -0500 To: test@mapletip.com From: MapleTip Email Support <email@mapletip.com> Reply-to: email@mapletip.com Subject: MapleTip Site - Question Message-ID: <8ceb3a16956f9d6e147d3c4f81ca0747@www.mapletip.com> X-Priority: 3 X-Mailer: PHPMailer [version 1.73] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="iso-8859-1"
View Replies!
View Related
DNS Server Crashed - Rebooting Has No Effect
I'm hosting proxy sites on my vps and untill yesterday my proxy worked fine with no problems at all. But while going trough my server graphs I found it odd that I had 0 bandwidth since the middle of yesterday.. I first supposed that this was due school's out [url]but this wasn't the reason I found out! I tried testing one of my proxies to see if it was still working, but with any URL I try to visit I get: The requested resource could not be loaded. libcurl returned the error: Couldn't resolve host 'www.google.com' I suppose the DNS server crashed? I already restarted the VPS 3 times including the DNS Server.
View Replies!
View Related
PHP (Mail) Marked As Spam Yahoo/Msn
i have a issue on my WHM/Cpanel Linux Server. I have hosted few vbulletin and IPB forums. Problem is that, when someone REGISTERS the CONFIRMATION email is sent to JUNK/SPAM in Hotmail and Yahoo email boxes. I have noted that The Confirmation emails sent from many other servers are NOT MARKED as spam by Yahoo and Hotmail email accounts. But the mails sent from My servers are marked as SPAM by default. I have pasted the headers below: Here are headers Mails sent from this server works fine. Received-SPF: pass (google.com: domain of webmaster@vbulletin.org designates 209.62.16.134 as permitted sender) client-ip=209.62.16.134; Authentication-Results: mx.google.com; spf=pass (google.com: domain of webmaster@vbulletin.org designates 209.62.16.134 as permitted sender) smtp.mail=webmaster@vbulletin.org Mails sent from this server are sent to SPAM folder by default: Received-SPF: neutral (google.com: 66.90.101.249 is neither permitted nor denied by domain of zahidon_4u@yahoo.com) client-ip=66.90.101.249; Authentication-Results: mx.google.com; spf=neutral (google.com: 66.90.101.249 is neither permitted nor denied by domain of zahidon_4u@yahoo.com) smtp.mail=zahidon_4u@yahoo.com One thing i am sure is there is something that needs to be fixed in WHM. Some option but i am not sure of that.
View Replies!
View Related
SPF Email Marked As Spam By Hotmail, Gmail
I have a dedicated server in which i host 4 web sites using plesk one of them is mysite.com. That one is also set for ns1.mysite.com ns2.mysite.com. (all domain names below are just example names) Dns records for my apple.com orange.com and banana.com uses ns1.mysite.com and ns2.mysite.com my name server is also in the same machine. In mysite2.com dns settings are as follows. Code: 80.111.11.11 / 24PTRorange.com orange.com.NSns1.mysite.com. orange.com.NSns2.mysite.com. orange.com.A80.111.11.11 orange.com.MX (10)mail.mysite.com. orange.com.TXTv=spf1 a mx include:gmail.com,yahoo.com,hotmail.com ~all ftp.orange.com.CNAMEorange.com. mail.orange.com.A80.111.11.11 webmail.orange.com.A80.111.11.11 www.orange.com.CNAMEorange.com. 80.111.11.11 is dedicated ip for orange.com. The PROBLEM: The thing is whenever the server sends email it is flagged spam by yahoo, hotmail etc. I have created SPF for my orange.com but it is still marked as spam... I have checked dns report for both mysite.com and orange.com but they seem to be OK with no warnings either. I want to create a spf record or make somthing so the emails does not marked as spam.
View Replies!
View Related
Server Hard Disk Crashed Badly, How To Recover It
My server hard disk is crashed badly. The rescue function in the server cannot take part and so I've tried using some recovery software to get back my data. I've tried using Easy Recovery Professional. It sort all the files by it file type into different folder. I found a folder named .DB, there are also some .ado and . ldb folder too. I guess one of it is my database. The problem now is, i dunno how to read the file. Do you have any idea to read it? I've tried many recovery system. eg. DiskInternals Linux Recovery, Disk Doctor Linux Recovery. it is a linux server
View Replies!
View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
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?
View Replies!
View Related
How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online. how can I get these database files to fully work on a new server?
View Replies!
View Related
Can I Move /var/lib/mysql To /home/mysql
my /var partition is full, im not sure if any files i can remove to get more free space on /var partition. because there are more free space on /home, i think if i can move all the /var/lib/mysql to /home/mysql, if yes,howcan i move it and do any change, can let the sql data do not lose, andrun well in the feature ?
View Replies!
View Related
MySQL Monitor Shows MySQL As Offline When It's Not
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea. Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light. The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though). The other odd thing is that MySQL shows a green light within WHM, but not anywhere else. Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View Replies!
View Related
User Aliases
Is it possible to create user aliases on linux? I have webmin and virtualmin running on my server, but it's set up to create usernames in the form name@domain.tld. Is it possible to create an alias, say myname that points to myname@mydomain.tld, so that I am able to have certain users to login via SSH using a shorter name?
View Replies!
View Related
User Nobody Using Too Much Cpu
use "nobody" is using 2much cpu on my server ... can someone explain me how is this possible ? [url] I already have checked "Prevent the user "nobody" from sending out mail to remote addresses (PHP and CGI scripts generally run as nobody if you are not using PHPSuexec and Suexec respectively.)" In tweak settings.
View Replies!
View Related
No User At TOP - All Are Nobody
when I run top command I should see who user are running and I see only my root and no body 2840 mysql 15 0 181m 78m 4568 S 22 1.0 1102:41 mysqld 4078 nobody 16 0 37128 17m 3300 S 5 0.2 0:00.99 httpd 4032 nobody 15 0 37600 18m 3364 S 5 0.2 0:00.35 httpd 3541 nobody 17 0 38200 18m 3300 S 4 0.2 0:00.73 httpd 3598 nobody 16 0 41744 21m 3288 S 4 0.3 0:01.26 httpd 3738 nobody 15 0 39820 19m 3276 S 3 0.2 0:00.63 httpd 4052 nobody 15 0 38436 18m 3376 S 2 0.2 0:01.63 httpd 3428 nobody 15 0 37040 17m 3388 S 2 0.2 0:00.60 httpd 3806 nobody 17 0 38404 18m 3316 S 2 0.2 0:00.70 httpd 4036 nobody 15 0 38408 18m 3300 S 1 0.2 0:00.52 httpd 4072 nobody 15 0 44216 24m 3424 S 1 0.3 0:01.03 httpd 3402 nobody 15 0 38296 18m 3320 S 0 0.2 0:01.05 httpd 3437 nobody 15 0 41632 22m 3616 S 0 0.3 0:01.25 httpd 3505 nobody 15 0 37412 17m 3428 S 0 0.2 0:00.89 httpd 3523 nobody 15 0 41432 21m 3252 S 0 0.3 0:00.30 httpd 3542 nobody 15 0 42720 22m 3388 S 0 0.3 0:00.88 httpd 3581 nobody 15 0 37464 17m 3272 S 0 0.2 0:00.40 httpd 3602 nobody 15 0 38472 18m 3420 S 0 0.2 0:00.31 httpd 3643 nobody 15 0 37788 18m 3308 S 0 0.2 0:00.50 httpd 3644 nobody 15 0 35120 15m 3000 S 0 0.2 0:00.03 httpd 3645 nobody 15 0 41816 21m 3276 S 0 0.3 0:00.52 httpd 3647 nobody 15 0 42908 23m 3408 S 0 0.3 0:01.20 httpd 3723 nobody 15 0 36260 16m 3408 S 0 0.2 0:00.85 httpd 3805 nobody 15 0 37512 17m 3272 S 0 0.2 0:00.44 httpd 4046 nobody 15 0 39596 19m 3284 S 0 0.2 0:01.41 httpd 4567 root 15 0 2452 1224 796 R 0 0.0 0:01.04 top 7826 root 15 0 0 0 0 S 0 0.0 0:06.21 pdflush 10001 root 15 0 12920 8528 1292 S 0 0.1 0:18.65 lfd 1 root 16 0 2060 636 544 S 0 0.0 0:12.09 init 2 root RT 0 0 0 0 S 0 0.0 0:01.15 migration/0 3 root 34 19 0 0 0 S 0 0.0 0:00.14 ksoftirqd/0 4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0 5 root RT 0 0 0 0 S 0 0.0 0:00.63 migration/1 6 root 34 19 0 0 0 S 0 0.0 0:00.09 ksoftirqd/1 7 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/1 8 root RT 0 0 0 0 S 0 0.0 0:01.29 migration/2 9 root 34 19 0 0 0 S 0 0.0 0:00.18 ksoftirqd/2 ---------------------- and I can't know who are runing in my server
View Replies!
View Related
|