At the moment I am having a problem with the MySQL server on my VPS. It's a completely fresh install of both Debian 5 and MySQL but the problem is upon logging in I get:
[root@boris ~]#mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[code]....
Hey guys. I have a client computer PXE booting from my host computer and it is supposed to give the client the ip address 172.16.0.100 however instead it gives it the ip address 172.16.0.208.
I have this set up working with two other computers and there is no noticeable difference other than mac addresses for the network card.
Here is an extract from my '/etc/dhcp3/dhcpd.conf' file...
ddns-update-style-none;
option domain-name "example.org";
default-lease-time 600;
max-lease-time 7200;
[Code]....
I have quadruple checked the mac address of the client and it is definitely "00:07:E9:32:16:81" so why is it not giving it the IP address that I have specified?
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
Since upgrading from Wheezy to Jessie I have not been able to start the MySQL-server. When I do a "systemctl start mysql" I get the following answer on the console:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
Entering 'systemctl status mysql.service' the answer is:
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Don 2015-06-18 18:35:41 CEST; 4min 1s ago
Process: 11272 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
syslog and hostname.err don't show any pertinent messages.
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]...
Target F12 mysql - 5.1.42-2
Source FC 5 mysql - 5.0.27-1
I've put SElinux into permissive mode as it was practically denying anything that moved. Both installed from the standard repos. I used mysql-administrator to create a backup of the FC5 server (all databases/tables) and transferred it to the new system. I restored it onto that machine and double checked that my standard admin user (full privs) was present and let me log in to make changes. All good so far.
So I copied over my files from my sites, point a browser at them and I get nothing, not even errors. Now it's a long while since I set the original up and have probably forgotten something simple but despite making the error output more verbose I can't seem to track anything down other than:
[Code]....
So it suggests my tables are invalid/trashed but I can't seem to figure out why. The original server is still running happily so I'm not in any rush to fix this, I'll keep plodding, Phpinfo reveals a normal operational php setup, so i think that side of the sites is functional. Apache test pages work on blank virtual hosts but viewing my sites reveals the favicon working fine but otherwise comepletely blank pages (zero output, even source). I tried running the page as a raw CLI input to the php package using php index.php and php returned nothing, logged nothing unusual but sat with my CPU at 100%, unsure if that is related.
I have recently installed centos 5.6an app i have needs to run php 5.3 so i upgraded by adding a repo and using yum install php53*a php -v gives me this.PHP 5.3.3 (cli) (built: Mar 30 2011 13:51:41) Copyright (c) 1997-2010 The PHP GroupZend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologiesi also need mysql 5.1 so i picked a repo that had the 5.1 version of mysql in it and um install mysql*which gives me this.[root@localhost var]# mysql -Vmysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (i686) using readline 5.1and then tri to run my app and it failsthe only difference i see between the server that is current working and the new one is in the phpinfo file.in the mysql section of the working one it says Client API version. 5.1.xin the new server install it says the following which is still point to the client api or 5.0
mysql
MySQL Supportenabled
Active Persistent Links 0
[code]....
Today I was trying to upgrade mysql and php.PhP went well, thats at the latest version, but the mysql went to 5.5x from REMI. This killed all my websites, no DB and worse.Well I typed the wrong this (totally my fault - serious EPIC FAIL)i typed yum remove mysql not downgrade...This removed plesk and a load of other stuff, and now im screwed.
View 1 Replies View RelatedI am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.
I've just made the switch from Ubuntu to Debian Squeeze and am having trouble connecting external media (be it a USB stick or an ext HD). The error I am getting when I connect anything via usb is the following:
Error mounting: mount exited with exit code 1: helper failed with: mount: wrong fs type, bad option, bad superblock on /dev/sdc1, missing codepage or helper program, or other error.
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.
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
After installing postfix on my server , all emails sent by a PHP class that i built , are received to spam folder , no matter what i do .am not an expert , except in PHP , the class i built works fine everywhere else except on this server , so i think the problem might be from the server it self ?some told me wrong configuration/software on my server , others told me wrong DNS stuff . actually i don't understand the DNS stuff , and am not an expert in linux softwares and services but i cann install/configure them , so could anyone please check the DNS for problems ?
View 3 Replies View RelatedI just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
I tryed to install a DNS server on debian lenny, i installed bind9 and webmin, and then i installed a bind module for webmin. I created a domain with webmin but when i tryed to add a address record with it i had a Error-Missing Content-Type Header.
View 1 Replies View RelatedWe've just installed debian xfce lxde....after all this time to get it....when we boot up to the login screen it keeps saying wrong uder name or password
View 7 Replies View RelatedWe have Ubuntu 8.04 running on our mail server and remote smtp connection does not work.
When trying to send with a client such as Thunderbird it complains about a wrong usernamepassword.
Receiving mail with IMAP and POP3 works fine through Thunderbird. Both receiving and sending mail through a web interface(horde) works.
I can remotely telnet the server at port 25 and this is the output of ehlo:
Code:
250-**server address**
250-PIPELINING
250-SIZE 25000000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN
code....
I recently installed another Linux distro, Kali Linux, alongside my Debian 8 and discovered to my chagrin that my computer boots to Kali's grub rather than to the Debian grub. I had spent some time customizing Debian's grub and would hate to see that effort go to waste. Is there a way I can get my computer to boot to Debian's grub instead? I tried deleting Kali's boot partition with gparted but that did not seem to do anything.
View 14 Replies View RelatedToday I fresh installed the latest stable version of debian (jessie) with gnome from the USB DVD image for a 64bit machine. Everything got fine except the graphic driver, I think.
Now Gnome 3 is running but graphic is super slow. My previous debian/gnome 3 ran much better and I think there is a problem with the graphic driver.
I'm on an thinkpad t61.
Processor: Intel Core2 Duo CPU T7500 @ 2.20GHz × 2
Ram: 4GB
Graphic: VGA compatible controller: Intel Corporation Mobile GM965/GL960 Integrated Graphics Controller (primary) (rev 0c)
Now the graphic is: Gallium 0.4 on llvmpipe (LLVM 3.5, 128 bits) which is likely wrong. If I'm not mistaken llvmpipe is pure slow software acceleration.
Moreover this was different on my previous debian (wheezy), which was faster. Anyway I don't know what " Gallium 0.4 on llvmpipe (LLVM 3.5, 128 bits) " is and it was for sure different in wheezy.
According to apt-get I have the latest intel graphic divers installed. So maybe this an X-org confic problem?
A couple of days ago I asked why my pc changes the wireless card name.It switches between AR9285 ( right) and AR5008 ( wrong). Well, it is not the case. When system identified with AR9285,it loads ath9k and I can connect to the router. When system identifies my card as AR5008, no kernel module is present at all ( lspci -k). The wrong card name occurs only when system rebooted. If I gracefully shut down the system, it always comes up with a right name for the card( AR9285). So, how to force the system identify my card right no matter if I reboot or shut down?
View 1 Replies View RelatedI've been working on the setup of a FTP server on my Debian system for the whole afternoon. But I can't get it straight! Normally I get it working in just a second, but it's been a while I guess.
I installed only proftpd-basic and it's default dependencies. Should be enough right?
My configuration files are as follows:
I created the user zeitgeist, gave it a password, group and a homedir. Group of the user is nogroup and the homedir is correct with the 755 permission. My port 21 for FTP is open I tested it with nmap -p 21 [ip-address].
My Filezilla client tells me that at first he is connecting, then the connection is established, And then the connection is closed by server.
Using Debian 5.0 Stable, with all current updates, if I type \192.168.0.249 I get samba access and can use all the shared files ok.if I go via the network the computer should be called \squ-eee-zeboxserver but instead comes up as \SQU-EEE-ZEBOXSERsqu-eee-zeboxserver which when clicked gives the attached error.
View 11 Replies View RelatedRunning natios server in Debian 8? I cannot start nagios3 demon, it got following error:
Error: Check period '24x7' specified for service 'check ssh connection' on host 'testk2' is not defined anywhere!
Error: Notification period '24x7' specified for service 'check ssh connection' on host 'testk2' is not defined anywhere!
But if I commented following statement in generic-service_nagios2.cfg, it works just fine.
# check_period 24x7
# notification_period 24x7
i'm facing an error 500 internal error and i don't know where to start .... How can i get information about the error in order to fix it ???at /var/log/apache2/error.log i can't find anythingi have virtualmin installed , i searched at/var/log/virtualmin/domainname_error_log but nothing .... where is apache supposed to keep log for 500 errors ?
View 1 Replies View Relatedi try to install mysql-server how do i create a password for it
yum install mysql mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.optus.net
* updates: mirror.optus.net
[Code]...
Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
100527 18:26:49 [ERROR] Aborting
100527 18:26:49 [Note] /usr/local/libexec/mysqld: Shutdown complete
Installation of system tables failed!
I've got a strage problem with openssh-server on debian lenny. I've done setup of sshd and basically everything works fine. I can check the fingerprint of the ssh-keys on the server and it matches with the fingerprint shown on the client for the first connection. so the key is stored in the known-hosts-file on the client.
The problem occurs after a "connection reset by peer" (i guess when the connected client goes to sleep or a timeout occures)!
After such a reset, when I try to connect to the server, the banner "WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!" appears and the shown fingerprint of the server-key is totally wrong (it differs from the one on the server, BUT it is everytime when this problem occurs the same fingerprint). If I nevertheless remove the correct key from the known-host-file and accept the new key, I still can't login (permission denied).
To fix this situation temporarily I just need to restart the networking on the server. After the network-restart I get (again) the correct fingerprint of the server-key and can login without problems. Until the next connection reset.
Installed 6.01a from DVD 1 on a system with 4GB ram. Installer installed amd64 version by default. When I try to install amd64.deb files I get "wrong architecture" error messages from the package manager.
root@Laptop-RalphDeb:/home/ralphq# uname -r
2.6.32-5-amd64
root@Laptop-RalphDeb:/home/ralphq# uname -p
unknown
Why I can install amd64 programs and why I get unknown for the uname -p command?
for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.
View 13 Replies View Related
