Ubuntu Servers :: Setting Up A Database On 10.04?
Aug 19, 2010
I want to set up Ubuntu Server 10.04 on a computer I have lying around, set up a database for storing information, and a website for accessing it, which is only avaliable on my local network (it would just have an IP address on my local network). How would I do something like this?
I want to set it up on probably a Dell, and I want to be able to have multiple fields on the website that people see when they go to that IP address where they can enter information to be recorded in the database, and then be able to easily access it with a login, which different people would have different ones, so they can see just the information they entered..
View 2 Replies
ADVERTISEMENT
Mar 30, 2010
ubuntu 9.10 64 biti try to install XAMPP and i want to create new database by use phpMyAdmin
at MySQL localhost create new database it show No Privileges how to create new database from terminal
View 4 Replies
View Related
May 24, 2010
I want to create a new LDAP database.
Part of the new configuration is
Code:
dn: olcDatabase={1}hdb,cn=config
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {1}hdb
[Code].....
View 2 Replies
View Related
Mar 28, 2011
Had anybody ever tried flashcache [URL] under ubuntu? My idea is to increase the throughput of a small server especially for database operations by using an SSD as cache.
View 3 Replies
View Related
Sep 1, 2011
What is the best way to lock down database server?
via ufw and iptables.
Should I close port 80 on it?
View 9 Replies
View Related
Sep 1, 2011
Looking for suggestions on what tools to use. I'm a finance major with limited programming knowledge. I would like to start collecting my own stock data. I would like to pull data from google finance or something similar. Also, I subscribe to data from AAII, American Asso. of Individual Investors, and would like to add that data into the database. and be able to have a nice gui to run queries on. My interests are finding if there are various different arbitrage opportunities and fundamental value investments.
Very low budget. Want to run it on ubuntu. I was looking at Postgre SQL as the database, but really have no idea what is optimal. Not to sure on the gui or how to pull the data. If anyone is interested in the topic and would like to help me set up and run algorithms let me know too.
View 6 Replies
View Related
Jan 5, 2010
If any real hassle using a database between web sites. Not obviously phpBB but rather various projects that need a common read access to maintain a relation
View 1 Replies
View Related
Jan 16, 2010
I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies
View Related
Apr 8, 2010
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?
View 9 Replies
View Related
Aug 15, 2010
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?
View 2 Replies
View Related
Jan 31, 2011
Im configuring virtual users for ftp and in few guides i find that i need this database.This guides were outdated so i cant follow them(by downloading with its commands), can anyone explain me something about this db(like, where to download, how, did i have installed other version of this db with ubuntu server default packages)...By the way i need to create login file with users and their passwords, for example:tomfoofredbar
Then i must create actual database file like this:
Code:
db_load -T -t hash -f logins.txt /etc/vsftpd_login.db
(that requires the Berkeley db program installed)
View 2 Replies
View Related
May 29, 2011
Please tell me spesification if i want buid mail server on ubuntu 10.04 with good features :
1. For MTA ??
2. For Mail Filtering ??
3. For MDA ??
3. For Webmail ??
4. For Mailling List ??
View 3 Replies
View Related
Jun 5, 2011
Does anybody know if it is possible to hide certain databases from the root user in MySQL?
It may sound stupid, since the root is the root and all that, and it may feel strange but it kind of adds a level of abstraction which I want to give the "root user", and I want to avoid going down the route of creating a new mysql instance on the server.
I had wondered if there is some kind of 'hide' parameter for a database or whether it is possible to change the root username to something else (e.g. 'realroot') and then create a new user 'root' with all the same privileges (except those on the hidden databases).
View 7 Replies
View Related
Jun 10, 2011
i have installed mysql in ubuntu server 10.04 and want to access the database from windows xp.
View 1 Replies
View Related
Jun 14, 2011
I have installed ubuntu 10.04.2 LTS and followd all the steps from the tutorial from [URL], postfix and dovecot works fine ...but ...is there any way to create email accounts (postfix account) without creating linux accounts for each mail account ?
View 4 Replies
View Related
Jan 29, 2010
I'm having trouble ssh tunneling through two servers to get to my database. Server3 is restricted to all except from server2 and I'm at server1. So on server2 i do ssh -L1434:server2:1435 -l user server2 - this works i'm able to connect to the db on server3 from server2. But on server3 i'm trying to ssh -L1433:server2:1434 -l user server2
- and I get 'connection refused'. I tried telnet server2 1434 from server3 and i get 'connnection refused'. I checked the firewall is open on server 2 - firestarter confirms that port 1434 is open to everyone. I'm not sure what I'm doing wrong, but I have a hunch that maybe firestarter on server2 is not working correctly, because it also shows that port 22 is open to everyone and I can telnet server2 22 and I'm able to connect.
View 2 Replies
View Related
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..
View 3 Replies
View Related
Apr 11, 2010
I logged in phpmyadmin as root (with password that I just created in terminal), old databases are there but I have no privileges to create a new one.
View 1 Replies
View Related
Apr 27, 2010
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?
View 2 Replies
View Related
Apr 15, 2011
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
'dbuser'@localhost';
'dbuser'@'%';
'dbuser'@'192.168.1.10';
and between each change of permission, I've flushed privileges.
View 1 Replies
View Related
Jan 3, 2010
I downloaded the ubuntu server (command line only) iso and set up a server on a spare computer. The only partition is ubuntu. LAMP server installed, and runs. Its plugged into my home network and the router assigns it a DMZ. I use ptty and that allows me to connect the server from my Windows PC. I installed samba and that works, I set up the server as Z: to my windows PC, and I can now use Filezilla FTP to move gigs of files over from my windows PC to the ubuntu server. I have to log in to activate the connection to Z: but it works.
Problem is getting a database connection from my windows PC (client) to my ubuntu server. Server is running a MySQL server and an Apache Derby server but both give connection:refused every time I try to connect with a java app, or with ij from my client. I tried MySQL Workbench, as that has a GUI, that doesnt connect to MySQL either. Every time I start my server I have to add lots of jar files to the CLASSPATH just to get the Derby server running. The Derby client connection on my client PC is also properly set up with PATH and CLASSPATH etc etc all configured and tested. But the server refuses every attempt to connect even though it tells you the Derby server is up and runnign as listening on port 1527!!!
What I want is a script or app that will "unlock" my server so I can actually do something with it instead of constantly trying new settings and packages in the vain hope it will then actually 'serve'. I am missing something here. There is nothing of value on this server that cannot be 'exposed' to the internet, so I'd be happy to turn off all the security just so the damn thing allowed connections...!
View 2 Replies
View Related
Sep 1, 2011
I am about to build a server cluster with mysql-cluster and a couple of apache webservers. I have found lots of tutorials regarding the setup of haproxy, but i have the option to get a pretty affordable barracuda load balancer. Now, i am kinda new at this. But my main questions are.. Can the load balancer also serve for the database? Is it a straightforward configuration?
View 1 Replies
View Related
Dec 3, 2009
I have set up a 389 DS server and a kdc. However there is not a howto or any document concerning setting up the DS as a Kerberos database back-end. Nor is there a 389 DS forum, so I am asking here and hopefully some of you could possibly help or throw in some light as to this kind of setup.I have read the 389 DS features page and the Redhat documents but there is no reference to this feature.
View 3 Replies
View Related
Oct 19, 2010
My boss has suggested installing the unixODBC driver in one of our Red Hat 5 servers in order to connect to a Microsoft SQL/SERVER database (Windows server).
View 1 Replies
View Related
Jun 26, 2011
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.
View 1 Replies
View Related
Jul 17, 2009
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.
View 1 Replies
View Related
Mar 14, 2010
Running newaliasespostalias: fatal: open database /etc/aliases.db: Permission deniedin my /etc I do not have a aliases.db only an aliases.I cp aliases aliases.db but when I try and install post fix again it gives me the same error and aliases.db goes away.
View 9 Replies
View Related
Mar 7, 2011
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies
View Related
May 29, 2010
I'm stuck at step 5 of gallery2 install"database setup" I can get mysql started by typing: mysql -u root -p and putting in my password. Then I typed the following. (actually I've typed it a few times and a bunch of different ways)
[Code]...
View 7 Replies
View Related
Jun 17, 2010
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.
View 1 Replies
View Related