Ubuntu Servers :: Build Form On MySQL To Set Values
Sep 11, 2010
Is there a way to build a form so an admin can enter and add values to a database:
Example
Code:
use squid
insert into passwd values('testuser','test',1,'Test User','for testing purpose');
Is there a free software or an easy to configure script?
View 6 Replies
ADVERTISEMENT
Feb 14, 2011
I need a dev setup which is external to the box I work on at home. I.e. I need to build some form of PC capable of running basic dev tools / scm.Given its very basic needs, was thinking of finding a fanless, probably atom based, micro-itx solution. I.e. small, silent, can just sit somewhere all day with a nightly backup to a NAS. (it would be really cool then as well because I can throw it in a bag and take it places when I need to -- its wrong I get excited about that...).Just wandering if anyone has done anything similar?lightly worried about the performanceWas thinking something like the Shuttle XS35GT:but have a gut feeling I could build something better for 2/3's the price.
Friend suggested buying a simple netbook as its probably one of the cheaper ways to getting an atom powered system, and has a screen for setup. ll it needs to run is a web server, SVN/GIT, Trac, maven, hudson and artifactory. I.e. it does not need to be capable of streaming video content etc (i.e. its not a media box) for 1 user at a time. Projects are not going to be the smallest for home projects, but really in the grand scheme of things its going to be small.
View 3 Replies
View Related
Feb 9, 2010
I want to insert values into a MySql database. The following line works fine:1
Code:
mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')");
but if the data to be inserted is from a string... like....
Code:
string NewTitle = "Monaco";
string NumofShows = "2";
How do i edit my sql statements so variables can be inserted into the Values ( ) , and it will be able to read the variables and then store it into the database.
View 4 Replies
View Related
Mar 22, 2011
I am learning PHP to take information submitted in a web-form and store it in a MySQL database, but I also need it to automatically print to the laser printer I have setup. So that a notice or printout is produced of the information.
My question is... what route do I go to automate printing from web-based information in a PHP/MySQL database?
Is it PERL ? or does PHP have a feature to do this?
View 2 Replies
View Related
Dec 1, 2008
I am writing a script to mine data from my game server logs which are going to mysql. My first question is syslog-ng is sticking $msg into one colum it self, $msg tends to be a long string here are a few examples:
cn name team frag death flags role host.
0 Maik CLA 2 0 0 normal *.70.233.118.
1 lizardncd RVSF -1 3 0 normal
[*.22.247.40] lizardncd fragged Maik.
And they are not always in the same format, How could I parse this data to do something useful, like creating a user stats page with frag counts and flag counts. Should I create a script that runs in a cronjob that parses this data to a new table maybe once a day. Even then the $msg string value is random and I am thinking in terms of awk.
Second. I would like to keep track of what ip's are using what nicknames. Kinda in the sense of and ip associated to a array of names that have been used on that ip address so I can keep track of users. How would this work logically with a mysql db, could a column allow multiple values, then loadable into an array, which then can add, remove, and store to mysql.
View 1 Replies
View Related
Feb 17, 2011
I have several forms created on my server. I'm running Ubuntu server 10.04.
I was running Ubuntu server 10.10 up until Tuesday Night. I decided to go to Ubuntu Server 10.04 in favor of the long term support of it.
While running Ubuntu server 10.10 all my forms worked and would send the form data to my email without issue.
Now after transfer the site to Ubuntu 10.04 I'm not getting any of the email messages. I have verified my email works by sending a test email directly to the account.
View 5 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
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Jun 10, 2010
I've already tried Seamonkey to create a web page but can find no way to create a web form in which I want to create form fields. Before moving to Ubuntu I used Microsoft FrontPage to create web pages with form fields. This was easy to do. what is available to do the same in Ubuntu?
View 2 Replies
View Related
Jan 16, 2011
i want to start a home server in which i can log on to the same account form 2 or three different machines running ubuntu server. is it possible and if so, how?
View 9 Replies
View Related
Nov 9, 2010
I'm trying to build a server using the SME distro and MySQL. Following the tutorials for MySQL, I need to have certain software installed. How do I know what programs I have installed?
View 3 Replies
View Related
Jul 28, 2010
Code:
./schema_editor_fe.cpp:116: error: 'Gtk::EntryIconPosition' has not been declared
./schema_editor_fe.cpp: In constructor 'SchemaEditor::SchemaEditor(grt::Module*, bec::GRTManager*, const grt::BaseListRef&)':
./schema_editor_fe.cpp:73: error: 'class Gtk::Entry' has no member named 'set_icon_from_pixbuf'
[code].....
View 1 Replies
View Related
Nov 24, 2010
I am running Ubuntu 10.04LTS on a server. I am trying to make an e-mail contact form. When I hit submit, it says the message was sent. I check my e-mail and I don't see it. Does it not work with gmail? or do I need to use a system username@mydomain.net? This is the PHP mailer.
Code:
<?php
if(isset($_POST['submit'])) {
$to = "myemail@mydomain"; #This is set to my gmail.com e-mail.
$subject = "Unserv Form";
$name_field = $_POST['name'];
$email_field = $_POST['email'];
$message = $_POST['message'];
$body = "From: $name_field
E-Mail: $email_field
Message:
$message";
echo "Message was sent!";
mail($to, $subject, $body);
} else {
echo "Error, it did not work! Please mention this to admin@unserv.net!";
} ?>
This is a snip of HTML from the contact site:
Code:
<form method="POST" action="sndmsg.php">
Name: <input type="text" name="name" size="19"><br>
<br>
E-Mail: <input type="text" name="email" size="19"><br>
<br>
Message:<br><textarea rows="20" name="message" cols="50">
View 6 Replies
View Related
Dec 1, 2010
I have a server 192.168.1.14 (I will call it 14) it runs Ubuntu server 10.04 and I have my Ubuntu Laptop 192.168.1.3 ( I will call it 3) that runs Ubuntu 10.10. I need to find a way to add users from my Laptop (user X) or a Windows machine user (Y). What I am trying to accomplish is to have file permissions some for Y only and some for X only and some for a group that contains X and Y. Now I have a Dir, on the server 14, with the owner Z (server user) and I gave it permission 760. Now my user X, from Laptop 3, (they have the same name in real life) is not able to access those files on a NFS share.
I would like to have the 760 perm and be able to access those files without doing a 777. I am thinking to add all users (XYZ)to a group and give read permissions for the group. My dilemma comes when the users are on different machines. I already created equal users on server with the same name but it does not do the trick. When connecting to server from 3 I can't access files that are owner by the group where user Z belongs (even if user X has the same name and password). I am thinking there has to be a deeper way of identifying users.
View 1 Replies
View Related
Mar 6, 2010
I am currently running MySQL on my workstation under RHEL5 and would like an open community version of their Workbench. Is there an RPM binaries available? and/or can someone provide some direction on building from their source?
View 6 Replies
View Related
May 10, 2011
I have Ubuntu server 11.04 (LAMP, SAMBA) installed with the ubuntu-desktop interface (I am not yet experienced enough to run without it).My problem is I am trying to share the www directory through samba so I can edit the site, but no matter what I do I get errors when I try and access the directory form the other machine.I did add it to the smb.conf file, and it does show up fine on teh network, however, when I try and open or change the contents of the directory it says I am unauthorized.I tried:
Code:
sudo chown <sambausername> /var/www
even tried
[code]....
View 6 Replies
View Related
May 7, 2009
home web server (running on port 21333). i'm running fedora 10 w/ LAMP and I can't get my php contact form on my website to send out mail. it looks like it sends but it doesn't (and I know the form works because it's the same one from my hosted web server). I've tried everything I can think of, disabled selinux, added apache to trusted mail users, changed the port to 2025 in case comcast blocks 25 (at least i think i did), added the port to the iptables and i have no idea where to go from here.
View 4 Replies
View Related
Aug 13, 2010
We are using several printers on our Linux RH network to print customer invoices and receipts. Receipts are short forms of just 21 or 22 lines. Two of the printers (an HP LJ1300 and a Dell 5200) eject the receipt paper automatically; the other two HP (a LJ 4200 and a LJ2420) do not eject. You have to press the green button on the printer. Is there a solution to that? They are all set up with the same PCL settings.
View 3 Replies
View Related
Mar 3, 2011
I'm successfully hosting an https site on my single available public facing IP address - but I want to expose a couple of internal web sites. Essentially, I have:[URL]..I get most of the way there by using mod_proxy and the directive:
[Code]...
View 1 Replies
View Related
Apr 28, 2010
I'm trying to build a Fedora 12 cluster to run DHCP on top of two servers using pacemaker and drbd. The pacemaker runs great but i'm having the hardest time getting DRBD installed.
My kernel version is 2.6.32.11-99.fc12.i686.PAE First i tried to [root@dhcp-primary drbd]#yum install drbd this doesn't give me everything because apparently the kernel module for DRBD must be built from source. so i unpacked drbd-8.3.6.tar.gz and tried :
[Code]...
I'm not very experienced in compiling from source i'd love to make an rpm for this but after scouring the web and trying different install methods, I am still at a loss.
View 2 Replies
View Related
May 4, 2010
I have a Godaddy UCC (Multiple domain) certificate for the following domains:
example.com
upload1-example.com
upload2-example.com
The rsa was generated from example.com server using example.com as CN Common name.
GoDaddy's website adds the extra names to a CSR you provide, does the checks and grants the cert.
My problem is that whilst the certificate works fine on the server example.com (from which the csr was created), it comes up with two errors when restarting apache on remote servers.
1>> Certificate common name does not match server name
2>> SSL Library error - check private key:key missmatch.
I donn't understand how these keys could ever work as no reference to the private keys of the remote servers is ever used in creating the UCC certificate.
View 4 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Mar 19, 2010
I started building my server with the following goals:Quiet - it will live in a cabinet in my living room, so it should be as quiet as possible Low power consumption - not just to keep the heat (ergo cooling demands, ergo noise) down, but also to save money since it will be on 24/7 High reliability Support for 8 IDE and 2 SATA drives. (Toward this end, I have two 2-port IDE PCI controller cards and one 2-port SATA IDE controller card.) Spend as little as possible. (Money is VERY tight for me right now.)
I started with a mini-itx board I had lying around. It's fanless, with a Via Epia 700MHz CPU in it. A little anemic, but it draws very little power and is dead silent. The problem with this board is that it has 2 IDE ports on board, no SATA ports, and only one PCI slot, so I have to choose between my SATA card and my IDE card. I need - but can't have - both. I tried buying a 2-slot PCI riser card, but apparently it's incompatible (or DOA) - none of my PCI cards work when connected via this riser card. I've looked for PCI cards that have 2 x IDE + 2 x SATA ports, but anything that fits that bill is very expensive.
Now I'm thinking new motherboard & CPU - preferably something older that can be had cheaply on ebay. If it uses DDR memory (rather than DDR2), I can use the RAM I have, which saves me $25. A newer Atom-based board would be OK, but they all seem to have one PCI slot -- and not enough IDE/SATA ports to get the job done with just one PCI slot. If you can recommend a motherboard that meets all the criteria above, please post it. (Or, if you have any other ideas for handling this very cheaply, let's hear it!)
View 9 Replies
View Related
Jul 7, 2010
I just built a new Intel i7 box with a DP55KG motherboard and soft RAID1. I installed AMP, ssh, and a few other apps. It is running 64-bit Ubuntu Server 10.04LTS. The box is really chewing on the RAM. is it the 64-bit talking?
View 2 Replies
View Related
Feb 13, 2010
Am trying to build a main frame computer, in order to learn more about them.
View 9 Replies
View Related
Jul 1, 2011
I am looking for the best/cheapest way to build a ubuntu server with 8tb of storage hanging off of it.
I don't feel it needs to be hardware raid, so more software raiding swap in and out failed disk drives.
The server itself normal duo core CPU with 2Gb of memory and i would like to have the internal drive of the O/S only.
View 8 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
Dec 9, 2010
I build a LAMP server behind a router. The current situation is:
1.I could access index.html of apache within the LAN.
2.I could access the vsftp outside of the LAN.
3.I could access the ssh outside of the LAN.
I have configured my router to do reflections(although I don't know it's correct or not.). I think the LAMP works good since I could use it inside the LAN. The configuration of the router is at least partly right because ssh and vsftp work fine(I test by browsing the ip:74.***.***.*** in the lan, not 192.168.1.8 --this also works. ).
I cannot access web service outside the LAN. And the error message is "Oops! Google Chrome could not connect to 74. Did I miss some configuration of router?Apache2?Ubuntu? I use the ubuntu server 2010.10 version.
View 3 Replies
View Related
Dec 2, 2010
This is what im trying to do with the NAS, i would like it to stream movies 720 and 1080 to my Samsungs tvs, this may require trans coding(i think that the word), storage wise i would like to start with 2 2tb hardrives(The energy ones), i don't know if i need a raid(5) card for what i need if so, whats a good one ?
I would like to save as much power as possible.
Motherboard ?
CPU = maybe an I3
RAM = 2g DDR3
Power-supply = ?
OS = FreeNas
Also i have read a lot of places were you can do a automatic bit-torrent clients to downloads show and unrar them for you and maybe organize them in to separate folder, but my question is can i do this with megashare and Hotfile (premium) links ?
View 9 Replies
View Related
Dec 12, 2010
I am a total noob in the process of trying to build my own server. I installed Ubuntu 10.10 but when I did that I didn't have the computer hooked up with an ethernet or have any internet connection. During the installation process it was unable to set up DHCP, so I figured I would just do that later, somehow.
Anyways, I recently hooked up an ethernet cable from the server to another computer, which has internet.
I've been slowly working my way through the Server Documentation and am on the Networking chapter. It has given me the commands to install wireless-tools, ethtool, dhcp3 server and I've also tried to install gedit. Every time it gives me the error: E: Unable to locate package XXX
When I ran the sudo lshw -class network command I find that it recognizes both an ethernet interface as well as a wireless interface(my wireless adapter). BOTH of them say *-network DISABLED.
My goal is to enable both of those, but I am assuming I need to be able to locate the packages first. I installed the server edition using a USB pendrive. I still have the files on the pendrive, but I don't know how to make the server locate those files. I'm guessing it wants to access the installation files to locate the packages to install.
View 7 Replies
View Related