- main - earth.li

Version control choices for web development
by Mark Rogers 27 Mar '10

27 Mar '10

I've experimented a little with version control over the years (cvs, svn) but never used it in anger even though I know I should. The thing that's always stopped me is that I've never found one that I've liked for web development. What I have is a server in my office that everything gets developed on. When I am happy, I use unison to synchronise the changes to the live site. What this gives me, is no ability to roll back changes if something goes wrong. What I want is for the version on the live site to just be a checked out version from a version control system, with the changes on the dev server being checked in to the version control as we develop. However, to me the logical location for the version control system is therefore my dev server in the office (which has plenty of disk space), but I don't want to open up ports to allow live servers to "pull" a version from the system. I want to be able to "push" a version to the server from the dev server, and that's where I get stuck. The best solution I've ever come up with is to check out a separate local copy which I then unison to the live site, but this is two steps instead of one and (more importantly) means duplicating the site locally for no real benefit - which is a pain if a site has several hundred MB of images, for example. The other part that I've never found a good solution for is handling databases; ideally there should be a way to perform diffs against different MySQL database schemas and apply them but I'm not aware of a way to do this either. On the other hand, what I want to do seems like a fairly "standard" thing so I'm sure either there must be a way or that other people in similar situations have found a better way to do it than I am suggesting? -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) @ 13 Clarke Rd, Milton Keynes, MK1 1LG

2 1

Re-ordering columns in an sqlite database
by Chris G 26 Mar '10

26 Mar '10

I know it isn't really necessary as it doesn't actually affect anything (except my sensibilities) but I'd like the ability to re-order columns in some sqlite databases. Well, it *does* have some advantages, it would mean I can do things like "SELECT * FROM database" and get the columns displayed in the order I want rather than the order resulting from database creation followed by adding extra columns as I found I needed them. So, is there any way to re-order columns other than by creating a new table with the required column order, copying all the data across, deleting the old table and renaming the new one? I can't find any neat utilities out there to do this for me. -- Chris Green

7 13

iTunes on EEE
by Mark Rogers 26 Mar '10

26 Mar '10

I've done a bit of Googling but as a non-iTunes user I'd like some real user experience if possible. A customer of mine has ended up with a "ASUS little shitty netbook thing" (his words!) for his daughter, and with the requirement that "all she wants to do on it is surf the internet & manage her itunes on it". They don't like the noddy interface (presumably Xandros?) and I could replace that for him. But iTunes I know nothing about. I gather that Songbird is a suitable replacement, but I have no idea how similar it is to iTunes and whether it'll allow her to manage her music files. Surfing the internet is easy, and they can already do it. What they'd like, of-course, is the XP model. But installing XP is expensive and I'd like to show them that they don't need XP to do what they want. Assuming that they can.... -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) @ 13 Clarke Rd, Milton Keynes, MK1 1LG

2 2

Re: [ALUG] Re-ordering columns in an sqlite database
by Govind Chandra 26 Mar '10

26 Mar '10

Brett Parker wrote: > In case one wasn't aware, all fields in sqlite are text. Nothing else. > It doesn't do type checking. It is not really so simple. Please have a look at http://www.sqlite.org/datatype3.html For reordering the columns of a table one could resort to a temporary table. create temporary table temptab as select column4, column3, column2, column1 from sometable; select * from temptab; I think that this is more flexible than reordering the columns of the main table. Remember that "temptab" is temporary and lasts only the current session, something I consider a feature. Govind Chandra

1 0

Hi, Geeks!
by Ted.Harding＠manchester.ac.uk 22 Mar '10

22 Mar '10

It's been a nice sunny day, and all that; and I've been out enjoying it; and got back to find myself wondering where the word "geek" comes from (dunno why). So on to Wikipedia. Excerpt: "Formerly, the term referred to a carnival performer often billed as a wild man whose act usually includes biting the head off a live chicken, bat, snake or bugs." Well, yeah, "bugs" connects. But I hadn't been aware that my very first OS, CP/M, might stand for "Chicken Post/Mortem". Just a thought. And it's still nice and sunny out there, chicks. Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 21-Mar-10 Time: 17:23:52 ------------------------------ XFMail ------------------------------

