Ubuntu Servers :: Share Database Tables Between Projects?
Jan 5, 2010If 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
ADVERTISEMENT
Fedora :: Create A Database And Tables?
Jan 13, 2011I am trying to create a database and tables. Does anyone know a reference website that can help me with this or does anyone know how to do this?
View 3 Replies View RelatedGeneral :: Copying Tables From One Database To Another In Oracle?
Apr 8, 2011translationables,i.e,camp_generic_transcamp_generic_trans_defcamp_generic_trans_epcthese tables exist in cntr1/cntr1@camABC1I have to copy these tables from here to staging environment.I need to first check if any of the tables exist in staging.If yes,then delete and create new.There are 4 staging env from 5 to 8.I have to pass the staging environment as parameter to ask the user which environment does he want the tables to be copied
View 1 Replies View RelatedServer :: How To Import Database And Its Tables To Rhel4 Inorder To Working Website Properly
May 31, 2011I have created a website in php.wamp server is used to run the site.i created the database in phpmyadmin using mysql.These all were done in windowsXP.Now I want to import it into redhat linux system.how can I import database and its tables to rhel4 inorder to working the website properly
View 7 Replies View RelatedFedora Servers :: IP Tables Drop Not Working?
May 5, 2011I've been googling this for a while now, and trying different examples, like:
iptables -A INPUT -s 3.2.1.0 -j DROP
iptables -A INPUT -s 3.2.1.0/24 -j DROP
service iptables restart
[code]....
General :: Getting 2 Computers To Share Same Database?
Mar 11, 2010I would like 2 computers (same network) to use the same SQL database. How should I start?
View 2 Replies View RelatedUbuntu Servers :: Su As Backup User Inside Of Bash Script - Lock And Flush Tables On A Mysql Db
Jan 23, 2010I am attempting to write a backup script that will do the following:
1) lock and flush tables on a mysql db
2) dump the db to a file
3) unlock the tables
4) rsync the file to offsite storage
It all seems to be going well. However, obviously I don't want to setup ssh to the storage server on another network as the root user without a password. so I am attempting to su as the backup user inside of the script but when I try to run the script everything happens as it should until I try to so.. then it jumps out of the script .. akss me to login as the backup user.. proceeds to rsync to the offsite storage it does all this and then resumes execiting the script. it is not going to be setup as a cron job. it will be executed manually. assuming that is the case, how can I get the script to run without prompting for a password?
Here is what I've come up with so far... assuming that the script is run as root and the identity of the backup user will need to be assumed inside the script without perstering the user to enter the backup user's password.
[Code]....
Ubuntu Servers :: How To Create New Database
Mar 30, 2010ubuntu 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
Ubuntu Servers :: Setting Up A Database On 10.04?
Aug 19, 2010I 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..
Ubuntu Servers :: Create New Database In OpenLDAP?
May 24, 2010I 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].....
Ubuntu Servers :: Using SSD As Cache For Database Operations
Mar 28, 2011Had 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 RelatedUbuntu Servers :: Best Way To Lock Down Database Server?
Sep 1, 2011What is the best way to lock down database server?
via ufw and iptables.
Should I close port 80 on it?
Ubuntu Servers :: Trying To Build Own Stock Database
Sep 1, 2011Looking 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.
Ubuntu Servers :: How To Clear Postgresql Database Cache
Jan 16, 2010I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View RelatedUbuntu Servers :: MySql Database Wont Start?
Apr 8, 2010I 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 RelatedUbuntu Servers :: Unable To Access Mysql Database?
Aug 15, 2010We 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?
Ubuntu Servers :: Berkeley Db Database For Virtual Users?
Jan 31, 2011Im 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)
Ubuntu Servers :: Mailserver With Data Store On Database?
May 29, 2011Please 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 ??
Ubuntu Servers :: Hide A Database From The Root User?
Jun 5, 2011Does 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).
Ubuntu Servers :: Mysql Sharing Database To Windows Xp?
Jun 10, 2011i have installed mysql in ubuntu server 10.04 and want to access the database from windows xp.
View 1 Replies View RelatedUbuntu Servers :: How To Postfix And Email Users Database
Jun 14, 2011I 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 RelatedGeneral :: Ssh Tunneling Through Two Servers To Get To Database
Jan 29, 2010I'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.
Ubuntu Servers :: Store Network Traffic In MySql Database?
Mar 7, 2010I 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..
Ubuntu Servers :: Root Has No Privileges To Create Database In Phpmyadmin?
Apr 11, 2010I 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 RelatedUbuntu Servers :: PhpMyAdmin Not Loading Large Mysql Database?
Apr 27, 2010I 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 RelatedUbuntu Servers :: Cannot Access MySQL Database From Any Remote Host
Apr 15, 2011I 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.
Ubuntu Servers :: Database Connection From Windows PC (client) Refused Every Time
Jan 3, 2010I 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...!
Ubuntu Servers :: Haproxy Or Barracuda For Load Balancing - Also Serve For The Database?
Sep 1, 2011I 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 RelatedFedora Servers :: Set Up 389 DS Server As Kerberos V Principal Database
Dec 3, 2009I 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 RelatedRed Hat :: Servers In Order To Connect To A Microsoft SQL/SERVER Database?
Oct 19, 2010My 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