We have created an account on our dedicated server in the Ensim appliance, however, when trying to add a database it fails and says;
mysql - Enable service
( ERROR ):Mysql error: (1226, "User 'root' has exceeded the 'max_connections_per_hour' resource (current value: 1)")
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've installed an SSL cert in an IP base site (over ENSIM panel), but now when I access to www.domain.com the explorer redirect me to https://www.domain.com:19638/webhost/rollout/site, and I cant see the site content.....I restarted apache after the Cert install, and nothing, still getting the same problem.
View 1 Replies View RelatedI am planning to move my sites from a dedicated server (Ensim Pro) at ev1Servers.net to a Plesk 8.1 based server at SoftLayer.com
The current server hosts 30+ websites. Most of those are static HTML sites and the remaining ones use MYSQL.
The technical steps are beyond me and I am looking for someone to help me. The move should not affect the customers and should minimize downtime as much as possible.
I also want to have all my accounts passwords, user names, database, email accounts moved and copied over to the Plesk server. The final step should ensure all accounts function properly.
If you have done this before, is there anything that I should pay attention to or be aware of?
Do you know of a good company that would do this for me? How much will it cost me?
how to install an SSL certificate on this server but really haven't a clue. I searched all over the internet and the ensim site with no luck. give me a little direction in my journey from hell.
View 10 Replies View RelatedWhile creating a domain on Ensim I got this error:
Code:
Field Disk Quota (WARNING): Disk quota is either not enabled or not supported for virtual domain filesystems.
diskquota - Reconfigure service
(WARNING):Group quota is not enabled on the server. Not configuring quota for the site. Please fix your server's quota problem and edit the site again if you want to configure quota for the site
I'm using RHES 3 + Ensim Pro 4.1.0-8, i know maybe an
option would be upgrade to Ensim Pro X, but right now I can not do that, i need alternative solutions..
We currently have a site hosted on a dedicated server, and we use Ensim to manage the site.
Although we can use Ensim to FTP, we mainly use Dreamweaver or other FTP clients to FTP.
What we are wanting to do, is set up and FTP user, so that they can only have access to certain directories. Is this possible? If so, what would I need to do?
Also, when they connect via an FTP program (assuming that the access has been set up as desired) will they only be able to see those directories specified?
My dedicated service provide only Plesk 8 (100 domains) or Ensim Basic. Which one is better?
View 1 Replies View RelatedI just want to know how can I enable directory listing while someone is browsing a directory that doesnt have an index.* created.. i know its a security risk but i really need it right now, right now a forbidden message appears, i just want that removed and all my files listed.
Can anyone explain me how to do that on Ensim Pro 4.1 for just 1 virtual site?
Im using RHEL 3.
I got a RHEL dedicated server it has Ensim Ensim Pro 4.0.3-22.rhel.3ES
I got a few email accounts over quota limit. Even though it reached the quota the still consumes mail.
the size keeps increasing until HD space runs out.
I checked other forums and they recommended to
do this
find /home/virtual/site#/fst/var/spool/mqueue/ -exec rm -f {} ;
I did this but there were no files in there to begin with.
So every hour i keep getting this failure notice.
This is a report generated by the hourly run of MailQueueCleaner. Some sites on this server have problems which prevent the processing of their email queues. UNTIL YOU RESOLVE THE PROBLEMS, THESE SITES WILL NOT BE ABLE TO RECEIVE EMAIL. A summary of the problems is included below.
sites over the quota show up here.
I just want to be abl to clear the mail out of selected accounts without logging in the account. I am sure it is some file to clear.
This is my problem.. on an Ensim box....
After login in using domain.com/webmail, everything is fine while I attempt to send mail.. but, If I try to forward an existen mail to a new destiny, an error message appears:
Forbidden
You don't have permission to access /webmail/src/compose.php on this server.
Already checked for allow/deny settings over httpd.conf and over the httpd conf for thiss site in particuular.
Directories at this site, are:
Code:
[root@server4.wolololo.com:~]pwd
/home/virtual/site2/fst/var/www/squirrelmail
[root@server4.wolololo.com:~]ls -ahl
total 240K
drwxr-xr-x 15 admin2 admin2 4.0K mar 6 16:43 .
drwxr-xr-x 10 root root 4.0K ago 18 2005 ..
-rw-r--r-- 1 admin2 admin2 8.3K mar 6 16:43 AUTHORS
-rw-r--r-- 1 admin2 admin2 66K mar 6 16:43 ChangeLog
-rw-r--r-- 1 admin2 admin2 8.1K mar 6 16:43 ChangeLog.locales
drwxr-xr-x 5 admin2 admin2 4.0K mar 6 16:43 class
drwxr-xr-x 2 admin2 admin2 4.0K mar 6 16:43 config
-rw-r--r-- 1 admin2 admin2 102 mar 6 16:43 configure
drwxr-xr-x 3 admin2 admin2 4.0K mar 6 16:43 contrib
-rw-r--r-- 1 admin2 admin2 15K mar 6 16:43 COPYING
-rw-r--r-- 1 admin2 admin2 15K mar 6 16:43 COPYING.locales
drwxr-xr-x 4 admin2 admin2 4.0K mar 6 16:43 doc
drwxr-xr-x 4 admin2 admin2 4.0K mar 6 16:43 functions
drwxr-xr-x 29 admin2 admin2 4.0K mar 6 16:43 help
drwxr-xr-x 2 admin2 admin2 4.0K mar 6 16:43 images
drwxr-xr-x 3 admin2 admin2 4.0K mar 6 16:43 include
-rw-r--r-- 1 admin2 admin2 684 mar 6 16:43 index.php
-rw-r--r-- 1 admin2 admin2 221 mar 6 16:43 install
-rw-r--r-- 1 admin2 admin2 8.7K mar 6 16:43 INSTALL
drwxr-xr-x 50 admin2 admin2 4.0K mar 6 16:43 locale
drwxr-xr-x 18 admin2 admin2 4.0K mar 6 16:43 plugins
drwxr-xr-x 2 admin2 admin2 4.0K mar 6 16:43 po
-rw-r--r-- 1 admin2 admin2 2.6K mar 6 16:43 README
-rw-r--r-- 1 admin2 admin2 4.7K mar 6 16:43 ReleaseNotes
-rw-r--r-- 1 admin2 admin2 2.5K mar 6 16:43 ReleaseNotes.locales
drwxr-xr-x 2 admin2 admin2 4.0K mar 6 16:43 src
drwxr-xr-x 3 admin2 admin2 4.0K mar 6 16:43 themes
-rw-r--r-- 1 admin2 admin2 4.6K mar 6 16:43 UPGRADE
-rw-r--r-- 1 admin2 admin2 43 mar 6 16:43 version
Code:
[root@server4.wolololo.com:~]ls -alh src/
total 428K
drwxr-xr-x 2 admin2 admin2 4.0K mar 6 16:43 .
drwxr-xr-x 15 admin2 admin2 4.0K mar 6 16:43 ..
-rw-r--r-- 1 admin2 admin2 1.1K mar 6 16:43 addrbook_popup.php
-rw-r--r-- 1 admin2 admin2 10K mar 6 16:43 addrbook_search_html.php
-rw-r--r-- 1 admin2 admin2 10K mar 6 16:43 addrbook_search.php
-rw-r--r-- 1 admin2 admin2 20K mar 6 16:43 addressbook.php
-rw-r--r-- 1 admin2 admin2 62K mar 6 16:43 compose.php
-rw-r--r-- 1 admin2 admin2 14K mar 6 16:43 configtest.php
-rw-r--r-- 1 admin2 admin2 2.2K mar 6 16:43 delete_message.php
-rw-r--r-- 1 admin2 admin2 4.6K mar 6 16:43 download.php
-rw-r--r-- 1 admin2 admin2 2.4K mar 6 16:43 empty_trash.php
-rw-r--r-- 1 admin2 admin2 2.4K mar 6 16:43 folders_create.php
-rw-r--r-- 1 admin2 admin2 4.7K mar 6 16:43 folders_delete.php
-rw-r--r-- 1 admin2 admin2 11K mar 6 16:43 folders.php
-rw-r--r-- 1 admin2 admin2 2.4K mar 6 16:43 folders_rename_do.php
-rw-r--r-- 1 admin2 admin2 2.5K mar 6 16:43 folders_rename_getname.php
-rw-r--r-- 1 admin2 admin2 2.2K mar 6 16:43 folders_subscribe.php
-rw-r--r-- 1 admin2 admin2 6.7K mar 6 16:43 help.php
-rw-r--r-- 1 admin2 admin2 1.9K mar 6 16:43 image.php
-rw-r--r-- 1 admin2 admin2 492 mar 6 16:43 index.php
-rw-r--r-- 1 admin2 admin2 16K mar 6 16:43 left_main.php
-rw-r--r-- 1 admin2 admin2 5.9K mar 6 16:43 login.php
-rw-r--r-- 1 admin2 admin2 2.5K mar 6 16:43 mailto.php
-rw-r--r-- 1 admin2 admin2 8.5K mar 6 16:43 move_messages.php
-rw-r--r-- 1 admin2 admin2 16K mar 6 16:43 options_highlight.php
-rw-r--r-- 1 admin2 admin2 6.0K mar 6 16:43 options_identities.php
-rw-r--r-- 1 admin2 admin2 5.4K mar 6 16:43 options_order.php
-rw-r--r-- 1 admin2 admin2 17K mar 6 16:43 options.php
-rw-r--r-- 1 admin2 admin2 9.6K mar 6 16:43 printer_friendly_bottom.php
-rw-r--r-- 1 admin2 admin2 1.4K mar 6 16:43 printer_friendly_main.php
-rw-r--r-- 1 admin2 admin2 1.3K mar 6 16:43 printer_friendly_top.php
-rw-r--r-- 1 admin2 admin2 32K mar 6 16:43 read_body.php
-rw-r--r-- 1 admin2 admin2 6.2K mar 6 16:43 redirect.php
-rw-r--r-- 1 admin2 admin2 7.6K mar 6 16:43 right_main.php
-rw-r--r-- 1 admin2 admin2 19K mar 6 16:43 search.php
-rw-r--r-- 1 admin2 admin2 2.8K mar 6 16:43 signout.php
-rw-r--r-- 1 admin2 admin2 7.9K mar 6 16:43 vcard.php
-rw-r--r-- 1 admin2 admin2 4.3K mar 6 16:43 view_header.php
-rw-r--r-- 1 admin2 admin2 3.4K mar 6 16:43 view_text.php
-rw-r--r-- 1 admin2 admin2 5.2K mar 6 16:43 webmail.php
As you can see, permissions on file and directories are OK...
MS Exchange Managing Software with IIS Support ? Something like cpanel, but with Windows Exchange support.
Does Ensim or Plesk supports Exchange ? (Creating users, remove, edit..) ?
Currently i'm migrating all my domains from ensim to Plesk.
I use for this the Plesk migration tool.
From the moment I change the nameservers, some mail will still be delivered (for a while) to the old ensim server and not the new plesk server.
How can I move or migrated mail from mqueue to the correspondening account under Qmail?
Because the ensim server is configured to be the final destination for mail . I cannot add extra MX records with a lower destination.
Or can i change easly the ensim server to be not the final destination)?
I 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
I have this error my site:
dbconn: mysql_connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
*dbconn: mysql_connect: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug*
I recived this error message while testing my website registartions form and was wondering what to do with this and i think it should be permission to access to the database is not given to the user but this is my own account and im the admin and how come the access is denied?
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'alien'@'localhost' (using password: YES) in /home/seektran/public_html/db_connect.php on line 12
Error: Could not connect to database server. Please try again later.Access denied for user 'alien'@'localhost' (using password: YES)
in phpMyadmin when trying to import a database from a file, i'm getting the error:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
The file I'm importing is only 7.08MB
I have tried setting the packet size in the shell as follows:
mysql> mysqld --max_allowed_packet=32M
I got no error or no confirmation either using this command, sorry I dont use shell commands much so I dont know if thats a problem or if it worked.
I have a new customer moving from another host. His account was terminated already, so just have backup file. When restoring his mysql database, I have this error
Quote:
Unable to restore database dbname.sql to agesuke_forum : ERROR at line 521 in file: '/backup/dbname.sql': Unknown command ''.
Googling shows error in version < 5.0.6 but we are using 5.1.35 already. Is there any idea to fix? This account will run on CentOS 5 - 64bits, FYI.
MySQL Error : Out of memory
I'm getting this very frequently today
MySQL Error : Out of memory (Needed 76760 bytes)
Error Number : 5
Request Date : Friday, November 7th 2008 @ 01:52:17 PM
Error Date : Friday, November 7th 2008 @ 01:52:18 PM
Script : [url]
Referrer : [url]
IP Address :
Username :
Classname : vB_Database
MySQL Version :
I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal.
I already ran optimization on the database too.
It started happening yesterday, pretty much after I installed this hack:[url]
Quote:
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-networking
safe-show-database
query_cache_limit=2M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=8M
max_connect_errors=20
max_allowed_packet=32M
table_cache=1024
record_buffer=8M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_swedish_ci
[mysql.server]
user=mysql
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=24M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423
Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
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
MySQL 5.0.27
phpMyAdmin 2.5.0
Php ver 4.4.0
IIS6 Win2003 Web Edition - dedicated
I cannot work out what is going wrong here. I have been up all night trying to work it out!
Have installed MySQL + PHPmyAdmin no errors no problems. Log into phpmyadmin and look at a database but it will not show how many records are in the field nor what size the records are. It says records - unknown, size unknown
I've got a Fully Managed VPS hosting service running my sites and this morning I got the following error messages. My host says they do not monitor mySQL yet this error took my whole store down and kept it down for several hours until I noticed that. It's not a complaint, just asking your opinions on what this could be and what should i do about it etc.:
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /home/store/public_html/include/func/func.db.php on line 47
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/store/public_html/include/func/func.db.php on line 47
Sorry, the shop is inaccessible temporarily. Please try again later.
Getting this frequently
MySQL Error : MySQL server has gone away Error Number : 2006
/etc/my.cnf
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=300
max_connections=1000
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=4M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
[mysql.server]
user=mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
I have mysql 5 / php 5 / apache 2 with cpanel/whm.
I've been trying to import a 1MB sql file into mysql under GoDaddy Linux Deluxe shared hosting and after waiting forever I get a 2006 error -server has gone away. didn't know that 1MB was such a big file!! anyone else experiencing the same?
View 9 Replies View RelatedI update MySQL from version 4 to 5.0.67-community.
Now, I often get errors:
Quote:
MySQL error code: 2006
MySQL error text: MySQL server has gone away
I think MySQL is not properly configured, but I don't find problem.
Below is content of the file - my.cnf. Please see it and compare with yours. Maybe I have low limits into it. Please give me any advice ...
Quote:
[mysqld]
datadir=/var/lib/mysql
skip-locking
safe-show-database
old-passwords = 1
query_cache_limit=1M
query_cache_size=80M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=50
max_connections=400
interactive_timeout=30
delayed_insert_timeout=30
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=90M ## 32MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=4 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
[mysql.server]
user=mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
#open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
One of our servers mysql daemon is restarting most of the time and got the error message in the message file. Did anyone see similar error message?
Jun 1 05:46:44 kernel: audit(1212317204.342:6991): avc: denied { read } for pid=17286 comm="mysqld" name="/" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.343:6992): avc: denied { getattr } for pid=17286 comm="mysqld" path="/tmp" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.346:6993): avc: denied { read } for pid=17286 comm="mysqld" name="time_zone_leap_second.frm" dev=hda2 in
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases:
Quote:
ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database roundcube......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists'
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database horde......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists'
ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist
ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist
ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist
ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist
ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist
ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist
ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string
Done
What does this error mean and how to solve this problem?
I have updated cpanel and mysql but the problem is still found
This problem found while trying to restore any account not this one only..
I'm having a bit of trouble here with MySQL, I don't know what to do. Centos 4.3, Mysql 4.1
Data is stored in /var/lib/mysql/
I'm looking to move that information to a second hard drive soon, and did a quick test of just copying it to another place on my existing drive. It won't start.
Quote:
[root@localhost ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
Error logs
Code:
071106 12:14:33 mysqld started
071106 12:14:33 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13)
071106 12:14:33 [ERROR] Aborting
071106 12:14:33 [Note] /usr/libexec/mysqld: Shutdown complete
071106 12:14:33 mysqld ended
071106 12:17:00 mysqld started
071106 12:17:00 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13)
071106 12:17:00 [ERROR] Aborting
071106 12:17:00 [Note] /usr/libexec/mysqld: Shutdown complete
071106 12:17:00 mysqld ended
I have tried even chmod 777ing the msyqltf folder (my copy) to no avail.
my.cnf
Code:
[mysqld]
datadir=/var/lib/mysqltf/
socket=/var/lib/mysqltf/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I've tried moving it to different locations. I even tried moving the original folder and renaming it, and still get this problem.
Trying to install Mysql 5 on a Windows 2003 server but getting this error attached.
For one, trying to follow this guideline
[url]
Download from:
[url]
(msi file, x86)
Filename: mysql-essential-5.1.35-win32.msi
We have installed ruby on rails on our server.
root@Server [~]# gem list |grep mysql
mysql (2.7, 2.6)
But when we try to connect it still says "mysql required".