MYSQL Installation Errors

Plesk Automation :: Application Installation Errors

May 3, 2014

Getting the following when trying to install DNN. A similar thing also happened when trying to install WordPress.

Error: Installation of DotNetNuke at http://domain.com/dnn failed. Non-zero exit status returned by script. Output stream: 'Error during MSSQL version checking [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. '. Error stream: 'Error during MSSQL version checking [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. '.

When it happened with WordPress, I tried the install again and it worked the second time. However, with DNN it does not seem to be working after a second try. Yes, the MS SQL server does exist and is ready to provide.

View 3 Replies View Related

Plesk Automation :: Errors While PPA Installation - Failed To Create Repositories

Mar 6, 2014

While installing ppa i got the following error message, i cant understand:

Code:
...
2014-03-06 13:53:37.148 INFO Creating repo for RHEL-6-i686
2014-03-06 13:53:37.455 INFO Creating repo for RHEL-5-x86_64
2014-03-06 13:53:37.754 INFO Creating repo for RHEL-6-x86_64
2014-03-06 14:13:41.450 ERROR Exception Failed to create repositories: ['/usr/local/pem/install/tarballs/RHEL/5/i386/YUM']
2014-03-06 14:13:41.450 ERROR <type 'exceptions.Exception'>

[Code] ....

Installation was started at CentOS 6.5 x64

View 2 Replies View Related

Mysql Errors &

Sep 14, 2007

This is the second time this has happened last time my host fixed it and they should be right now but why does this happen to a server?

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/xxxxx/domains/xxxxx.com/public_html/includes/open_db.php on line 12
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View 2 Replies View Related

Log All Mysql+php Errors

Feb 3, 2007

I'm running an IPB 2.2.1 Forum on a VDS, 512 RAM, DEBIAN SARGE, PHP4+Eaccelerator,MYSQL 4.1,Apache 1.3.

I get the famous ipb mysql error :

IPS Driver Error

There appears to be an error with the database.

You can try to refresh the page by clicking here

I don't know what thsi error come from, i want to log all Mysql/Php errors.

Ipb already log mysql errors in the /cache directory ..But there are no errors in ther, so i want to try server's logs.

View 4 Replies View Related

High Load And Mysql Errors

Jun 17, 2007

My server very slow and the is very loaded. How can I fix this problem? My server specialities and loaded softwares which are below. And sometimes there is "mysql connect failed", "Lost connection to MySQL server during query" errors. Thanks for kinds...

---
Speed:
100Mbs

LOAD:
Load avarage : 5-30 +
Cpu usage: %30-95 +
Ram usage: %70-95 +

SYSTEM INFO:
2gb ram, P4 3200 cpu, 2x250 GB SATAII hdd, Plesk 8.1.1, centos 4.5 os, apache 2.0.59, php 4.4.7, mysql 4.1.21(client),
mysql 5.0.41(server), zend optimizer, kernel 2.6.19.1.SM #5 SMP, mod_evasive, plesk firewall, qscanq+clamav,
spamassain and system up-to-date.

SOFTWARE:
phpbb 2.0.22
4images 1.7.4
joomla 1.0.12

ONLINE USER:
100-500 user online
on 2 website

How to optimization?

I installed tuning-primer.sh

but I can�t understand this code:
I don�t know. How to set values, example?
NOTE: Red value

-------------------------
[root@lavinya bin]# tuning-primer.sh

-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -

MySQL Version 5.0.41-log i686

Uptime = 3 days 4 hrs 34 min 17 sec
Avg. qps = 92
Total Questions = 25406284
Threads Connected = 1

Server has been running for over 48hrs.
It should be safe to follow these recommendations

To find out more information on how each of these
runtime variables effects performance visit:
.............

SLOW QUERIES
Current long_query_time = 5 sec.
You have 115 out of 25406302 that take longer than 5 sec. to complete
The slow query log is enabled.
Your long_query_time seems to be fine

WORKER THREADS
Current thread_cache_size = 8
Current threads_cached = 7
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine

MAX CONNECTIONS
Current max_connections = 500
Current threads_connected = 2
Historic max_used_connections = 110
The number of used connections is 22% of the configured maximum.
Your max_connections variable seems to be fine.

MEMORY USAGE
Max Memory Ever Allocated : 835 M
Configured Max Per-thread Buffers : 3 G
Configured Max Global Buffers : 46 M
Configured Max Memory Limit : 3 G
Total System Memory : 3.96 G

Max memory limit exceeds 85% of total system memory

KEY BUFFER
Current MyISAM index space = 35 M
Current key_buffer_size = 32 M
Key cache miss rate is 1 : 73658
Key buffer fill ratio = 34.00 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere

