I am not sure whether I ask this question on the right forum. My debian mailserver is depending on a MySQL database. Every reboot it takes around 30 minutes to boot because of the database check. I could not find the right command or setting to boot without this check. Do you know how to do this.
View 1 RepliesI'm running zoneminder on Ubuntu 9.10 Even with a UPS the power quite often fails enough that I need to drive over bring home the computer and run ( mysqlcheck --all-databases --auto-repair -p ) Then enter my user PW then my Mysql PW. Both are the same. How ever if it were possible to create a script that could run at start up I could get anyone to cycle the power and let it fix it's self.
View 6 Replies View RelatedI am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
A few days ago I upgraded my debian sid system, and since then systemd does a filesystem check on every boot which takes over two minutes, disobeying the existing settings I had. How can I set systemd to do a filesystem check only once every a set number of mounts, like I had set up before the upgrade?
View 5 Replies View RelatedMy server is using MySQl mysql-5.0.77-3.el5 on Centos 5.4.When I check mysql log at /var/log/mysqld.log,it displays warning Quote:
100524 11:46:21 mysqld started
100524 11:46:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100524 11:46:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
[code]....
I am new to Debian but not Linux-based systems. I have been experimenting a lot with Debian Lenny/Squeeze. I am growing more comfortable each day with the Debian design. Yet there remain many unexplored areas. I am creating a migration check list. Things to check, prepare, or reconfigure when moving from one Linux-based system to Debian.
I have a good computer background and my current check list probably is fairly good. Yet I would appreciate input and opinions from experienced Debian users of things to watch in such a migration. Login defs, passwd/group files, different directory locations, keymaps, services and daemons, etc. I am not too concerned with the desktop as I plan to stick with KDE 3.5 for a while and I can basically move those settings across.
I have a mysql server which "goes down" every day at 9, because the debian-sys-maint user needs to run a table check, for no particular reason.
I assume it's a cron-job, but I can't find anything related to this. There's the mysqlautobackup script, but that runs at 4 in the morning, which is expected and perfectly acceptable.
from nmap localhost | grep mysql command i will come to know whether mysql server is running or not.my problem is i want to test whether mysql server is running or not in shell script and if it is running i need to tell the user to stop the server to run the shell script.
View 3 Replies View RelatedI can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
View 1 Replies View RelatedI'm very new to linux and running debian 4.0. On boot got an error:
I did a ghost image of drive before I do any more damage and when performing the ghost, ghost stated I need to run fsck. I created the image and noticed that a lot of folders were missing (bin, boot and others).
1. How do I run check disk from an boot disk?
2. Is there something else I should consider?
I have a RHEL5 machine having mysql5.0.22 is installed in it. i also installed java through "jdk-1_5_0_19-linux-i586.bin" package, and its version is 1.5.0_19. I am trying to check if any JDBC driver for Mysql Server is installed on my system . How can I do this? If any driver is already installed How can I get the file path for those driver files? is it comes along with jdk packages? As i am not a programmer, and does't know more about jdbc.
View 1 Replies View Relatedi ,musing mysql5 at fedora12 i have just installed it but i ,m using mysqladmin -p root password mypassword it says ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin -uroot password 123456' at line 1
View 10 Replies View RelatedQuote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
as far as i know Debian "Squeeze" has a disk check utility, but you can't run this on a mounted filesystem. Is there a way to trigger this during boot (before filesystem is mounted) ? I can run this once a month to keep filesystem healthy....
View 2 Replies View Relatedi am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
Below is the recipe I've used to compile dwm from source on Squeeze
su
apt-get install devscripts debian-keyring
apt-get build-dep dwm
exit
It all seems to work, however debuild gave an error about secret keys. Is this a sensible procedure? What happens in the (probably unlikely) event there is another source patch?I've gone to a tiling window manager as the result of the purchase of a wide screen LCD monitor. I like to have some stuff down the right hand side when running Firefox and OpenOffice in the main panes. Any configuration tricks welcome. Modern screens are the wrong shape!
I have installed debian on my laptop and included during the installation the webserver version. Now I want to develop a page locally to test it before I put it on the web. I first had an old reflex, jumping straight away and installing xampp. But then I thought that I already all that it takes as I installed the webserver feature of debian. I installed phpmyadmin ( with the command #apt-get install phpmyadmin) as to be able to create and attribute databases but when I try to log in I have the following message:
"Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
I googled but I cannot find the mysql.conf (I searched using "find") but with no result. It is all very blury what is going on with this webserver option running on my laptop...
my Fedora 12 does fsck on boot time to time and sometimes it's really annoying having to wait for the check to complete. In Linux Mint pressing <Esc> cancelled the check; however in Fedora this does not work (nor does Ctrl+C nor anything other I've tried). What is the key to cancel the check in Fedora?
View 11 Replies View RelatedWhat are others' views and experience regarding automatically checking filesystems (running fsck) at boot time?To be more clear, I have left the ext3 filesystems on this machine set to require checking after a fixed number of mounts by using tune2fs with the '-c' option. I've done this mainly because of the following (from the tune2fs man page):
Code:Youshould strongly consider the consequences of disabling mount-count-dependentchecking entirely. Bad disk drives, cables, memory, and kernel bugs could all corrupta filesystem without marking the filesystem dirty or in error.e using journalingon your filesystem, your filesystem will never be marked dirty, so it will not normallybe checked. A filesystem error detected by the kernel will still force an fsck on the nextreboot, but it may already be too late to prevent data loss at that pointBut what does anyone else do? Is there really much risk to disabling this automatic checking
I have updated from Karmic to Lucid not long ago, and everything went smooth and my system is been working like a charm for about a month. And it still does, with the only issue being that every time I restart my system, one of my partitions is checked.
My disk is split into 4 partitions:
sda1, NTFS for windows
sda2, ext4 for "/"
sda3, ext2 for /home
sda4, swap
Now what seems to happen is that sda3 is being marked as "not clean" on every shutdown, which makes me assume that is not being umounted at all.
I've been reading logs, commenting network drives out on fstab.. nothing does the trick.
I've booted into single mode and run e2fsck (which doesn't find anything wrong, and marks the FS as "clean") and then rebooted. The result is: if the FS wasn't mounted when I restart, then I get a clean boot once, but it is checked on the following one; if it was mounted then it is again checked at start-up.
Again, all points to the problem being that the FS is not cleanly umounted on shut-down.
I could not find any log with info of the processes killed and FS umounted at shut-down, so if anybody knows where to look, it could be a good start.
I'm using debian testing with grub2. Is there a way to stop the FS check at boot (something like ctrl-c) after the check has started and continue with the boot process as usual?.
View 9 Replies View RelatedWhile booting Slackware 13.1 it stops to check sda4 It says something about discrepancies. This started today after leaving the system up overnight. The system was suspended and wouldn't respond. I ended up have to do a hard reboot. The system seems to be working fine, but it does this every time I start Linux. The sda4 partition is Windows XP. XP also is working fine. While Linux is checking sda4 there is a statement that I need to run fsck without options. When I ran fsck I got the following message.
root@b-bhome:~# fsck
fsck from util-linux-ng 2.17.2
e2fsck 1.41.11 (14-Mar-2010)
[code]....
i am making the shift from centos to debian as i have heard that debian has lot of packages compared to centos and can make you learn more,i want to know how can i match the md5sum provided on the download page with the DVD images
View 3 Replies View RelatedThere are numerous fs checks with transaction log replay at every boot of my opensuse 11.4 notebook.I do not see any error messages on the console during shutdown or startup (but maybe I am just reading too slow)./var/log/messages contains some error messages from NetworkManager during shutdown, but I think they are unrelated.Filesystems I use are ext4 for /boot, ntfs for windows partitions, reiserfs for the root filesystem and for several logical volumes.
As far as I could see the checks are only done on the reiserfs filesystems on the logical volumes but I cannot see any warnings during volume group activation, so it seems the logical volumes are deactivated at shutdown.Of course I do wait until the notebook powers off by itself on shutdown.I'll provide /var/log/messages of a shutdown/boot shortly
Code:
# cat /etc/fstab
/dev/disk/by-id/ata-ST9320423AS_5VH2RFHZ-part7 swap swap defaults
[code]....
I've been stupid, and used kleansweep, which deleted a load of files and in the process killed everything. When I boot I get "file system check failed". Then it gives me a command prompt. I really don't want to have to reinstall ubuntu as I have a lot of stuff installed on it.
View 9 Replies View RelatedI have recently noticed that my HDD fsck during boot up (generally done after 30 mounts) is always skipped. A file system check has never happened. I don't remember if this is the case ever since I upgraded to Lucid or was it after I tweaked some settings.I am a learner who keeps tweaking some minor settings, so I am not sure if I have screwed up something.At boot I get the following message:
Code:
fsck from util-linux-ng 2.17.2
fsck from util-linux-ng 2.17.2
[code]...
Every time I boot up I have to go through a disk check and then restart, how do I stop it from happening? When the disk checks happening I press escape and it usually says its deleted inode something because it has zero Dtime or some thing similar and also a paragraph of repeated lines saying something like all system files need alsa base.cnfg it will be ignored in a future release then the disk check completes and it restarts and is fine then, also sometimes it says dev/sda5 (my ubuntu partition) was not cleanly unmounted check forces. Is their a way to stop this happening as it ends up taking ages just to login.
View 3 Replies View RelatedI applying changes through update manager in ubuntu 10.04 then my computer froze. So I had to restart it manually.
Now I can't boot ubuntu normal or recovery mode.I get an error message saying 'the disk drive / is not ready yet or blah blah'.I don't have a livecd to fix it this with... but here is my 'cat /etc/fstab' relevant output
/host/ubuntu/disks/root.disk / ext4 loop,errors=remount-ro 0 1
/host/ubuntu/disks/swap.disk none swap loop,sw 0 0
I have a custom modified Ubuntu LiveCD. Sometimes when I boot from the CD, after it detects the HDDs it starts automatically scanning and repairing them even if the partitions are windows partitions. What do I need to modify to make it not scan/repair any partitions/drives at boot?
View 2 Replies View Related