I tried to down grade my PHP5.3.x to 5.2.6 and some how I broke the connection to my Mysql. I needed to do this for version 6.xx of Drupal. Anyone know a quick fix to the mysql.lock or do I have to re-install Mysql?Error Message:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13).
View 6 RepliesKmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:
100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled.
100503 10:00:15 InnoDB: Started; log sequence number 0 31413862
100503 10:00:15 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without
[code]....
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]...
OK, I'm not really a newbie, but I definitely no expert either.I've been surfing the web trying to find a good tutorial on locking out users after three failed logon attempts.At present I've reset everything in the /etc/pam.d directory back to the default state. This sets up all my password requirements and this works. Now I need to crack getting the account to lockout after three failed attempts. Let me know what files you need to see in the pam.d directory and I'll paste them in.
View 1 Replies View RelatedI try to configure account lock out after 5 failed connections attempt with help of PAM. I add the following string to /etc/pam.d/login:account required pam_tally.so per_user deny=5 ulock_time=180 no_magic_root reset.Unfortunatly this solution doesn`t work. Can you give me advice how to set 5 connection attempt, block user and unlock account after 180 seconds?
View 2 Replies View RelatedI've just installed 11.1 and so far things seem to work OK. When I left the machine the screen saver kicked in and wouldn't let meback on with my password I chose during installation (and the only password I chose!) Re-booting the machine sorted the problem...until next time! I have now disabled the lock out for the screen saver so things ought to work now, but why did it do this? New with openSuse!
View 9 Replies View RelatedOn my windows console, i have installed sun virtualbox. I only have 768MB ram and so i downloaded a trial version of eboostr. I thought it would work, but when i tried an install of 11.2, also, i tried a debian install, it did the same thing, it froze up in the middle of the install with the error Code: unable to allocate and lock memory. I guess that eboostr doesn't work, but is there a way to use a flash drive as ram in virtual box?
View 5 Replies View RelatedI have to switch from VMWare Server 2.0 to XEN due the compilation of the kernel module fails. But XEN doesn't work on my newly upgraded server (fromm 11.0 to 11.3). When I install XEN via yast and do a reboot, then the screen goes black and the LEDs of Num and Scroll Lock are blinking. The last message i can see before the screen goes black is something like that:
[Code]...
I am having fedora 12 with php and mysql rpms installed on my computer.. but I am unable to log in...nether create an user?
View 3 Replies View RelatedI have a couple of USB pen drives, they are 8 and 16 gigs.I want to set one up to run as a �Live KDE� drive and put the �install DVD� in the other.Where would I find directions to do this?
View 2 Replies View RelatedIn looking at the release notes, I saw the comment File locations changes:
* MySQL socket file and pid file were moved from /var/lib/mysql to more reasonable location /var/run/mysql by default.
* MySQL log files are in /var/log/mysql. Not sure what I was supposed to do with that information. So I ignored it. Now, I am finding some issues with it. The web server works, but any connection to the database fails with 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)The thought dawned on me that maybe all my databases were erased and none set up. Going in to the terminal, I could connect and list and query the databases. So even though I backed them up, they still are there!
phpMyAdmin gives the same error message.
However, when I go into MySQL Administrator, it works fine.
I forgot where I saw it, but the socket is still set to var/lib/mysql. I could not find any mysql install log and would say what was in my cnf.my, but it still doesn't exist just as it has not in the past. Not sure if I should allow the MySQL Administrator to create it since I always ignored the prompt in the past and it worked. (Just wishing to keep the defaults)
At first I thought the upgrade upgraded the MySQL, but it's still 5.1.39 as I believe before. I've un-installed mysql-server and re-installed it with no change.
Can anyone can tell me how to get the socket to /var/run/mysql or what else is wrong? I read one place where mysql is supposed to set it up.
while creating a new database iam facing the below problem
mysql> create database auto-download-gta; 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 '-download-gta' at line 1
Can't single the cause of the error.
mysql> CREATE TABLE Shipment (
-> Shipment_ID INT(10) NOT NULL,
-> Delivery_ID INT(10) NOT NULL,
-> Customer_ID INT(10) NOT NULL,
-> Driver_Employee_ID INT(10) NOT NULL,
-> Consignee VARCHAR(255) NOT NULL,
-> Payment_Method VARCHAR(255) NOT NULL,
-> Payment_Received VARCHAR(1) NOT NULL,
-> CONSTRAINT PRIMARY KEY (`Shipment_ID`)
-> FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
-> FOREIGN KEY (`Customer_ID`) REFERENCES `Customer`(`Customer_ID`)
-> FOREIGN KEY (`Driver_Employee_ID`) REFERENCES `Driver`(`Driver_Employee_ID`)
-> )ENGINE=InnoDB DEFAULT CHARSET=latin1;
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 'FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
FOREIGN KEY (`C' at line 10)
I was wondering if someone could maybe provide me with a list of things to give a new user using the useradd utility. ( home directory, permissions, etc.) or even point me in the direction of a solid walkthrough
View 4 Replies View RelatedI am running OS 11.3 and I want to create a boot CD so that if my boot partition is moved I can still boot from the boot CD and re-initialize grub again. Is there some easy to use utility which will enable me to do this ?
View 3 Replies View RelatedI am attempting to write a backup script that will do the following:
1) lock and flush tables on a mysql db
2) dump the db to a file
3) unlock the tables
4) rsync the file to offsite storage
It all seems to be going well. However, obviously I don't want to setup ssh to the storage server on another network as the root user without a password. so I am attempting to su as the backup user inside of the script but when I try to run the script everything happens as it should until I try to so.. then it jumps out of the script .. akss me to login as the backup user.. proceeds to rsync to the offsite storage it does all this and then resumes execiting the script. it is not going to be setup as a cron job. it will be executed manually. assuming that is the case, how can I get the script to run without prompting for a password?
Here is what I've come up with so far... assuming that the script is run as root and the identity of the backup user will need to be assumed inside the script without perstering the user to enter the backup user's password.
[Code]....
what is wrong with this SQL to create a stored procedure in MySQL please?
Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `CheckStatus`(
IN start_date DATE,
IN end_date DATE)
BEGIN
[code]...
To me the syntax is correct. It complains with error 1327 'Undeclared variable: temp_sales'. What I don't understand is why I would need to declare a temporary table's name as a variable. Am I missing something here?
I'm creating script to connect to mysql and perform function. I'm into process in querying mysql from shell. Here is the content of a sample script:
Code:
#!/bin/bash
USER=scripter
PASS=test123
DB=test_scripts
I installed openSUSE 11.4 on HP elitebook 2560p few days ago (using KDE live CD). In general system is working fine, but steel I cannot resolve couple of really annoying issues: 1. I've created encrypted partitions for swap and home during OS installation. As result the system keep asking for passwords for each of encrypted partitions before show login screen. That leads to situation when I have to type 3 passwords during each boot/reboot. I was using the same configuration (swap and home were encrypted) on Ubuntu 11.04 and there both encrypted partitions were mount automatically with no password typing after login to the system. Could you please tell how I can configure the same behavior on openSUSE 11.4 ?
2. I've enabled auto screen lock after 5 mins being inactive. As result when I going back to laptop and to unlock the screen the system shows login screen (default login screen with user selection). But when user and password filled in I click login it creates entire new KDE session. Therefore all staff that was open before screen lock is gone. However old session is still in the system (it appears in output from 'w' command).
our prof wants us to make some measurable changes in the kernel as a part of our assignment. I'm new to linux (started using linux only day b4 yest)... till now i've built a new kernel using cloneconfig and ended up with a rpm package (since i couldnt find any other option).and here's the prob
1. how to make changes in the kernel code?
2. do i have to create an rpm everytime after a change? (it jus takes too long )
I have been using GHOST for quite a few years to back up my Windoze partitions from NTFS to a series of images on a fat32 partition. I usually boot off a DOS7 bootable CD and simply ghost over to the fat32 partition.
I am rebuilding my laptops and desktops to dual boot Windows7 and Suse 11.2
My goal is to create restore images from my NTFS and ext3 partitions into directories on the fat32 partition for a restoration to my "gold baseline" build after any corruption.
My partition layout is below. This is output from gdisk.exe in DOS7. It's an 80gig drive.
1 = Windows-7
2 = /boot
3 = swap
5 = /
6 = /fat32
[Code]....
I am installing openSUSE 11.2 on a laptop. After installation, reboot, auto-configuration, the screen show lines of text following "Starting SuSEconfig. The latest line is "Creating cache files for fontconfig". I don't understand why this specific operation takes too long; since almost an hour has passed. Is there a way to speed up and complete the process so that I can login and start using openSUSE? I did try hitting the spacebar and moving the mouse but nothing happens.
View 1 Replies View RelatedI'm trying to install workbench on my opensuse 11.2 x64 bit version but I got a problem with python available version on opensuse is 2.6.2 and the required version is 2.3.
how Could I solve this?
Through YaST's System Services I configured an application to start on boot. However, the application (mediatomb) is using mysql, so it should not be started before mysql. It is however, which means mediatomb fails to start.
How can I make sure mysql is started before mediatomb?
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
Early in the boot process, system generates message "Creating nodes with udev." After a pause, CPU timeout dumps are listed on the display. Likely it is related to wthe display driver (Intel 845G) as the system can be brought up in failsafe mode. /etc/X11.conf is intact. The system was apparently successfully upgraded online from 11.3 using the zypper method. This issue has appeared a day following the upgrade, after restarting the 11.4 system.
View 1 Replies View RelatedI just downloaded OpenOffice 3.2.1 from the openoffice.org weebsite. I followed the instructions precisely and everytime ended up in the same error message - 'error: can't create transaction lock on /var/lib/rpm/.rpm.lock (Permission denied)'. I am using Fedora 13.
View 2 Replies View RelatedWhen i connect windows server 2003 from ubuntu these error displayed .When i installing the tsclient, by executing these following command from a Terminal window:
sudo apt-get install tsclient
When i run these command the following error displayed.
E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?
I have a HP Pavilion dv4 that is 4 months old. Yesterday it suddenly seemed to restart then once I logged in it turned off. When I tried to turn it on some of the lights came on and the caps lock and num lock started flashing. Since then I have not been able to get it to work correctly.It once seemed to turn on but died again after the login window.I tried to use my live cd but the same thing happened. It started loading once, but then shut down again. Every other time it stayed dead minus the lights
View 1 Replies View Related