QUERY CACHE
Query cache is enabled
Current query_cache_size = 4 M
Current query_cache_used = 1 M
Current query_cach_limit = 1 M
Current Query cache fill ratio = 29.83 %
MySQL won't cache query results that are larger than query_cache_limit in size

SORT OPERATIONS
Current sort_buffer_size = 2 M
Current record/read_rnd_buffer_size = 1 M
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 1.00 M
You have had 14127 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.

Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.

OPEN FILES LIMIT
Current open_files_limit = 2500 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine

TABLE CACHE
Current table_cache value = 256 tables
You have a total of 636 tables
You have 256 open tables.
Current table_cache hit rate is 1% , while 100% of your table cache is in use
You should probably increase your table_cache

TEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 2271787 temp tables, 3% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Created disk tmp tables ratio seems fine

TABLE SCANS
Current read_buffer_size = 1 M
Current table scan ratio = 28 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio =1 : 112
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
If you have a high concurrentcy of inserts on Dynamic row-length tables
consider setting 'concurrent_insert=2'.

[root@lavinya bin]#
----------------------

if your reply me message I will be happy

View 1 Replies View Related

PHP & MySQL On IIS With XAMMP Installation

May 18, 2009

I originally installed XAMPP on my XP machine, but now I need to run an application using IIS.

Is it possible to use the XAMPP installation with IIS?

I installed IIS and I've disabled the apache service, PHP seems to be working fine but not MySQL?

View 2 Replies View Related

PHP-MYSQL Error At Installation

Dec 12, 2007

Error: Missing Dependency: php = 4.3.9-3.22.9 is needed by package php-mysql

above is the error if i try to install php-mysql

tried several times:

yum install php-mysql

but i get the same error everytime
i am using Centos4 + PHP5 + mySQL5

View 7 Replies View Related

Hide Php/mysql Errors On Live Domain

Apr 27, 2009

how can i stop php and mysql errors from being displayed on a live site. I'd rather just check the error log than have the errors displayed to all users.

View 4 Replies View Related

Bastille Firewall Causing Mysql Connection Errors

Jan 27, 2008

The main function of my dedicated server is the vBulletin forum that we run.

Ever since I had bastille firewall installed and configured on my server we have been getting regular vBulletin errors.

Everything runs pretty smoothly most of the time, we can carry lots of connections without any issues, server has plenty of free RAM and CPU is never overloaded even during peak hours. I have been told bastille firewall (iptables) is configured correctly, all ports that need to be open are open.

But about twice per day we have a MySQL "disconnect" that lasts about 30-60 seconds per incident. For example we will start getting the following message via e-mail, and it will amount to 20-30 e-mails like this during the 30-60 second incident. After that, the e-mails and problems will go away, until next time.

vBulletin Database Error!
mysql_connect(): Can't connect to MySQL server on 'sql.datacolony.com' (4)
/hsphere/local/home/site/site.com/forum/includes/class_core.php on line 274
MySQL Error :
Error Number :
Date : Saturday, January 26th 2008 @ 07:53:05 PM
Script : [url]
Referrer : [url]
IP Address : 92.3.190.54
Username :
Classname : vb_database

The server is running CentOS 4.6, PHP 4.4.7, MySQL 5.0.45. The vBulletin software has been patched to the latest version. The vBulletin people are not sure why this could be happening.

Well we never believed that the firewall was causing the issue BUT it only started happening on the day the new firewall was installed. So we tried stopping the firewall for a full week and the MySQL database errors stopped happening, completely. So I'm convinced the problem is the firewall blocking MySQL connections but I can't figure out why?

There are no entries in the MySQL .err logs pertaining to this. Can't figure this out, any help or ideas is appreciated since the people who installed the firewall are not sure either.

View 3 Replies View Related

Warning Mysql Messege !! While Installation VB Forum

Oct 25, 2007

i get anew VPS with Control Panel...

when i try to install the VB forum it's show me this warning Messege!

Code:
Error description: mysql_connect() [function.mysql-connect]: Access denied for user 'user_db'@'localhost' (using password:
YES) /home/*****/public_html/includes/class_core.php on line 274

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.
how can i fix this problem in Mysql USER ?

View 14 Replies View Related

Plesk 11.x / Windows :: How To Upgrade Mysql 4.x Installation

Jul 29, 2012

Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.

View 3 Replies View Related

Plesk 12.x / Linux :: MySQL Password Changed During Installation

Oct 15, 2014

Is it possible, that the script changes my admin password for MySQL? I can not connect to my MySQL Server any more.

View 1 Replies View Related

Plesk 12.x / Linux :: Installation Script MySQL Error

Oct 15, 2014

