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

Enabling DMA Failed On CentOS

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

Plesk 12.x / Windows :: WordPress Install - MySQL Extension Was Not Found

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

Plesk 11.x / Windows :: Mysql Duplicate Entry Error - Enabling Spam Filter

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

FreeBSD & CentOS (MySQL)

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

PHP 4.3.9 MYSQL 4.1.20 UPGRADE On CENTOS 4 With Plesk 8

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

PHP 4.3.9 MYSQL 4.1.20 UPGRADE On CENTOS 4 With Plesk 8

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

MySQL Restart On CentOS - Chown

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

MySQL Administrator GUI Disappear When Restore Backup On CentOS 5.x

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

Apache, Mysql Automatically Start After Reboot Under CentOS

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

Plesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database

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

Enabling SMS On A Website

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

Enabling WebDAV

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

Enabling JSP For A Domain

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

Enabling Of Html To Run SSI

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

.mil Extension

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

Enabling DMA Mode On IDE Drive

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

Enabling Iptables Modules

Nov 2, 2009

This wiki page has discussed how to enable iptables modules in a VPS.

View 6 Replies View Related

Enabling Javascrpt In IE On WinSrvr2008

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

Enabling Php By Default In Apache

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

Manually Enabling SpamAssassin

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

Enabling Shell_exec() For Some User

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

Enabling Crontab For Users

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

Enabling PHP Error Reporting

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

Enabling Support Of These Php Extensions

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

Frontpage Extension

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

Installing PHP RAR Extension

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

Enabling Wget - Security Issues

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

Httpd Failed After Enabling SSL Certificates

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







Copyrights 2005-15 www.BigResource.com, All rights reserved