Any Mysql Monitong Service
Apr 29, 2008i have subscribe server http uptime monitoring service. may i know any provider provide mysql monitoring service?
View 3 Replies
ADVERTISEMENT
Failed To Restart Mysql Service
Apr 12, 2009My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed
And when restart (by WHM )
Restarting MySQL Server
whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275
mysql has failed, please contact the sysadmin (result was "mysql has failed").
My VPS in unmanaged, i can't access mysql.
MySQL Database Service Stops From Running
Jan 4, 2008I have a phpBB forum, which uses MySQl database.
For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.
What can cause such a frequent database failures?
Can someone attack the forum/database/server in a way that will cause the above problem?
(there is a good reason I consider this possibility very seriously)
How can I prevent futher database failures?
Setting Up Free Email Service And Storing Mails In MySQL
Feb 14, 2007I have a busy dating website with 30 000 registered users and ~200-600 users online all the time. I would like to offer free email with ~10 MB mailbox to all users.
I have an idea to use scripts provided by b1gmail.de. Its similar to Hivemail or Socketmail. It uses only one POP3 catch-all mailbox and stores all emails in MySQL database, including attachments.
My worries are about MySQL. If I have 30 000 users and each user has some 5000 messages in his/her mailbox:
30 000 x 5 000 = 150 000000
That's 150 million rows in one table!
I know, not all users will have 50000 messages in their mailboxes, but the number of users increases about +2000/month.
I can't imaggine how long time will need MySQL to find messages for each user in the table with 150 000000 rows.
I don't know - maybe it's not a problem at all. I just never had such large tables and I don't know if it's possible at all.
Another problem: I have Fedora Core 2 installed and even don't know yet if it supports files larger than 2 GB.
Maybe it's better to set-up normal POP3 mailboxes for all users instead of using one catch-all box and storing data in MySQL?
do not post warnings about spammers. In the beginning I'll provide email addresses only to "gold" members. I opened this thread because I don't want to set-up a system which will hang after a couple of months because MySQL will not be able to handle it or I will have other unknown problems.
Plesk Automation :: MySQL Server Not Starting Anymore - Failed To Restart Service
Jun 5, 2014What could I fix by trying to start mysql server, recieve following errors:
plesk interface:
Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start
from the console:
Code:
sudo service mysql start
start: Job failed to start
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:
[Code] ...
Plesk 12.x / Linux :: Centos 7 - Service Configuration (Bind Service Is Not Installed)
Apr 27, 2015I have a Server with Centos7 + Plesk 12 and in the service configuration say that the Bind service is not installed, from command line i have install named services and make a manual configuration the first domain, but when I return to the service page in plesk... the problem is the same, the Bind Service is not installed; then the problem is when i want create a new hosting i need to go to the ssh to make the DNS configuration...
View 1 Replies View RelatedPlesk 12.x / Linux :: Unable To Find Service Node For Web Service On Domain With ID 0
Sep 10, 2014Got following Problem: Unable to find service node for web service on domain with id = 0
After a Check from [URL] ....
I tried this: [URL] ....
Result:
+--------------------+--------------+---------------------------------------+------------------------------+------------+
| Domains | Service Type | IpAddressesCollections.ipCollectionId | Current value of ipAddressId | Have to be |
+--------------------+--------------+---------------------------------------+------------------------------+------------+
| XXXXXXXXXXXXX.org | mail | 30 | 0 | 1 |
+--------------------+--------------+---------------------------------------+------------------------------+------------+
Resolution:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -e 'Update IpAddressesCollections SET ipAddressId = 1 WHERE ipCollectionId = 30'
Result: ERROR 1062 (23000) at line 1: Duplicate entry '30-0' for key 'PRIMARY'
Plesk 12.x / Linux :: Unable To Find Service Node For Web Service On Domain With ID 6
Jun 24, 2015Deleted a domain workspace in Parallels Plesk and now I am getting this error when signing into the panel:Looked at the logs and been trying multiple commands (including the bootstrapper repair etc.)I found the full error from the logs:
[13-Jun-2015 16:35:33 UTC] PleskDBException: Unable to find service node for web service on domain with id=6
file: /usr/local/psa/admin/plib/PhDomain.php
line: 1404
code: 0
trace: #0 /usr/local/psa/admin/plib/Smb/Subscription/Domain.php(490): PhDomain->getWebHostingServiceNode()
[code]....
Plesk 11.x / Windows :: Values In Priority Of Service And Weight Of Service In SRV Records
Jul 6, 2014We are currently using Parallel Plesk 11.0 version and there is one requirement from microsoft provider to add the exact same values in SRV Records.
Priority of Service = 100
Weight of Service = 1
but these values are not available in the dropdownlist. attached are the screenshots.
Plesk 12.x / Linux :: Internal Error - Unable To Find Service Node For Web Service On Domain With ID 5
Jun 15, 2014Clean install on openSUSE 13.1
After deleting a domain, we got the following error which rendered the panel useless.
Internal error: Unable to find service node for web service on domain with id=5
Message Unable to find service node for web service on domain with id=5
File PhDomain.php
Line 1402
Type PleskDBException
Go To Previous Page
I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
May 8, 2009Since 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..
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
Jan 21, 2007I 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?
Mysql.sock Gone And Mysql Restart Doesn't Create It
Jun 16, 2008For 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 RelatedHow To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
Feb 11, 2008I 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?
Knowledge Of Mysql Exploit Or Mysql Injection?
Jan 17, 2008Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies View RelatedMySQL Monitor Shows MySQL As Offline When It's Not
Jan 15, 2007I'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?
Can I Move /var/lib/mysql To /home/mysql
Apr 15, 2009my /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 ?
Uninstall MySQL 3.23 And Install MySQL 5.0
Mar 28, 2007I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
Easy To Upgrade From MySQL 4.1 To MySQL 5
Jun 13, 2007I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies View RelatedMySQL Error : MySQL Server Has Gone Away
Dec 18, 2007I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
VPN Service
Sep 18, 2007If i wish to start up a business with the VPN service.. do i need to install any specific software on the server side? Can it be run on Windows?
View 4 Replies View RelatedSSL Service
Jul 13, 2009how to setup a Windows server to provide SSL service to other web sites. I'd like to offer a free service to my local customers and anyone who wants to secure their online operations.
can OpenSSL do the job?
Email Service
Jun 13, 2009I am trying to find the best economical solution regarding my email address but I need some advice pls.
I have a very small package with asmallorange and I have set up one of my business email in it. I didn't calculate that this business email could take so much space. I have some assistants which work in other places. One of my problems is these asistants who need to access this address too, are not allowed to access any free email provider like gmail, yahoo at their work computers because of their work policy. So I can't do forwarding and I need to have this email address under my domain.
I am thinking of these options:
1) Get more space . This will become expensive for me.
2) use a dedicated email service under my domain name.
I have no experience here and I wonder if using a gmail service under my domain will be blocked for my collaborators.
3) change host ( I am afraid to lose my data and my website database).
Pricing On New Service
Aug 20, 2009I'm going to start offering a KVMoIP service for my customers and am trying to get ideas on the pricing. What do y'all think about it? I know most places that I know about charge a setup + hourly fee, well, I like to be just a little bit better, so let's see what y'all have to say.
View 14 Replies View RelatedMonitoring Service
Jan 3, 2009Do you use any uptime monitoring service? If so, which one do you use? Do you use a paid monitoring service, or a free one?
View 14 Replies View RelatedService Exist
Mar 23, 2009I was thinking of putting together a DB of all the IPs I block due to spam, hackers, known proxies etc... this would help cut down on malicious use of services such as spamming forums, if I catch them once, they would not have chance to spam up my other forums if each forum checks the same block list. I could also auto block proxies by having it query up online proxy lists.
But before I reinvent the wheel, does such service online already exist? Kinda like RBL, but for web services. So you can basically block IPs off your site before they get used maliciously.
To be even more advanced some special port scanners could go around scan networks for infected machines and block those too.
How it would work:
Site A has a spammer from IP 1.2.3.4 and submits it to the block service. Spammer then goes on site B to try and spam that forum, but that IP is already blocked because the owner of site A submitted it to the list and site B checks against that list.
VPN Service Security
Jul 22, 2009The VPN service owner can he track and know all his customers activity
I mean let's say am a customer and I bought VPN subscription and then logged in with my new vpn ip and I login to my email , in that case the VPN service owner can he read know my email password or other sensitive data like if If I login to myspace.com can he know what password I used using his vpn server logs?
VPSLink :: Anybody Using Their Service?
Apr 20, 2009Anybody using their service? Prices are low, plans look good.
View 5 Replies View RelatedWww.geekrack.net Has Very Bad Service
Feb 28, 2008i ordered my server on monday,it took 80hrs to get the server,but the login panel can not be opened,then i ask them,their support is online in msn,i talk with them,but when i ask them about the login panel link can not open,they didnt reply me.it really disapointing,i ordered it one monday,but now almost friday,i still havent used it,regret to order it...
View 14 Replies View Related