3 3

NumLock at startup
by Chris Walker 22 Mar '10

22 Mar '10

As per my other mail, I'm trying to make Mandriva switch off the NumLock LED at switch on. I've got it switched off in the BIOS but when I get to the login screen, Mandriva has already put it back on. I've got it switched off in the control panel but that doesn't affect startup. Any pointers as to where I should look for this? So far all my searches tell me how to switch things on, not how to stop the wretched thing coming on. -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:cdw_alug@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|

3 4

flv video issue
by Bev Nicolson 21 Mar '10

21 Mar '10

The problem is this. Whenever I try viewing a .flv video, Firefox crashes. I have, for another issue a while ago, reinstalled flash and that hasn't made any difference to this particular problem. Any ideas? Bev.

3 5

help with xinput
by Chris Walker 21 Mar '10

21 Mar '10

Hello, Due to health issues, I am trying to use an Evoluent Vertical Mouse with Mandriva linux. http://www.evoluent.com/vm3.html I'm using KDE as my desktop and have been unsuccessful in mapping the buttons. If you look at the picture in the above URL, you can see that the mouse has 3 buttons and a scroll wheel on the right side. It also has another button on the left side, shown in 'Familiar Grip' as button 5. I'm trying to map what is shown as button 2 as a double-click. I can do it under Windows 7 providing I use some extra software as the mouse isn't supported past XP but despite using xinput under Mandriva like this - xinput set-button-map 6 1 2 3 4 5 6 7 3 9 10 11 12 13, it isn't working as a double click. I also need to map button 5 as a refresh for use in web browsers. I haven't tried that yet as I didn't want Firefox to confuse the issue. I want double-click to work within the desktop. Has anybody done anything similar to this and can point me in the right direction as I'm getting nowhere fast. I also have a special keyboard and want to switch off NumLock at startup as Mandriva is switching that back on but I'll put in another mail for this. TIA. -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:cdw_alug@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|

1 0

port forwarding wierdness
by mick 20 Mar '10

20 Mar '10

OK - I know this isn't strictly a linux problem (though it may be) but someone here may be able to help, I have an odd problem with port forwarding through a linksys WRT120N router. My network looks like this: outside - Cisco ADSL - DMZ - Linksys - inside The DMZ net is 192.168.1.0/24 inside is 192.168.10.0/24 The DMZ has two debian ARM boxes on it, inside has several different debian/ubuntu boxes, but crucially has my dnsmasq DNS server on 192.168.10.50. That server lists all my local machines. The linksys has NAT turned on. It also allows port forwarding of both TCP and UDP on port 53 from the outside (i.e. the DMZ) to 192.168.10.50. Now the wierd bit. DNS lookups from the DMZ to the inner server through the linksys only work once every 4-5 minutes. So if I fire up nslookup or use dig to resolve any of my internally named servers I can do it immediately, but then get "connection timed out; no servers could be reached" for the next 4 or five minutes whereafter I can again resolve a host. Can someone please suggest what may be going on? Anyone else using a WRT120N? I can't find anything on the obvious forums. (And yes I know I could move the DNS server to the DMZ......) Mick --------------------------------------------------------------------- The text file for RFC 854 contains exactly 854 lines. Do you think there is any cosmic significance in this? Douglas E Comer - Internetworking with TCP/IP Volume 1 http://www.ietf.org/rfc/rfc854.txt ---------------------------------------------------------------------

1 0

We're not evil??
by Martin Collins 20 Mar '10

20 Mar '10

Anybody use magnatune for streaming through rhythmbox? See this link: http://blogs.magnatune.com/buckman/2010/03/new-business-model-for-magnatune… This would make magnatune more like spotify. Does this mean free listening is coming to an end? Personally I'm a bit cheesed off with it, as I don't listen enough to make a subscription worthwhile, nor do I have internet access 365 days a year so I wouldn't get what I was paying for. However, I did buy 3 or 4 albums from them a year. Forcing a business model on me, although not evil, certainly isn't angelic! Martin

1 0