-
Linux Database jobs
Date: 05/10/07
(MySQL Communtiy) Keywords: php, mysql, software, database, sql, postgresql, web, linux
I am currently working on 2 great jobs for Linux-loving database folk.
1-MySQL and PHP software engineer in PA near Philly (NE). This is for a young software co founded by a guru who had already built another company. He wants hot programmers who will grow with the company. He currently is looking for a Sr person as well as 1-2 junior folk.
1- Linux DBA in Utah - a company with several websites and millions of pageviews and transactions/day. Needs both senior and junior database tuners to keep their PostgreSQL DBS running smoothly. Every millisecond counts. He will take people w/ MySQL and Linux admin and perl background for the junior position. Full benefits, great work and flexible working conditions, and powder days!
My email is on my info page if you want to pass this on. Thanks!
Source: http://community.livejournal.com/mysql/113663.html
-
How To Migrate Mantis Defect Tracking System From Windows To Linux / Fedora Core 6
Date: 05/12/07
(Java Web) Keywords: php, mysql, database, sql, postgresql, linux
Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux. It used MySQL as backend. Here are the steps:
1. Export Mantis MySQL database from Windows, upload it on Linux and then import it to MySQL database on [...]
Source: http://blog.taragana.com/index.php/archive/how-to-migrate-mantis-defect-tracking-system-from-windows-to-linux-fedora-core-6/
-
Ghost DNS Lookup Puzzle on NIS Clients
Date: 05/15/07
(Java Web) Keywords: database
I faced an extremely weird problem of ghost DNS lookups on machines configured as NFS clients. It took quite an effort to solve it. Here are the details.
Configuration
I have a machine configured as NFS & NIS server, named database. There is another machine (named internet) configured as caching DNS server and also to provide DNS [...]
Source: http://blog.taragana.com/index.php/archive/ghost-dns-lookup-puzzle-on-nis-clients/
-
PC audit tool
Date: 05/17/07
(IT Professionals) Keywords: technology, database, linux
My company is looking for an audit tool which will help us track down hardware, e.g. when someone says "do we have a spare dual core PC kicking around?" we could search a database (updated daily?) of specs including when those machines were last used.
It's easy enough (in theory) to keep track of PC specs and where they were deployed but the hard part is finding out if they're actually being used - not that any of us hoard hardware :)
We have ~200 Windows machines (mostly XP or 2003 Server, but some NT4 and a few Vista installs recently) plus a few Linux (Red Hat and SUSE) servers in one site; we do maintain a couple of subnets, but the tool wouldn't have to span them (we could run it separately on each net if need be).
The tool doesn't have to be freeware but personally I'm a big fan of open source; it would, of course, have to be malware-free and be able to interrogate Windows machines (the Linux boxes would be a bonus but not essential). We're not going the extra step of trying to physically locate the hardware - that would require too much technology (i.e. money), and it won't hurt the techies to do a little legwork. :)
Any recommendations?
Source: http://community.livejournal.com/itprofessionals/56836.html
-
The case for HSQLDB as RDBMS for Java Development
Date: 05/19/07
(Java Web) Keywords: database, sql, java
HSQLD is a mature, high-performant database written in Java. It is used in several high profile popular commercial and open source products like Open Office 2.0 (Office productivity suite; competitor of MS Office), JBoss (Application Server), JFox (Application Server), Jonas (Application Server), Mathemetica, Hibernate (ORM), Jira (Defect Tracking), TrackStudio (Defect Tracking), C-JDBC (Database Clustering) etc. [...]
Source: http://blog.taragana.com/index.php/archive/the-case-for-hsqldb-as-rdbms-for-java-development/
-
permissions problem
Date: 05/23/07
(PHP Community) Keywords: database, linux, apache
Have all these pdfs on a linux server here at work. They are associated by id numbers in a database. Sometimes the pdfs are assigned a wrong number so I have a script that changes where they are stored and what number they have in the database. Everytime I try to do it though I get an error on rename (which I'm also using to move files). Says permission denied.The files are owned by the "tech" user and the user trying to rename them is "apache". But I the pdfs are set to 777 so I don't understand why it doesn't have permission. Any suggestions?
*edit*
Used a perl script instead. Problem solved.
Source: http://community.livejournal.com/php/567585.html
-
updating slow for one table
Date: 05/25/07
(MySQL Communtiy) Keywords: php, database
i have a production database and a development database running on the same server. (i know that's dumb but it's all we've got.) i copied a table from production to dev and performed an update on it via a php script. the script reads a csv file, checks to see if the item is already in the table, updates the row if it is, and inserts if it's not. 90% of the time it's an update. when i ran the script on the dev table, the process took about 30 minutes. everything looked good so i ran it on the production table. it's been running for ~3 hours. as far as i know, the tables in production and dev are exactly the same -- same server, same data, same indexes. almost no one is working today so the server is practically idle. is there any reason the same process would take so much longer in another database?
Source: http://community.livejournal.com/mysql/113841.html
-
How To Escape Column Names in HSQLDB RDBMS
Date: 05/26/07
(Java Web) Keywords: database, sql
Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character. HSQLDB doesn’t accept either backtick or single quote as escape character. Instead you have to use escaped double quotes as shown in the example below:
st.execute("CREATE TABLE sheet (tg_meta_id int identity [...]
Source: http://blog.taragana.com/index.php/archive/how-to-escape-column-names-in-hsqldb-rdbms/
-
SSIS: Passing a result set to a data flow
Date: 05/31/07
(SQL Server) Keywords: database, sql
Okay, this one's got me stumped...
I'm converting SQL Server 2000 DTS packages to SQL Server 2005. It seems like what I'm trying to do should be simple: An Execute SQL Task runs a stored procedure, then stores the output in an Object called ResultSet. (The Execute SQL task isn't working, but that's beside the point right now.) Now, what I need to do is export the result set into Excel. Simple, right? Take the result set and export into Excel using a data flow.
Except, umm, there doesn't seem to be any source in the data flow screen that specifies a variable. I realize the easiest way to do this would be to store the results of the stored procedure in an actual table and just export the table to Excel, but I'm not entirely sure I have create permission on the database.
Anyone tried to do this? Is there something painfully obvious that I'm overlooking? Thanks.
Source: http://community.livejournal.com/sqlserver/59141.html
-
Need some assistance in writing up SQL Server tasks for resume
Date: 06/03/07
(SQL Server) Keywords: programming, database, sql
I'm trying to update my resume with the sql server tasks I've been doing for the last 2+ yrs, but I'm really stuck on what exactly to put and how to word it.
Quick background: I've heavily programmed in and used MS Access since 1994. In many cases, I did the db design, creation, and upgrades for all tables, queries, forms, and reports. I often created the app that other people use. It took me a while to find a job where I could learn and use SQL Server. I finally found that about 2.5 years ago (there's a lot of Access programming using a tool already created at my company, with a SQL Server backend).
Could really use some input!
I'm really not performing SQL Server DBA work; the majority of the tasks I tend to perform are:
- writing and running simple select queries
- writing and running complex queries (several inner and/or left joins) to select, append (insert into), update, or create a new table from a data set using particular criteria
- processing/manipulating large data sets (1 million + records) to drill down to a smaller set that can be handled by the Access app
- incorporating CASE statements into the queries
- importing a table into SQL Server from text files, spreadsheets, or Access tables, using the Import/Export tool (a task I do only very occasionally)
Any suggestions on how I can word this in the resume?
Oh, and I can tell you as an experienced Access programmer (who started from v2, where you had to really understand Access and database concepts and normalization, no cute little wizards to help) that SQL Server really ROCKS and I prefer it. Now, to be able to use it more...
Source: http://community.livejournal.com/sqlserver/59901.html
-
Newbie with a Question. There's an introduction.
Date: 06/05/07
(Web Development) Keywords: database
My local college requires students to buy their school books. At the end of the year, they give them the option to sell them back to the school, at a loss. The problem is, every time they switch to a new edition of a book, they refuse to buy back the old ones. So the students end up with a lot of older edition books. Most of them are just a tiny bit different from the newer ones.
If I wanted to make a mini half.com for my local college, how would I go about it? I know I want a sort of database where students can search for books by Title, Author(s), ISBN, Edition, Publishing Date, Price, and Class Name and browse by category. I also want to have a place where students can post which books they're looking for.
I need an option to make payment online, through the mail, or face-to-face (since they're in the same college).
The site should operate as a mini half.com/trading post.
I think such a site would use forms, but which forms? And how?
Source: http://community.livejournal.com/webdev/412170.html
-
DIY Framework v0.1 released
Date: 06/04/07
(Web Development) Keywords: php, templates, mysql, html, xml, database, sql, web
xml.lt has announced the release of DIY Framework. It is an open–source web application framework based on MVC architecture, object–oriented PHP 5, MySQL, and XSLT.
The Model is database–backed and generated by Propel ORM tool, the Controller is inspired by REST and RDF, and the View is based on XSLT stylesheets as templates.
The framework allows clean and precise sever–side development with a fully object–oriented code, absolutely no mixing of PHP, (X)HTML and/or SQL code, resources that have nice meaningful URIs with no extra effort, and many other features. On the other hand, it is tiny, flexible, and not overloaded with buzzword things.
Blog post (digg!):
http://www.xml.lt/Blog/2007/06/04/DIY+Framework+v0.1+released
More information and download:
http://www.xml.lt/Resources/Framework
Martynas
Source: http://community.livejournal.com/webdev/411944.html
-
dreamhost: general warning
Date: 06/06/07
(WebDesign) Keywords: database
yesterday nightish a 3rd party broke into dreamhost's database and got the pw information for 3,500 accounts (including my work account, which is why i was alerted via email by dreamhost). all the 3rd party apparently did was run a script that injected some fluff code to everyone's index files to give their own site better search engine rankings, but they're not quite sure.
3rd party also apparently tried to break into their customer information database but was prevented.
i'd just check your dreamhost sites to make sure nothing is up. better safe than sorry.
Source: http://community.livejournal.com/webdesign/1262457.html
-
HELP - problem finding errors
Date: 06/08/07
(PHP Community) Keywords: php, programming, css, html, database, java
Hi there,
i'm having a problem with a site i'm working on. i'm a media student and one of our many subjects is system design, meaning we learn about java, python, php and more languages. i'm not the programmer person, and the subjects i like better in my studies are the design ones, so natuarlly i'm having major problems understanding and doing programming.
i know that i'm not the worst in it either, but with this exercise i've come to my limits. it's pretty simple. we started with making a layout using css, but then we had to add php code and a database to it so as to add new elements and edit existing ones to the database using forms.
so, the problem is a general and ususal one, meaning that there are errors in my code that i just can't find. i've gone through it a million times, asked collegues to give me their code to compare (since they didn't have time to sit down with me and help) and i've gone to message boards to ask for help (which wasen't very successful cuz they directed me to go read some basic php tutorial. i wouldn't have gone to the message board hadn't i done that already). anyway, i'm at a total loss as to what could be wrong. the zip file uploaded here contains everything of the page, even a text file of the database used that you can import into your server.
the problems i have are:
1) the 'DVD-Vols.php' file should just print out all the dvd volumes that exist of the series. beside each entry is a delete link to delete that entry from the database and a link to more detailed info on that dvd volume. the printing works out fine, but the delete link only deletes the entry of the database table that has the 'ID' '0'. the link to the detail info does not work either. i wanted use a php codeing that automatically fills in the 'ID' to it's corresponding entry in the db and passes it on, so the detail page of the dvd (DVD.php) knows which dvd volume to display.
2) on the 'DVD.php' page i want to print out only one of the table entries from the db, depending on the 'ID' the link from the previous page passes on.
3) the add and edit forms (there are two versions of each: Add-Form.php & Edit-Form.php) don't seem to work. a friend of mine told me they are correct, but when using them on my machine, nothing happens. what happens on mine regarding the add-form was the following:
i had started my table entries with an entry that i gave the 'ID' '1' to instead of '0', so when using the add form, the new entry was assigned that id. when trying to add another, the previous entry i made lost all it's 'contents'. the edit-form did not work at all.
4) in the home.html page i'm trying to add an image that moves from one side to the other, which seems to only work when first loading the page (it moves 5px to the right) but somehow the counter seems to not work, and i've got no clue why.
i know that this is a lot to ask, but i'd REALLY appreciate the help, on any of these problems.
thanks a million in advance!
[x]cross posted
Source: http://community.livejournal.com/php/570094.html
-
Development Server on Ubuntu Desktop
Date: 06/10/07
(Webmaster View) Keywords: php, mysql, software, browser, html, database, sql, linux, apache
Last month,I did a clean install of Ubuntu Feisty Fawn on my home computer removing the "dapper drake". But it is only now, I got a chance to sit down and install all necessary packages to set up my development server again.
With Dapper Drake, I had to use alien to convert MySQL5 rpm to .deb, because there was no version 5 in the repositories. Anyway, Feisty has all newest versions of software.
This is what I did for setting up my development server:
For installing MySQL server I ran the command: sudo apt-get install mysql-server. Then I installed the following:
MySQL Administrator: It is a Graphical User Interface for administrating MySQL: sudo apt-get install mysql-admin
MySQL Query Browser is a GUI for managing databases: sudo apt-get install mysql-query-browser
Apache: sudo apt-get install apache2
Apache Manual: sudo apt-get install apache2-doc
PHP: sudo apt-get install php5
PHP module for Apache: sudo apt-get install libapache2-mod-php5
Enabling public_html directories for users
Well, I am the only user in my computer. But I can create and edit files without running sudo if I have a public_html directory at my home. sudo a2enmod userdir. I then restarted Apache and created a 'public_html' directory in my home. Now I can access it with http://localhost/~username/.
Enable mod_rewrite
- sudo a2enmod rewrite.
- Edit Apache configuration: sudo gedit /etc/apache2/sites-available/default
- Change line 12: “AllowOverride none” to “AllowOverride all”
- save and close
- Restart Apache
(Thanks to mod_rewrite for Apache2 in Ubuntu Feisty Fawn 7.04)
How to restart Apache?
sudo /etc/init.d/apache2 force-reload.
Todo:
- Install IEs4Linux.
- Install Opera.
- Install Komodo Edit.
- Install gftp.
Source: http://www.webmasterview.com/server_side/development_server_on_ubuntu_desktop
-
Keyword Database (44,000,000 search queries in Google)
Date: 06/14/07
(Web Development) Keywords: php, database, tracker, google
Xedant Keyword Database - contains 44,000,000 (44 millions) keywords - search queries in Google with complete information according to each of them: Overture, Wordtracker and Google Adwords popularity estimation, competition estimation according to Google and Google AdWords, bid price estimation according to Google AdWords.
The database is used for:
- keyword research;
- generating doorways;
- discovering profitable AdSense niches;
- finding good domain names for resale or parking;
- getting new ideas for products and services.
More info: http://www.xedant.com/keyword-database.php
Source: http://community.livejournal.com/webdev/415595.html
-
Keyword Database (44,000,000 search queries in Google)
Date: 06/14/07
(WebDesign) Keywords: php, database, tracker, google
Xedant Keyword Database - contains 44,000,000 (44 millions) keywords - search queries in Google with complete information according to each of them: Overture, Wordtracker and Google Adwords popularity estimation, competition estimation according to Google and Google AdWords, bid price estimation according to Google AdWords.
The database is used for:
- keyword research;
- generating doorways;
- discovering profitable AdSense niches;
- finding good domain names for resale or parking;
- getting new ideas for products and services.
More info: http://www.xedant.com/keyword-database.php
Source: http://community.livejournal.com/webdesign/1266101.html
-
New Project
Date: 06/30/07
(MySQL Communtiy) Keywords: database, web
Recently, I thought up a new project that will be used for storing Recipes. This way I'd have access to my recipe box from anywhere, and all my recipes would be stored in one place, rather than at a bunch of different sites.
At this point I'm mostly just writing down the details of what I want it to do, but it occured to me that there are going to be a TON of database calls in this thing. Like, oodles. At least until I figure things out a bit better.
This brought up a question that has been lurking in the back of my mind for a while...Is it better to open a connection to a database, make your query/insert/whatever, and then close it again? Or is it better to open the connection at the initial pageload and then close it at the end of everything?
Since this is going to be web based, if I did just the single open/close, how would I guarantee that the connection is closed out properly?
Usually when I do something with databases, it's not intended to be used by a huge lot of people (this project included), but every function that makes queries/inserts/etc from the database also has it's own open/close statements to the database. I'm just wondering if that's the best way to do it on what might become a large scale project (because, frankly, this thing may turn into a beast really quickly).
Source: http://community.livejournal.com/mysql/115872.html
-
Inserting
and a space using the DOM
Date: 07/05/07
(Javascript Community) Keywords: database
I'm working on customer management system, and have introduced a little AJAX to make the interface a bit more user friendly. At the moment, I'm having a little trouble with an edit-in-place contact controller.
For adding a new contact to a customer's file I have a form which when filled out saves the contact to the database synchronously then removes the form and shows the new contact details as text. It's not the AJAX part that is causing me a problem, the application is fully functional, it's more a matter of presenting the new details neatly on the page after they have been saved.
newContactTr1 = document.createElement('tr');
newContactL1 = document.createElement('td');
newContactR1 = document.createElement('td');
newContactL1.style.fontWeight = 'bold';
newContactR1.style.fontWeight = 'bold';
newContactTr2 = document.createElement('tr');
newContactL2 = document.createElement('td');
newContactR2 = document.createElement('td');
linebreak = document.createElement('br');
space = document.createTextNode(' ');
newContactTr1.id = 'row1-NewContactTemp';
newContactTr2.id = 'row2-NewContactTemp';
newContactL2.id = 'numbers-NewContactTemp';
newContactR2.id = 'address-NewContactTemp';
newContactL1.appendChild(fnameSpan);
newContactL1.appendChild(space);
newContactL1.appendChild(lnameSpan);
newContactR1.appendChild(document.createTextNode('Address'));
newContactL2.appendChild(phone1Span);
newContactL2.appendChild(space);
newContactL2.appendChild(phone1descSpan);
newContactL2.appendChild(linebreak);
newContactL2.appendChild(phone2Span);
newContactL2.appendChild(space);
newContactL2.appendChild(phone2descSpan);
newContactL2.appendChild(linebreak);
newContactL2.appendChild(phone3Span);
newContactL2.appendChild(space);
newContactL2.appendChild(phone3descSpan);
newContactR2.appendChild(street1Span);
newContactR2.appendChild(linebreak);
newContactR2.appendChild(street2Span);
newContactR2.appendChild(space);
newContactR2.appendChild(townSpan);
newContactR2.appendChild(linebreak);
newContactR2.appendChild(countySpan);
newContactR2.appendChild(linebreak);
newContactR2.appendChild(postcodeSpan);
newContactTr1.appendChild(newContactL1);
newContactTr1.appendChild(newContactR1);
newContactTr2.appendChild(newContactL2);
newContactTr2.appendChild(newContactR2);
contactsTable = document.getElementById('contactsTable');
contactsTable.appendChild(newContactTr1);
contactsTable.appendChild(newContactTr2);
It basically inserts four table cells, with the details in spans (the spans have been set earlier). The problem I'm having is with my line breaks and spaces to make the text present properly. They just don't appear. Can you see any obvious reason why this would be? Alternatively, is there a better way to do this?
Thanks in advance!
Source: http://community.livejournal.com/javascript/135276.html
-
Ajax
Date: 07/06/07
(WebDesign) Keywords: php, html, xml, database, java, microsoft
I'm trying to teach myself how to use Ajax with PHP. It's been years since I've used JavaScript for anything so I'm beyond rusty.
I've been using the Apress Beginning Ajax with PHP book and I've been learning quite a bit, but I haven't found a single code sample from that book that actually worked the way it was written.
So, I come to you with my situation: Right now, I have one field in a form. There will eventually be more, but I'd like to see if I can get just a single field to work for me before I start jumping ahead. Anyway: 1 field on a form, and one submit button. In theory, when I click on the submit button, I'd like the value to be input into the database.
I have bigger ideas for what I want to do with this project, but for now, just a little success with the database updating would be nice.
Note: The code is based off of a contacts form I found on the internet. I figured for learning purposes, it would be a good way to start, that way, once I figure out the trick to making ajax do what I want in this instance, I can write my own.
AJAX Recipe Form
AJAX Recipe Form
Inserting recipe via slick AJAX. Hold on just a sec…
Success! Your recipe has been sent.
FYI: This'll be cross posted a bit.
Source: http://community.livejournal.com/webdesign/1278123.html