Enabling PDO W/ MySQL Extension On CentOS
Jul 11, 2009
I have a server running CentOS with PHP 5.2 and I'm trying to figure out how to enable PDO with the MySQL extension. I had thought PDO always came enabled with 5.2, but that apparently isn't so with this box. I am only familiar with Ubuntu/Debian, and am not sure how things are done on CentOs.
View 2 Replies
ADVERTISEMENT
Aug 18, 2008
root@contact [~]# hdparm -d 1 /dev/hdd
/dev/hdd:
setting using_dma to 1 (on)
HDIO_SET_DMA failed: Operation not permitted
using_dma = 0 (off)
root@contact [~]#
root@contact [~]# hdparm -X66 -d1 /dev/hdd
/dev/hdd:
setting using_dma to 1 (on)
HDIO_SET_DMA failed: Operation not permitted
setting xfermode to 66 (UltraDMA mode2)
using_dma = 0 (off)
root@contact [~]#
drive
root@contact [~]# hdparm -I /dev/hdd
/dev/hdd:
ATA device, with non-removable media
Model Number: Hitachi HDP725050GLA360
Serial Number: GEA550RF04Z90G
Firmware Revision: GM4OA52A
Transport: Serial, ATA8-AST, SATA 1.0a, SATA II Extensions, SATA Rev 2.5; Revision: ATA8-AST T13 Project D1697 Revision 0b
Standards:
Supported: 8 7 6 5
Likely used: 8
Configuration:
Logical max current
cylinders 16383 65535
heads 16 1
sectors/track 63 63
--
CHS current addressable sectors: 4128705
LBA user addressable sectors: 268435455
LBA48 user addressable sectors: 976773168
device size with M = 1024*1024: 476940 MBytes
device size with M = 1000*1000: 500107 MBytes (500 GB)
Capabilities:
LBA, IORDY(can be disabled)
Queue depth: 32
Standby timer values: spec'd by Standard, no device specific minimum
R/W multiple sector transfer: Max = 16 Current = 16
Advanced power management level: unknown setting (0x0000)
Recommended acoustic management value: 128, current value: 254
DMA: mdma0 mdma1 mdma2 udma0 udma1 *udma2 udma3 udma4 udma5 udma6
Cycle time: min=120ns recommended=120ns
PIO: pio0 pio1 pio2 pio3 pio4
Cycle time: no flow control=120ns IORDY flow control=120ns
Commands/features:
Enabled Supported:
* SMART feature set
Security Mode feature set
* Power Management feature set
* Write cache
* Look-ahead
* Host Protected Area feature set
* WRITE_BUFFER command
* READ_BUFFER command
* DOWNLOAD_MICROCODE
Advanced Power Management feature set
Power-Up In Standby feature set
SET_FEATURES required to spinup after power up
Address Offset Reserved Area Boot
* SET_MAX security extension
Automatic Acoustic Management feature set
* 48-bit Address feature set
* Device Configuration Overlay feature set
* Mandatory FLUSH_CACHE
* FLUSH_CACHE_EXT
* SMART error logging
* SMART self-test
Media Card Pass-Through
* General Purpose Logging feature set
* WRITE_{DMA|MULTIPLE}_FUA_EXT
* 64-bit World wide name
* URG for READ_STREAM[_DMA]_EXT
* URG for WRITE_STREAM[_DMA]_EXT
* WRITE_UNCORRECTABLE command
* Segmented DOWNLOAD_MICROCODE
* SATA-I signaling speed (1.5Gb/s)
* SATA-II signaling speed (3.0Gb/s)
* Native Command Queueing (NCQ)
* Host-initiated interface power management
* Phy event counters
* unknown 76[12]
Non-Zero buffer offsets in DMA Setup FIS
DMA Setup Auto-Activate optimization
Device-initiated interface power management
In-order data delivery
* Software settings preservation
Security:
Master password revision code = 65534
supported
not enabled
not locked
frozen
not expired: security count
not supported: enhanced erase
184min for SECURITY ERASE UNIT.
Checksum: correct ....
View 3 Replies
View Related
Feb 9, 2015
Running Plesk 12.0.18 on Windows 2012
I create a new domain then use Plesk Applications tab to install Wordpress. It shows the message:
Code:
Error: Unable to install the app because its installation requirements are not met. Contact your hosting provider to resolve this problem.
Requirements
PHP extension
The 'mysql' extension was not found.
However, php is installed and phpinfo shows that the mysql extension is installed. I try different versions of php, cgi/fastcgi but ll fail with the same error. I install Wordpress via FTP and it works fine.
There are knowledge-base articles relating to this error but they are for Linux and the solutions don't work in this case:
[URL] ...
[URL] ...
Maybe the Wordpress database has to be created before using Plesk to install Wordpress? If so, what should the database name be? How does Plesk know what the name of the database is that it should use? Why doesn't Plesk just create a database to use?
View 6 Replies
View Related
May 7, 2013
when im trying to enable spam filter for a particular email account i get this mysql error:
Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxx@domain.com' for key 3 (mail id i hid it for security reasons xxxx@domain.com)..
i searchd in the psa database but could not find any duplication...
View 2 Replies
View Related
Mar 13, 2007
Setting up a storage and web server.
For transferring files from the storage to the web server, i was planning on streaming it over a private gigabit network line.
FreeBSD would be the best choice in terms of network thorouput correct?
Would FreeBSD also be a good choice for the web server as well? ( web + database on 15k scsi drives )
I've been reading a few posts on google about MySQL performance on FreeBSD but am not sure how well those results are substantiated - so I'm looking for a bottom line comparison between FreeBSD and CentOS in terms of network thoroughput and MySQL performance.
View 2 Replies
View Related
May 28, 2009
I am planning on upgrading to php 5. I really don't need to upgrade to mysql 5 but do you guys think I will face problems with PHP 5.2.9 and Mysql 4.1.20 working together...
I am planning on doing the upgrade like this (if I decide to upgrade PHP and MYSQL all together)
1. STEP
nano /etc/yum.repos.d/CentOS-Base.repo
2. STEP
change the enabled=0 to 1 as follows
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
#baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/
gpgcheck=1
enabled=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos4
priority=2
protect=1
4.STEP
yum install php-xml
5.STEP
yum update httpd* php* mysql*
and restart the server do you guys think I will face any problems.
If I am only upgrading the php to latest I am planning on doing
1.STEP
I will do the 2.STEP above
2.STEP
wget -q -O - http://www.atomicorp.com/installers/atomic.sh |sh
yum install php-xml php-pdo
yum install php-pear
mv /etc/php.ini.rpmnew /etc/php.ini
and reboot
View 4 Replies
View Related
May 28, 2009
I am planning on upgrading to php 5. I really don't need to upgrade to mysql 5 but do you guys think I will face problems with PHP 5.2.9 and Mysql 4.1.20 working together...
I am planning on doing the upgrade like this (if I decide to upgrade PHP and MYSQL all together)
1. STEP
nano /etc/yum.repos.d/CentOS-Base.repo
2. STEP
change the enabled=0 to 1 as follows
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=[url]
release=$releasever&arch=$basearch&repo=centosplus
#baseurl=[url]
gpgcheck=1
enabled=1
gpgkey=[url]
priority=2
protect=1
4.STEP
yum install php-xml
5.STEP
yum update httpd* php* mysql*
and restart the server do you guys think I will face any problems.
If I am only upgrading the php to latest I am planning on doing
1.STEP
I will do the 2.STEP above
2.STEP
wget -q -O - [url]
yum install php-xml php-pdo
yum install php-pear
mv /etc/php.ini.rpmnew /etc/php.ini
and reboot
View 2 Replies
View Related
Sep 18, 2007
I have a lot of tables, being that I host multi forums. One thing I noticed when doing a mysql start up or restart is that it takes at least 15 minutes to do it. The server isn't bad, it's a Pentium D with 3GB of RAM and it runs perfectly fine. What I noticed is that after I do an SQL restart, I checked "top." The command that was running is "chown" and it sat at the top of the list, and kept going. Until finally mysql started and it stopped.
I imagine that all of the files in the data folder are being CHOWNed... and that's why it takes forever. If this is the case, how can I stop this, if at all? I don't see why they need to be CHOWNed?
View 4 Replies
View Related
Aug 5, 2008
I have some server with OS: CentOS 5.x
one day, I have to replicate 2 servers together. so, I have to stop webserver and use MySQL Administrator GUI Tool to backup it. My steps follow: (i work directly on Server 2 and i wantna to use mysql administrator gui to monitor and config replication).
1. Server 2: ssh to server 1-> connect mySQL -> add any host to root access
2. Server 2: use mySQL Administrator connect to server 1 with root
3. Server 2: backup from server 1 on Desktop location
4. Server 2: Restore it use mysql administrator tool.
It works well but when i click Restore button, MySQL Administrator GUI Tool disappear!
What's problem with this tools or server 2?
View 4 Replies
View Related
Jul 8, 2007
I have one bare server and installed everything myself. however, I found apache, mysqld can not automatically start after reboot, may I know how to enable them to automatically start after reboot?
View 5 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Jun 13, 2008
My client wants to send SMS from his new website that we are making. How can I enable this feature ...? What's the easiest way?
(The reason I'm posting this question in this forum is that I'm just guessing that this has something to do with web hosting. But, admin, if I'm wrong about this, please move this to a different forum.)
I read that Clickatell is a good service to use to provide this service on our website. Did anyone here use this service before? If so, what did you think about it? Is it easy to set up?
View 1 Replies
View Related
Feb 10, 2007
I am running a Fedora Core 4 VPS with Apache 2.0.53 I think.
I would really like to install/enable WebDAV so that I can mount some of the server storage as a drive on my computer for easy file manipulation from desktop, laptop, gf's house, etc. without having to carry the files around with me all the time.
How would I go about configuring WebDAV?
View 2 Replies
View Related
Aug 12, 2007
dears how can i enable jsp for a specify domain?
i tried this @ putty:
/scripts/installservlet <domain.com>
but it doesnt work for me
im using cpanel 11.x
View 0 Replies
View Related
Dec 27, 2007
Is there any way to run SSI with html instead of shtm or shtml in Windows 2003 IIS 6 server?
View 0 Replies
View Related
Apr 30, 2008
we have a client who needs a dedicated server provider that is capable of hosting a military .mil extension web site.
View 5 Replies
View Related
Apr 23, 2009
I cannot enable DMA mode on /dev/hda when attemping to enable it via ssh
Code:
hdparm -d1 /dev/hda
/dev/hda:
setting using_dma to 1 (on)
HDIO_SET_DMA failed: Operation not permitted
using_dma = 0 (off)
Code:
hdparm -tT /dev/hda
/dev/hda:
Timing cached reads: 1632 MB in 2.00 seconds = 814.90 MB/sec
Timing buffered disk reads: 8 MB in 3.42 seconds = 2.34 MB/sec
I am running CentOS 4.7 and cPanel 11. cPanel also shows DMA is not enable on this drive. Kernel: 2.6.9-78.0.13.ELsmp
Code:
cat /boot/config-2.6.9-78.0.13.ELsmp |grep DMA
CONFIG_GENERIC_ISA_DMA=y
CONFIG_BLK_DEV_IDEDMA_PCI=y
# CONFIG_BLK_DEV_IDEDMA_FORCED is not set
CONFIG_IDEDMA_PCI_AUTO=y
# CONFIG_IDEDMA_ONLYDISK is not set
# CONFIG_HPT34X_AUTODMA is not set
CONFIG_BLK_DEV_IDEDMA=y
# CONFIG_IDEDMA_IVB is not set
CONFIG_IDEDMA_AUTO=y
CONFIG_SCSI_SYM53C8XX_DMA_ADDRESSING_MODE=1
CONFIG_PDC_ADMA=m
Code:
hdparm -i /dev/hda
/dev/hda:
Model=WDC WD2500JB-00REA0, FwRev=20.00K20, SerialNo=WD-WMAN542173
Config={ HardSect NotMFM HdSw>15uSec SpinMotCtl Fixed DTR>5Mbs FmtGapReq }
RawCHS=16383/16/63, TrkSize=0, SectSize=0, ECCbytes=50
BuffType=unknown, BuffSize=8192kB, MaxMultSect=16, MultSect=16
CurCHS=16383/16/63, CurSects=16514064, LBA=yes, LBAsects=268435455
IORDY=on/off, tPIO={min:120,w/IORDY:120}, tDMA={min:120,rec:120}
PIO modes: pio0 pio3 pio4
DMA modes: mdma0 mdma1 mdma2
UDMA modes: udma0 udma1 udma2 udma3 udma4 *udma5
AdvancedPM=no WriteCache=enabled
Drive conforms to: device does not report version:
* signifies the current active mode
View 8 Replies
View Related
Nov 2, 2009
This wiki page has discussed how to enable iptables modules in a VPS.
View 6 Replies
View Related
Mar 23, 2009
Both IE7 and FF are configured to use javascript, but no sites seem to recognize the fact and report that it's been blocked or off. How do I enabled this?
View 1 Replies
View Related
Mar 17, 2008
When I create a website in apache I have to enable php on it manually, Is there a way that I enable php by default on root of apache?
View 3 Replies
View Related
Mar 2, 2008
I have a dedicated server. It is a Fedora Core 6. It came with "Plesk 30 domain license". However, this license of Plesk doesn't have SpamAssassin enabled. In order to get the license with SpamAssassin, it costs an extra $30 a month.
I believe SpamAssassin by default is in fact installed on the sever, but some of my users are reporting that they are getting Spam. How can I check is SpamAssassin is running? How do I configure SpamAssassin to filter spam on all the e-mail addresses that are created in Plesk?
I have SSH access to the server.
View 3 Replies
View Related
Mar 26, 2008
to run one PHP script from crontab as root..
But my basic PHP has shell_exec disabled in php.ini and when trying to run script that use shell_exec even from root I get error that function is disabled.
Do you have any suggestion how can I overcome this and have ability to use this function when executing php script from console?
View 3 Replies
View Related
Aug 19, 2008
I noticed on my new servers users doesnt have crontab permission.On my first server they have access.So what i need to do to enable users crontab permission automaticly on new servers?I have whm/cpanel there but it seems there is nothing about it there.
View 3 Replies
View Related
Jan 7, 2007
I just leased a server through EV1. It's Linux (I think), Apache, and Plesk 8.0. I'm trying to get error reporting to work for my php scripts. I opened up the php.ini file (I'm about 90% sure that it's the right php.ini file) found in the /etc folder. I changed error reporting to "on" and restarted my server with Plesk.
PHP errors are still not showing up.
View 2 Replies
View Related
Sep 8, 2007
i just got setup with a dedicated linux server with cpanel/whm access and root and well i have a site on the server that im installing some software on and its come up saying that my server does not support these things and to change them
PHP Extension: GD
Your server does not support GD Library and cannot use (thumbnail generation, re-size/scale, etc).
PHP Function: mb_detect_encoding()
Your server does not support multibyte character encoding.
PHP Extension: openssl()
Your server does not support the openssl().
to take within my root access to turn on/ enable support for these functions and extension
View 3 Replies
View Related
Apr 25, 2008
I have installed Front page extension but when i access the page its gives the error :-
FrontPage Run-Time Component Page
You have submitted a form or followed a link to a page that requires a web server and the FrontPage Server Extensions to function properly.
This form or other FrontPage component will work correctly if you publish this web to a web server that has the FrontPage Server Extensions installed.
Click the <Back> arrow to return to the previous page.
View 2 Replies
View Related
Jun 26, 2008
I wanted to install PHP RAR extension:
to compress & decompress rar files. I installed it on the server & added the extension=rar.so to php.ini files.
But still, when I run a rar function like rar_open(), I get an error :
Fatal error: Call to undefined function rar_open()
I tried installing the extension again through SSH, but it says "Nothing to Install".
View 4 Replies
View Related
Feb 10, 2008
Will there be a prominent security issue if I enable wget for a user?
And where would I find the user/group file to add that user?
View 7 Replies
View Related
Jan 18, 2008
I have SSL certificated (GeoTrust) installed on my server for one of my site since last year, and it has been working fine.
This morning I found my site to be down, SSL connection not working.
I restarted httpd via WHM, and it failed to restart.
I removed my SSL certificate using WHM at "Manage SSL Hosts", then I can restart my httpd.
So, I think there is some conflicts between my httpd and SSL. Any idea how should I solve the problem? I have paid for the SSL cert for two years, and I want it to be back on my site.
View 5 Replies
View Related