MySQL Error: Can't Create/write To File '/dev/shm/MYxQT8lz'
May 19, 2008one of my site shows this error
MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'
I checked space on the server is still 25 GB free,
one of my site shows this error
MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'
I checked space on the server is still 25 GB free,
I just upgraded our Plesk 10.4.4 to 12.0.18 (on Ubuntu 10.04, about to be upgraded to 12.04). Now I get the dreaded 'queue file write error' in postfix on message delivery.
It tries to open /usr/lib/plesk-9.0/postfix-queue (which is not there) in this block in master.cf:
Code:
plesk_virtual unix - n n - - pipe flags=DORhu user=popuser:popuser argv=/usr/lib/plesk-9.0/postfix-local -f ${sender} -d ${recipient} -p /var/qmail/mailnames
127.0.0.1:10025 inet n n n - - spawn user=mhandlers-user argv=/usr/lib/plesk-9.0/postfix-queue 127.0.0.1 10027 before-queue
127.0.0.1:10026 inet n - - - - smtpd -o smtpd_client_restrictions= -o smtpd_helo_restrictions= -o smtpd_sender_restrictions= -o smtpd_recipient_restrictions=permit_mynetworks,reject -o smtpd_data_restrictions= -o receive_override_options=no_unknown_recipient_checks
127.0.0.1:10027 inet n n n - - spawn user=mhandlers-user argv=/usr/lib/plesk-9.0/postfix-queue 127.0.0.1 10026 before-remote
plesk_saslauthd unix y y y - 1 plesk_saslauthd status=5 listen=6 dbpath=/plesk/passwd.db
And on top of that, If disable all the milters/proxy and just try to deliver to plesk_virtual directly, the e-mail just disappears. Postfix thinks it was delivered, but it is not.
I also tried piping some text through /usr/lib/plesk-9.0/postfix-local with the same parameters postfix gives it, but also then nothing. No error, no exit code, no message in maildir.
There are a bunch of fixes around for the queue file write error, but nothing works because the nature of my problem is different. There is a KB article around for Plesk 9, which can hardly be useful.
I tried restoring postfix-queue from the backups, but if I try to use that, the mail.log eventually says:
Code:
Jan 30 01:20:00 ytechosting /usr/lib/plesk-9.0/psa-pc-remote[6621]: Message aborted.
I also used /usr/local/psa/admin/sbin/mchk to no avail: the only change it makes to my master.cf, is adding an empty line. And, I suspect it uninstalled my psa-courier, because it was gone at some point, and mchk was the only thing I did after knowing courier was still there.
How can the postfix config refer to that postfix-queue when it's not there? Is this even a valid master.cf file for Plesk 12?
I always have this error with mysql
Can't create/write to file '/tmp/#sql_7042_0.MYI' (Errcode: 13)
the /tmp has been chmoded 1777. I installed mysql downloaded from rpm on www.mysql.com, version 5.0.51a 64bits for CentOS-5
when i am trying to use php my admin i am getting
#1 - Can't create/write to file '/tmp/#sql_bba_0.MYI' (Errcode: 30)
when i am trying to delete a file from /tmp i am getting
rm: cannot remove `sess_***': Read-only file system
i have Linux box with cpanel,
On my previous server and on some other hosts, I was able to write to files (for example with PHP) without having to chmod the files first.
Now I cannot, and files are required to be chmoded properly so I can write to them.
I cannot even touch() a file with PHP.
Is there any way to have this permissions removed?
I don't want to chmod the all thing, all I want is to change the configurations so I can fwrite() or file_put_contents() normally.
I's a dedicated un-managed server, so basically any advanced configurations can be done.
I use a persistent and session cookie in order to help track return visitors, latent conversions and keyword tracking. My problem is that my hosting company, BlueHost, does not allow me to write the cookie data to my raw access log which would enable me to analyze this information.
Does anyone have any experience with using a script in order to get around this issue and write the cookie data to my log file....or as an alternative can people recommend a good hosting company which enables this functionality?
BlueHost has generally worked fine, so a work-around would be preferred, but if needed I may switch.
I have learned some bits of regular expressions for simple scripting, writing a .htaccess file is, uh, syntaxically daunting.
THE CASE :
The URLs of my site used to be of the form [URL] ... . They are now of the form [URL]......
I am trying to perma-redirect (301) the old format (affiche_fiche.php) to the new format (fiche.php) using a .htaccess.
So far all I have achieved is a hatred of punctuation signs. What's the correct syntax to have a .htaccess that does the redirect ?
THE CONTEXT : The format change took place more than six months ago, but the Google Webmaster Tools still spits 450 problems a day with 404s on URLs using the old format. I had assumed that these would just fade away, but they don't. So I guess that 301'ing them is cleaner. Or would be, if I understood the syntax.
I have a website built with asp .Net with MS SQL database. The website have some pages that uploads images and files in some folders.
I have tried GoDaddy shared Windows hosting. But they don't seem to allow file upload using a script.
Then I tried GoDaddy Virtual Dedicated. The tech guy told me MS SQL would be part of the hosting. Later I find he lied, there is no MS SQL as part of it.
I am trying to find an affordable hosting that has MS SQL and also allows file upload using script.
Recently,Mysql has been a problem that is going down.So,I have to restart Mysql Service everyday. You can see for further information at here
Quote:
ERROR
Couldn't connect to database.
Please contact admin about this err. Back
DETAIL
2002 : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
This is the error when i restart Mysql Service via SSH
Quote:
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL SUCCESS!
what i should do and give me a solution to kill this error
we have set logrotate for rotate mysqld.log daily
file is compress, deleted and created from logrotate but mysql not write anything
Any idea about why?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies View Related"Can't write to data socket. Socket error = #10054. fix?"
search around a few websites couldn't find a fix.. just people chatting about there error
I seem to be having a problem where periodically the data in one file is getting corrupted. I haven't been able to figure out a pattern to it, so I wanted to run command by crontab that would create a copy of the file each day. To avoid overwriting previous backups the filename of each day's copy would have to be unique like...
cp filename filename-2008-07-03
Is there a way to include this year, this month, and this day variables in a linux command?
In my personal website at URL.... I have the top like 'index.php?pg=profile', 'index.php?pg=home' or 'index.php' (without any querystring), 'index.php?pg=diary' etc. I am looking to see if I can have .htaccess file which can make me create links like
index.php/
index.php
index.php/home
index.php/profile
index.php/diary
write an .htaccess for the same?
how to create Dump File for Apache Crash in Windows.We are using Apache for Reverse Proxy with OpenAM Module for Sign-in.Apache Version : 2.4.9.0...We are very frequently facing Apache Crash Issue.
Also in logs we do not get much information.when submitted logs to ForgeRock, they asked us to look into below error and provide Crash Dump.
[Sun Jun 15 23:00:10.153908 2014] [mpm_winnt:warn] [pid 2376:tid 424] (OS 64)The specified network name is no longer available. : AH00341: winnt_accept: Asynchronous AcceptEx failed.
[Sun Jun 15 23:02:21.609557 2014] [proxy_http:error] [pid 2376:tid 6544] (OS 10060)A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. : [client 10.XXX.XX.XX:XXXX] AH01095: prefetch request body failed to XX.XXX.XX.XX:XXX (teampark.sogeti.com) from XX.XXX.XX.XX (), referer: https://teampark.sogeti.com/blogs/roller-ui/authoring/weblog.do?method=create&weblog=VeckobrevIntegrationSyd&lang=sv_se
Display some text in a web browser from a file called text.txt
text.txt will have many lines and some of them I do not want users to be able to modify and overwrite.
config_item_1=user can edit
config_item_2=user should see but not edit (could be on any line)
config_item_3=user can edit
config_item_4=user can edit
The user has made their changes in the web browser and clicks submit. I then need this info to be saved as the text.txt file however some checking needs to be done first. Anything matching config_item_2 should be removed. This could be on any line. Anything not matching should be permitted and added.
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'm having problem with my IPB forum which runs on MySQL database (hosted on linux Fedora).
Our website was unavalable for a short time, and when it came back on-line, we found we cannot create new topics/add replies, in short, we cannot add new records to ibf_posts table. However, editing existing posts works, sending private messages works, so database seems mostly OK, apart from posting. Whenever we try to post/add new topic, we get IPS Driver Error. We have tried restarting MySQL several times, but it didn't solve the problem.
Looking at the error log, we notice the following lines (but we're unsure is it about this problem):
Quote:
[Sat Nov 01 19:32:06 2008] [error] server reached MaxClients setting, consider raising the MaxClients setting
[Sat Nov 01 19:39:25 2008] [error] mod_fcgid: fcgid process manager died, restarting the server
[Sat Nov 01 19:39:36 2008] [warn] child process 2281 still did not exit, sending a SIGTERM
and then several hundreds lines like this:
Quote:
[Sat Nov 01 20:21:53 2008] [warn] child process 26643 still did not exit, sending a SIGTERM
...
[Sat Nov 01 20:21:56 2008] [error] child process 26643 still did not exit, sending a SIGKILL
...
[Sat Nov 01 20:21:57 2008] [error] could not make child process 26643 exit, attempting to continue anyway
...
It seems really strange that forum and database seem absolutely OK, that editing and private messages work (and Admin CP seems fine) but that it throws IPS Driver error on new posts only?
I got message:
Code:
<h3 class="errors" align="center">Please create a cPAddons Configuration <a href="cpaddons.pl?force=1">here</a></h3>
Where have I this to add ?
I have a script and there are some modifications that I want to make
In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.
I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.
Should I use phpmyadmin or whats the correct way?
Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily
mysqldump -u usernam -p password dataname > file.sql
I want to create a new email would then click on the OK button attachment error is displayed.
View 1 Replies View RelatedI suddenly started to get the following error
Windows 2008 server 64 bits 24 gigs ram sql express php plesk 11.5.30 latest update passed the latest self test with no problem
Internal error: ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
Message ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
File aps_php.php
Line 11933
Type Exception
Go To Previous Page
We are having an issue when users are trying to add attachments via horde the error:
unable to create VFS directory /.horde/imp
appears. How this can be resolved?
when I create new email address get this error:
Error: Source: Microsoft OLE DB Provider for SQL Server
Description: 'encrypt' is not a recognized built-in function name.