on my Ubuntu 14.04 LTS server, I have ran the install script. This process stopped with the message: ERROR while trying to establish test connection. If you are installing Plesk on an already configured MySQL server, you need to specify the administrator's credentials to succeed with the installation.

To do this, you need to create a file - /root/.my.cnf with the 'client' section where you need to provide user and its password ("user = $admin_name" and "password = $admin_pass").

After installation is finished, the file /root/.my.cnf will be renamed to /root/.my.cnf.bak

Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again

Accordingly, I have the existing my.conf copied to the ROOT directory and added the two missing lines in the client area. After that I started the plesk-installer.sh again. The process stopped at a line

"Installed product components are determined" and nothing still happend. The log files says nothing but the last information at the previous try.

View 1 Replies View Related

Joomla Installation - Username/Password Incorrect MySQL Database Error

Jun 25, 2007

I am trying to install Joomla on httpme.com but I seem to have problems with it recognising the username/password. Could it be a localhost issue or something?

I just can't seem to get a solution to this. I am referring to step 1 of the Joomla installation.

View 10 Replies View Related

Email Errors - 550 Callback Errors

Feb 13, 2007

I'm noticed I was getting bounced email errors from a company I was sending email through and I further investigated this by running a dnsreport on my domain.

Turns out that it fails at Acceptance of NULL <> sender, Acceptance of postmaster address, and Acceptance of abuse address. The domain that I ran a test on is using a new IP that I had recently added to my Direct Admin server. None of the other domains on my server are having issues like this.

Is is possible that I need to do something to enable these new IP addresses in exim? I mean, exim obviously responds to that IP address, but it seems to be having some issues with it.

View 5 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql

Jan 21, 2007

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 1 Replies View Related

CSF Errors

Apr 1, 2009

I am doing the Security Check provided by Config Server Firewall.

It is giving me 3 errors, and I want to fix them, so here they are.

Check /dev/shm is mounted noexec,nosuid
/dev/shm is not mounted with the noexec,nosuid options (currently: none). You should modify the mountpoint in /etc/fstab for /dev/shm with those options and remount
On this one I actually went and added the noexec,no suid options. Here is what i've got configured and what it looks like. (it's most likely not correct so help correct it.)
[url]

Check /etc/named.conf for DNS recursion restrictions

You have a local DNS server running but do not have any recursion restrictions set in /etc/named.conf. If the named process is using this configuration file, then this is a security and performance risk and you should look at restricting recursive lookups to the local IP addresses only

Check dovecot weak SSL/TLS Ciphers (ssl_cipher_list)
Cipher list []. Due to weaknesses in the SSLv2 cipher you should disable SSLv2 in WHM > MailSever Configuration > SSL Cipher List > Remove +SSLv2 or Add -SSLv2
Alright so this one I followed the instructions, and i've got everything set correctly but it still shows up on the thing. I don't think the ssl_cipher_list is even available in WHM

View 3 Replies View Related

What Causes 500 Errors

May 30, 2008

I don't know much of anything about server settings or errors, so I need your help. Recently one of my servers have been getting a lot of 500 error messages, and I can't pinpoint the reason or replicate the error on my end. I did some Google searching and although I found out in general what a 500 error is, I still am not clear on what exactly causes them or how to reduce them. Could it be caused by intense amounts of traffic? Is the server just being overloaded?

Also, I see that my server is throwing a lot of 404 errors for a variety of URLs on my site, however when I visit the URLs specified by the error log they work fine for me - seems like only sometimes for whatever reason the server can't find/access them and throws a 404. Again, I can't replicate it and have no clue how to fix it since the list of 404 URLs work fine when I type them in.

View 4 Replies View Related

VPS Ftp Errors

May 29, 2008

I have a VPS account with an hosting site. For the past 2 days i have done a lot of uploads. I have 25+ sites on this account. Today when i try to login into my sites via ftp, its showing ftp login failed for all sites.

The hosting company is still sleeping on my queries regarding this matter.

Interestingly logins for WHM & cpanel for all sites are working fine.

Any experienced members plz guide me on how to get the ftp working to upload files to my sites.

View 4 Replies View Related

Php Pdo Errors

Nov 25, 2008

I see this in the domain error logs...

[25-Nov-2008 16:49:03] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: undefined symbol: php_pdo_get_dbh_ce in Unknown on line 0
[25-Nov-2008 16:49:04] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: undefined symbol: php_pdo_get_dbh_ce in Unknown on line 0
[25-Nov-2008 16:49:05] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: undefined symbol: php_pdo_get_dbh_ce in Unknown on line 0
[25-Nov-2008 16:49:10] PHP Warning: PHP Startup: Unable to load dynamic library ...
Using php 5.2.6 / mysql pdo module (compiled via whm > apache update) / mysql 5

View 4 Replies View Related

