1. 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

  2. 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/

  3. 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/

  4. 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

  5. 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/

  6. 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

  7. 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

  8. 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/

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. Development Server on Ubuntu Desktop

    Date: 06/10/07 (Webmaster View)    Keywords: php, mysql, software, browser, html, database, sql, linux, apache

    Ubuntu

    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

    1. sudo a2enmod rewrite.
    2. Edit Apache configuration: sudo gedit /etc/apache2/sites-available/default
    3. Change line 12: “AllowOverride none” to “AllowOverride all”
    4. save and close
    5. 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:

    1. Install IEs4Linux.
    2. Install Opera.
    3. Install Komodo Edit.
    4. Install gftp.

    Source: http://www.webmasterview.com/server_side/development_server_on_ubuntu_desktop

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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






    FYI: This'll be cross posted a bit.

    Source: http://community.livejournal.com/webdesign/1278123.html

Previous page  ||  Next page


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home