I've just made my old, dusty computer into an Ubuntu Server. So far, i have installed a well functioned LAMP server, to host my Website. I have also installed a FTP-Server (proftpd) and i was wondering if i could manage my FTP accounts in MySQL so i could make an account creation page for it? If yes, how?
View 2 RepliesI'm in the middle of moving my lab to a new server in the middle of the school year.. and need to copy all the user accounts to the new box, hopefully with all the student's passwords and contents of their folders intact.And since we are using the system daily, I need to do it all in an hour or 2.I'm thinking I can just
1. diff /etc/passwd and /etc/shadow from the old the new
2. copy all the student folders to new /home
3. write a script to set the permissions on all the new /home folders to match the user names.
It seems easy and safe so long as I back up the 2 existing files..Any reason not to try? Or is there an easier way?
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.
With the new realease of Ubuntu 10.04 LTS, I was wondering if there was going to be a package for installing Mysql Cluster Server 7.1
If not does anyone know of a good walkthrough for compiling and installing it in Ubuntu 10.04 LTS?
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
I have a xubuntu mysql server, and my winxp machine is unable to connect to the sql server using mysql ODBC.
View 2 Replies View RelatedI've looked everywhere for this (simple) problem, and I can't get this working. I have a mysql server on my LAN which is accessible from within the server.I want to access the mysql server from another computer on the LAN, but it never works.
View 7 Replies View Relatedwhenever i try to connect with phpmyadmin igot this error "#2002 Cannot log in to the MySQL server".how to recover this error?
View 6 Replies View Relatedi'm trying to install mysql-server on my pc. so i type this on my terminal:
Code:
sudo apt-get install mysql-server
it starts to download & install everything, but when it has to configure the server, it simply "freeze" and does nothing!
how can i solve that? i've tried to purge and reinstall, but it was no use!
So recently my MySQL server doesn't startup when Ubuntu boots (it used to) and therefore causes database errors with my Web applications. How do I add MySQL to the run at startup list?
View 1 Replies View RelatedI've been tried to be system admin, programmer, network admin, or network engineer. So, I've been studying this and that... what so ever struggling to find my talent. Back in 2007-2008, I was MS server admin/comm tech. I saw a building running MS server for user computers and Red Hat 9 as a main system server. MS sever was a just one of the user accounts of Linux server. When I log in to Linux, I could see log menu to access MS server. How could somebody make this creative thing?I'm now a Network engineer because working with CISCO router and switch is easier than working as programmer or server admin. I've studied Oracle 10 and VMWARE also but there are ceasless stuffs that I need to study... For now, in regards of my limited brain power, network engineer is proper for me.
View 1 Replies View RelatedI recently installed an Ubuntu 10.04LTS server. I have zabbix-server on that machine, and I noticed that after reboot it won't start. Probabily, the mix of upstart and old init.d scripts result in zabbix starting when mysql is not active yet, in fact in zabbix-server.log I see it cannot reach db. How can I make sure zabbix-server waits for mysql?
View 9 Replies View RelatedI'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
How do i configure the system and user accounts so that the users can't access each others directories, delete system files, install packages etc.I know i am probably going to need tools like chmod mkdir useradd.But i can't figure out how.If you know a good tutorial, please point me in that direction.
View 3 Replies View RelatedSo, I have a website that is hosted at Godaddy and I've set up a database with the ability to access it remotely. I was wondering if there is an easy way to set up an automated back-up of said database at Godaddy, to my local server.
View 2 Replies View RelatedBeen trying to upgrade home server for several days and it keeps hanging on the mysql upgrade. Here's the what apt-get says code....
View 3 Replies View RelatedI 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]...
I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
View 9 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.
A week or so ago I ran an aptitude safe-upgrade and while it was updating mysql I suffered a power-failure. Now, this never really happens in Holland but of course this once it happened at the worst possible time.
I've tried a lot of different things to get mysql working again, but am running into all kinds of problems. First mysql won't shut off properly (it does startup with the computer but I can't connect to it at all) during an aptitude purge. If I kill the process mysql seems to purge properly, but I guess this is not the case because I wasn't able to install it then.
Things seem to have gone a bit more smoothly this time, however:
Code:
snek@snek-server:~$ sudo aptitude install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
[Code].....
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies View RelatedI 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)
I like to run a mySql database server on a Ubuntu (which is no server) for local use only. Is there some instruction how to do this? I downloaded several DBMS but they all seem to assume a running server.
View 1 Replies View Relatedi want connect ubuntu server to windows and retrive mysql from windows
View 8 Replies View Relatedi'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
i'm looking for a way to set up my Bukkit server (Minecraft) with a mysql server on Ubuntu 10.04LTS
View 1 Replies View RelatedAfter the upgrade from 8.10 to 9.04, all was well. But after the upgrade from 9.04 to 9.10, I lost the MySQL server. Now, I recall during the upgrade, I was asked if I wanted to keep the existing my.cnf file or replace it with a newer one. I did as suggested and kept the original as I had edited it before. The same question was asked with a couple other config files. I kept the original in each case. After the first step, I checked the server was running and the websites were up, all was well. After the update to 9.10, when I checked the server, I get the following error:
Code: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Can anyone point me in the right direction to getting this resolved?
Im getting this error when i try to run mysql from a shell
Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket
I have installed MySQL over yum on fedora.
but the path and file /var/lib/mysql/mysql.sock does not exist on my system?
I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:
Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server
[code].....
We have 2 servers, 1 is the webserver and the other is the Mysql server.
When transfering a 2GB file from the webserver to the Mysql server.
The webserver's connection to the mysql DB server dies completely.
Need to restart the MYSQL process in order for it to come back online.
During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.