Dns Errors Very Often

Feb 27, 2007

there is "Cannot Resolve Dns" for my site for one or 2 regions .. Everytime i check my site my site with a Website Monitoring site , i get Cannot Resolve Dns for one or two regions .. can anyone please tell me what the problem can be ..

When i go to dnsreport.com , i get Fail in Missing (stealth) nameservers

Quote:

FAIL: You have one or more missing (stealth) nameservers. The following nameserver(s) are listed (at your nameservers) as nameservers for your domain, but are not listed at the parent nameservers (therefore, they may or may not get used, depending on whether your DNS servers return them in the authority section for other requests, per RFC2181 5.4.1). You need to make sure that these stealth nameservers are working; if they are not responding, you may have serious problems! The DNS Report will not query these servers, so you need to be very careful that they are working properly.

ns1.mysite.ws.
ns2.mysite.ws.
This is listed as an ERROR because there are some cases where nasty problems can occur (if the TTLs vary from the NS records at the root servers and the NS records point to your own domain, for example).

View 4 Replies View Related

S.M.A.R.T Errors On /dev/hda

May 29, 2007

S.M.A.R.T Errors on /dev/hda
From Command: /usr/sbin/smartctl -q errorsonly -H -l selftest -l error /dev/hda
ATA Error Count: 2
Error 2 occurred at disk power-on lifetime: 6001 hours (250 days + 1 hours) Error 1 occurred at disk power-on lifetime: 5973 hours (248 days + 21 hours)
----END /dev/hda--

This is the third time I got this message. My server is often down that SIM pretty much restart httpd, named, etc. every 2 hours.

I had no other explanation for the problem.

May 29 02:02:16 server filelimits: Increasing file system limits succeeded

View 8 Replies View Related

Errors

Jun 29, 2007

Seen this in /var/log/messages

Jun 29 12:35:48 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=3858 DF PROTO=TCP SPT=33891 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0
Jun 29 12:35:49 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=17089 DF PROTO=TCP SPT=33897 DPT=3306 WINDOW=5840 RES=0x00 SYN URGP=0
Jun 29 12:35:52 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=17091 DF PROTO=TCP SPT=33897 DPT=3306 WINDOW=5840 RES=0x00 SYN URGP=0
Jun 29 12:35:53 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=39040 DF PROTO=TCP SPT=33899 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0
Jun 29 12:35:56 server kernel: Firewall: *TCP_OUT Blocked* IN= OUT=eth0 SRC=(my server ip) DST=(another server IP of mine) LEN=44 TOS=0x00 PREC=0x00 TTL=64 ID=39042 DF PROTO=TCP SPT=33899 DPT=2534 WINDOW=5840 RES=0x00 SYN URGP=0

Here's the strange thing. The part that says "another server IP of mine" are two different OTHER servers of mine, BUT do not have cpanel nor part of the cluster. What could it be?

View 0 Replies View Related

ATA Errors

Jan 30, 2007

I have this when I rebooted my Centos server

Jan 31 04:39:22 servername kernel: ATA: abnormal status 0x7F on port 0xE807
Jan 31 04:39:22 servername kernel: ATA: abnormal status 0x7F on port 0xE007

What does this mean? I am using autoraid Accusys.

View 2 Replies View Related

Xml/rss Errors

Nov 10, 2007

I had to reinstall xml:rss perl module via whm. Client is getting this error still

Can't locate XML/RSS.pm in @INC (@INC contains: /home/client/dir/mgmt/perl /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at /home/client/dir/mgmt/commandline/erealms.pl line 36.
BEGIN failed--compilation aborted at /home/client/dir/mgmt/commandline/erealms.pl line 36.

Using cpanel 11 stable, centos 4.5

perl -v
This is perl, v5.8.8 built for i686-linux

View 3 Replies View Related

403 Forbidden Errors

Jul 1, 2008

I had made a page on my site earlier and when i went to it it gave me a 403 error so i tried fixing the .htacess then the site got messed up so i reset the .htacess to tis original settigns and now when i redirect to anything but the home directory it gives me a 403 error can anyone help?

View 3 Replies View Related

Read Only Errors

May 21, 2009

root@server [/backup/cpbackup/daily]# chmod 1777 /tmp
chmod: changing permissions of `/tmp': Read-only file system

root@server [/backup/cpbackup/daily]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 271G 135G 123G 53% /
/dev/sda1 99M 58M 36M 62% /boot
none 2.0G 0 2.0G 0% /dev/shm
/dev/sdb1 135G 80G 49G 63% /backup
/usr/tmpDSK 4.9G 64M 4.5G 2% /tmp
/tmp 4.9G 64M 4.5G 2% /var/tmp ....

View 2 Replies View Related