Ubuntu Servers :: Store Network Traffic In MySql Database?
Mar 7, 2010
I want to know that how can i store network traffic in MySql Database. What i want to do is identify no of client requests hitting a server throughout the day...I have to store no. of request hitting a server in every 15 mins and insert that into database so that i can obtain a network traffic pattern.
I searched for a tool but cudn't find any that satisfy my requirements..
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 have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
We started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
I am running Ubuntu 9.10 with Apache, phpMyAdmin and MySQL. Normally phpMyAdmin loads properly, but the other day I created a large database of 6,000+ tables and 1.3 GB of data in the entire database. Now phpMyAdmin loads and shows my different databases, but if I try to open the new large database, it just loads a white page with no content. Does anyone know if I can reconfigure my server so it will be able to show parts of the database?
I can not access my MySQL database from any remote host on my home network, I keep getting "Access denied for user 'dbuser'@'192.168.1.10' (using password: YES)"
From what I've read this seems to be a permission problem, I tried
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
How to connect my mysql database server from outside network. because its locally works and i cant able to connect from outside and different networks. when i try i am getting like this error.
ERROR 2003 (HY000): Can't connect to MySQL server on '123.136.126.179' (113)
i'm new to MySQL and i designed a database using MySQL and PHP recently but dont know how to port it to my host company. How do i save the database on my flash drive then transfer to my host on my website's control panel.
how to implement a password login system that both sends passwords over the internet in an encrypted form (so my users don't get that annoying message saying "this web site is about to send your password in an unsafe form..." and stores its user data in a MySQL database? This seems to need a combination of mod_auth_digest and mod_auth_mysql.
i'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 have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
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 adding inventory control to our online store here at work and I'm not sure of the best approach.Let's say Customer A and Customer B are both looking at the product page for Product X at the same time, and there is only 1 left in stock. What should happen if both click "add to cart" at (more or less) the same time?hould the last Product X get put "on hold" for one of the customers, and then decremented once the sale is complete? Or should the database decrement the product count, and then increment it if the sale doesn't go through successfully?Is it still possible for both to add it to their cart? Are there any mysql features I can use to ensure both cannot purchase the last product?
I had a problem with my ubuntu installation, but I don't want to get into that...The OS wouldn't load...Now, that I have a ubuntu partition mounted on a live cd, is there a way I can access or backup my database without booting the system? I'm pretty sure the database is stored somewhere, but how can I find it and back it up?
When looking for MySQL GUI, I find many applications which provide a frontend to database management.I am looking for a GUI for database entry, rather than database management, approximating Glom or VFront, but Glom is buggy (and development sluggish) and VFront difficult to get set up.Ideally, I would have my own private (GTK, say) data entry tool, which would look much like an HTML form, with labelled fields for the MySQL columns, Previous/Next buttons, saving the current row and moving you up/down to the next one, radio buttons or drop-down menus for columns with limited entries, etc.Of course, [Tab]-navigation and keyboard shortcuts [Ctrl]+[C], etc., should work as well. (Yes, that is very annoying about Glom, for example.)
Iam always working from 1 machine to another even with my laptop which i dont place all my data some of which in some machine, iam always constantly saving all my files specially my MYSQL database files which have grown in size, Is there a ways I can just copy & paste my MYSQL database? like in MSACCESS.
i have two machines at home running ubuntu linux and windows connected by lan. on ubuntu machine i have mysql installed, how do i go about accessing ubuntu mysql database on my windows machine.
My existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives. How should I install my MySQL database to the new version? Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?
Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
I recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.