I just finish tring to get my mail server running but I get an error in my mail.log
Jan 21 16:33:08 server imapd-ssl: Connection, ip=[::ffff:67.223.78.XX] Jan 21 16:33:08 server authdaemond: failed to connect to mysql server (server=127.0.0.1, userid=postfixadmin): Access denied for user 'postfixadmin'@'localhost' (using password: YES) Jan 21 16:33:08 server imapd-ssl: LOGIN FAILED, user=jason@[mydomain].com, ip=[::ffff:67.223.78.76] Jan 21 16:33:08 server imapd-ssl: authentication error: Input/output error
I have the right password in all the mysql config files and tried to reset the password in the sql database with no luck. I granted perms to all and its still giving me the error.
I've just upgraded my 9.4 to 9.10 on my 64bit desktop PC. Shortly afterwards I noticed that MySQL had gone away. There was no mysqld running. I tried a restart to no effect. So tried an un-install and re-install with the Package Manager. This failed! There was quite an extensive message in details, which started:-
invoke-rc.d initscript mysql, action "start" failed dpkg: error processing mysql-server-5.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent prevent configuration of mysql-server
And it goes on, but that's the essence of it. I subsequently tried a complete removal and re-install, to no avail.I notice that /var/log/messages contains:
So that means the User Test can connect from any host without password and with the named privileges, but he has no right to grant any privileges. CONSOLE:
I'm using slackware 13.1 and I have a problem to accept remote access to mysql server.The steps I have followed to do that thing are:vi /etc/my.cnfline skip-networking is commented bind-address my_ipaddressI opened the port 3306 of my firewallAlthough I can connect locally, i.e. mysql -u a_user -h localhost -pI can't do it remotely i.e. mysql -u same_user -h my_ipaddress -pI have also turned off my firewall, but nothing.telent 3306 my_ipaddress results in: telnet: connect to address my_ipaddress: Connection refusedMy my.cnf file is:
I am not able to start mysql server...when i type command sevice mysqld start it saysMySQL Daemon failed to start.Starting mysqld: [FAILED]so how to solve this problem ?
Mysql can't start after I uploaded my.cnf file in /etc directory before that everything was okay but after I uploaded my.cnf and then restarted the mysql it can't boot Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! I tried to delete my.cnf and try again but the same error ...
I recognize that this isn't the typical question, but I have a problem with my OpenSUSE webserver, and I thought I would prevail on the community for some guidance. I have this webserver with an important MySQL db on it. The RAID array seems to have died while I was moving. (did someone drop it? dunno) Now it can't find any boot device. It has 4 old SCSI drives.
So, I know how to mount a IDE or SATA drive as a slave, in a Linux environment to read data off of it (to copy the MySQL files off of it.) But, how do I do that with a SCSI drive? Also, I have an additional (identical) server to the crippled one. What will happen if I just slide one of the scsi drives into the operating server? Is this second identical server going to help me at all? I don't even know what is on it. Can I reconfigure the RAID, so it's not using a drive, and then slide in a disk from the crippled server, and copy the data off of it?
I'm having a hard time getting part of Asterisk (the open source PBX) called asterisk-addons to compile with mysql CDR support which I need to enable Realtime I believe. I've spent the whole day trying to fault find this one (including thinking I had ruined my box and creating a new CentOS build!) and am pretty worn outWhen I attempt to install asterisk-addons (I've tried 1.6.0.1, 1.6.0.1-patch and 1.6.1.0-rc3), I get the following line in a ./configure:
checking for mysql_config... /usr/bin/mysql_config checking for mysql_init in -lmysqlclient... no Then when I do a make menuselect, MySQL is not selectable and XXX"d out: [code]....
I have some confusion about mysqladmin and mysql.I am using mysql version Quote:
[root@localhost freepbx-2.7.0]# mysql --version mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1 My MySQL is running Quote: [root@localhost freepbx-2.7.0]# /etc/init.d/mysqld status mysqld (pid 11440) is running...
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
i 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.
Subprocess failed. Error: RPM failed: installing package xen-4.0.0_21091_06-0.1.1.x86_64 needs 27MB on the /boot filesystemI seem not to be able to change the size of the /boot, but 11.2 loads okay but not 11.3There only 19MB left from 66 and I can't make it bigger, I hope there is someone thathas seen this. I would like to see some of the update with XEN.
Today i upgraded my system and started getting error when i update, install or remove a package. The error isn't restricted only to one repository so i thing something is wrong with my system.
In 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.
I upgraded a system from 10.3 to 11.4 and I get the following error when trying to run mysql:
Will update MySQL now, if you encounter any problems, please read following file: /usr/share/doc/packages/mysql-community-server/README.SuSE Log files inconsistency, please merge following files manually: /var/lib/mysql/mysqld.log /var/log/mysqld.log
How can I correct this? Mysql will not start so I can not run any of the utilities.
#!/usr/bin/perl use DBI; my ($db, $user, $pw) = ('dbname', '****', '***********'); my $dbh = DBI->connect("DBI:mysql:$db",$user,$pw) or die "Cannot connect to $db: $DBI::errstr
[code].....
The error message is
[Wed Feb 24 13:03:27 2010] myscript.cgi: DBD::mysql::st execute failed: Column count doesn't match value count at row 1 at myscript.cgi. [Wed Feb 24 13:03:27 2010] myscript.cgi: DBI::db=HASH(0x8a30c60)->errstr
I tried to install php from source file on centos server and i got the error as # ./configure --with-apxs2=/usr/local/packages/apache/bin/apxs --with-mysql --prefix=/usr/local/packages/apache/php --enable-force-cgi-redirect --disable-cgi --with-zlib --with-gettext --with-gdbm
checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.
I've been using Ubuntu since 6.04, not a linux guru by any means but can usually get myself out of trouble.
So, the issue... I installed 8.04 on my mother's laptop some time back as she was having trouble keeping Win 2000 running (she has a low spec no-name generic laptop btw). I live in Autsralia and she in England, i thought i could better support her if she was running Ubuntu... All has been well with 8.04 but with the new LTS release (10.04) i thought i'd talk her through the upgrade... Did the online upgrade via Update Manager, all seemed to go OK but when she went to log on after restart she got an error saying 'authentication failed' even though we are 100% sure we have the user name and password correct... Tried to do a ctrl+alt+F1 to by pass the GUI log on but couldn't get the terminal session to open up, just got a black screen - no command prompt.
So... thought OK re-install... downloaded the ISO, burned and sent her a CD in the post... talked her through the re-install, all seemed to go well (again) - BUT, after restart, couldn't log in "authentication failed" again...
So, remember i'm trying to talk a novice through all this... any thoughts!?!
If i can get her to log in i can then support her via some kind of remote sesion or other screen share... and it wont cost me a small fortune in international calls!!! But if i can't get a log in, i'm dead in the water!?
i am trying to install symantec endpoint on a linux server by this command rpm -ivh sav-1.0.3-8.i386.rpm but it gives me the following error error: unpacking of archive failed on file /opt/Symantec/bin/navdefutil;4ceb8d6b: cpio: mkdir failed - No such file or directory
When I try to run the Online Updates to the system through Yast I get the following errors for each package:
[QUOTE] Subprocess failed. Error: RPM failed: warning: /var/cache/zypp/packages/Packman Repository/Multimedia/i586/libaudcore1-2.4.4-1.pm.1.1.i586.rpm: Header V3 DSA/SHA1 Signature, key ID 9a795806: NOKEY error: db3 error(-30987) from dbcursor->c_get: DB_PAGE_NOTFOUND: Requested page not found error: error(-30987) getting "" records from Requireversion index error: db3 error(-30987) from dbcursor->c_get: DB_PAGE_NOTFOUND: Requested page not found [Code]...
Toward the end of installing Ubuntu 10.10 32bit (Alt CD) on my iMac 11,1, the installer asked me to type in the location for installing the grub boot loader.
I told it to use /dev/sda3 and it immediately failed. I'm still in the installer. Can anyone suggest a solution?
Here are my partitions on sda:
...from the shell in the installer, there is no grub.cfg in /target/boot/grub.
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
In my Ubuntu 10.10, following this tutorial, I don't face step 2. I mean, while installing the packets, I don't face anything related to configuration.Then, when I run a command, such a
Quote:
mysql -u root -p
, I get this error:
Quote:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Package mysql-server is not installed,
