I currently have a database that I would like to be able to update using a web interface and then display on the website. I would like users to be able to update the database by entering one record at a time with around 10 fields of information (drop down menus and text boxes). I am unfortunately using MS SQL for my DB as of right now.
View 1 RepliesI'm not a database guru, so be patient with me: Is there some kind of "wrapper" software you can put around an SQL database (MySQL perhaps) that allows you to internally configure database rules on a higher level than the database itself can actually implement? (E.g., "rows in table A can be deleted, but only if there are no related rows in table B and only if column x for the row in table A is in state y.")The idea would be to keep from having to trust this kind of logic to the client programs, while also avoiding the need to write a full fledged server daemon just for your application. The clients submit their SQL insert requests to the wrapper daemon, and the daemon passes them on to the database if they pass a rules table defined for that particular database.
View 3 Replies View Relatedam 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 RelatedI just had an ATT Uverse RG installed. However my Smoothwall router that previously worked fine with the ADSL SpeedStream is no longer accepting an address assignment DHCP ip address from this new gateway. (3800HGV-B)Any thoughts ideas or experience working with this hardware? ATT only supports Windows and Mac
View 2 Replies View RelatedI have a ppp0 entry with post-up options like this
mapping ppp0
map none photon-plus motorola
map timeout: 12
[code]...
i am using windows 7 in my laptop and linux is installed on virtualBox but my problem is the screen is showing small in virtualbox is there any way to enalarge the screen to show like windows screen? i did before by using VGA setting but it made problem me i was not able to use GUI interface i meant graphics interface
it was just showing me Command Prompt.
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedI recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies View RelatedWhen I do...# iptables -L...I see rules in my INPUT and OUTPUT chains that look scary:ACCEPT all -- anywhere anywhere...but these rules only apply to the loopback interface. I tested it and the server cannot be reached on open ports from the outside world. How can I make iptables show the interfaces that the rules apply to?Otherwise, every time I do iptables -L it will scare the crap out of me.
View 3 Replies View RelatedI found multiple sites explaining how to add IPs to a network interface as virtual interface like eth0:0. However I can add IPs to an interface as well using the ip command: ip a a 192.168.2.2/24 dev eth0 What I want to know is how I can make this persistent on rhel/centos.
View 2 Replies View RelatedI'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.
[code]...
The following are the output of command "ifconfig -a":
[Code]....
The interface "eth0", which is down, was not displayed, but loopback interface has been displayed. So, how can I make my application display all interfaces, including the interfaces which are down, but excluding the loopback interface?
I'm new both to database and database in Ubuntu. I am working on a project in school which students are told to go to a site (html? ftp?), and read a document. I need to record the names of the students who read a document onto a spreadsheet. I was told to look into MySQL and Ubuntu. How can I proceed with this in Ubuntu?
View 1 Replies View RelatedI'm am looking for a visual MySQL Database Designer wher i can draw the Tables and connect them with lines. It should be able to generate the MySQL-Create command for the tables.
View 3 Replies View RelatedI have a strange thing happening when I use the sudo command. I'm getting "Could not connect to database" every time I use the sudo command.I don't have the slightest clueThe sudo command works but it gives this phrase.
View 9 Replies View RelatedI'm looking for a recommendation for an app that will keep details of all my audio CDs. Ideally I'd like it to be able to produce html or xml so that I can check it from anywhere ("Have I got that track?").
View 4 Replies View Relatedubuntu 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
At work we have a Sybase Adaptiver Server 9.0 database running, it has to stay there for now, and we are developing a web application that will connect to it using PHP.I was already able to make it work using ODBC on Windows and using odbc_connect on PHP.But now we are moving to Ubuntu, and we are trying to get it to work on it.I already have Apache2 and PHP5 up and running.There are two ways (I can think of) we can do this, one is using ODBC and then use "odbc_connect" and the other is making "sybase_connect" work on PHP. Being the latter probably the best one since you wouldn't have ODBC as an intermediary.
Either way, as long as it works I'm happy. ODBC would be fine to meet our requirements for now.I already have ODBC Data Source Administrator but no idea how to create/include/add the Sybase driver.We also tried setting freetds up, but that didn't work either, we might be missing something.
When I opened F-spot this morning I got an error message, then it opened a new database - which has nothing in it. Reopening f-spot simply loads the new empty database again. find my old database and get f-spot to use it again? The new database appears to be located in ~/.config/f-spot/photos.db (I'll print out the contents below).
[Code]...
Just upgraded to 10.04, trying to watch a dvd and it doesnt work. so i go to the ubuntu website, download the required pack (ubuntu restriced extras)
And then type in the code:
Code:
when i do this, terminal keeps trying to connect to a database, but it is not able to, see below....
Code:
Im at university and sitting behind a proxy. however, i had no problem doing this with ubuntu 9.10 and i can access internet, update, software centre ect...
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..
I am trying to use Banshee to sync my 5th generation iPod nano on a Lenovo laptop. When I plug the iPod in, it is recognized just fine by Banshee, however when I click on the iPod icon it tells me that it is unable to read the iPod because it has been used with a version of iTunes that saves a version of the database that Banshee can't recognize.
All of this is fine. I click on rebuild iPod database since I have no intention of using iTunes in the future with this iPod, and I don't mind losing the playlists or songs on the iPod (I have them all on the computer). The database rebuilds normally from all appearances, and after a short time I am able to read all songs on the iPod and transfer things back and forth.
The frustration comes into play with the fact that next time I load up the iPod on Banshee, it asks for the exact same process. It is unable to read the iPod, needs to rewrite the database, etc..
Is there some way to permanently alter the database that I'm missing, or is this an issue with 5th generation compatibility?
I have installed bacula which by default installed the mysql backend. Asked me for the root password of mysql but since I couldn't remember I cancelled the configuration. I checked it out afterwards and now I know it but I can't find my way back to the bacula database setup screen once again. I have read that there should be a create_bacula_database script somewhere but I can't find it. Any tips on how to set this up?
View 6 Replies View RelatedWhile watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
View 2 Replies View RelatedI'm looking for a simple to use relational database with a graphical front-end. What are the options on Ubuntu?
For those that know Filemaker, I'm looking for something like that and I'd like not to have to build one in Qt.
Best one I've found so far is Glom, but it's extremely hard to use, anyone know of one better?
View 4 Replies View RelatedI don't have any idea where to place the "mysql-connector-java-3.1.14-bin.jar" file in ubuntu 9.10. Yesterday I did this in xp successfully by placing this jar file at following locations
Javajre1.6.0_06lib
Javajre1.6.0_06libext
Moreover, the jar file which I am using for xp; can be used for ubuntu 9.10 or not. I am using NetbeansIDE 6.7.1 (installed from Software Center), MySQL 5 Server (sudo apt-get install mysql-server) is this enough?
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?
View 8 Replies View RelatedThis may come across as a bit of an isolated and complex problem, but I haven't been able to get my iPod Nano 5th Generation to have any sort of compatibility with any iPod management programs (except with using Nautilus I guess). This includes gtkpod, Banshee and Rhythmbox.With Rythmbox, my iPod shows up in the pane, but I cannot interact in anyway except ejecting it. There aren't any msgbox errors.Banshee cannot read the iTunes database or something and insists that I rebuild the database on the ipod so I can use it with banshee. I did and gained full access to Banshee's iPod management with all the features it carries. I moved my music library on to the ipod but the thing states that I have zero songs whilst banshee states otherwise.
iTunes on my Windows PC will show that I have x number of GB of "other" information after using Banshee to move music. It seems that it is transferring data sufficiently but is not recognising it as "audio" gtkpod wont let me manage the iPod before or after Banshee's tampering.
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].....