main

main@lists.alug.org.uk

10364 discussions

Re: [ALUG] Need to add remote screen to linux box
by Mark Rogers 14 Nov '11

14 Nov '11

On 09/11/11 17:29, Tony Tibbenham wrote: > Or you could go for something like > http://www.fit-pc.com/web/fit-pc2/testimonials/ for a truly tiny PC Thanks for this, I think this one looks pretty promising: http://fit-pc.co.uk/Trim_Slice_Value--product--41.html -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

1 0

Re: [ALUG] Energy monitoring
by Mark Rogers 14 Nov '11

14 Nov '11

On 14/11/11 11:23, Andy Taylor wrote: > Take a look at this - > http://www.retrocomputers.eu/2011/01/11/how-much-electricity-are-you-using/ > > Software logs to a MySQL database with a web front end. My meter is > connected to my server via a serial to USB cable. Thanks, that looks like the sort of thing I'm after. I've found what I hope is a suitable meter on eBay and will have a play. -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

1 0

Network magic
by Barry Samuels 13 Nov '11

13 Nov '11

My computer has two network interfaces, eth0 (wired) and wlan0 (wireless), to connect to my router. The wired connection goes via a small network switch to which a laser printer is also connected. The computer normally uses the wired connection but sometimes I need to disconnect that and use the wireless so that I have a wireless connection to the router but the cable is disconnected from the router leaving my computer connected to the switch which also has a laser printer connected to it. Is there any way that I can use the laser printer via eth0 when my computer is running on wireless? -- Barry Samuels http://www.beenthere-donethat.org.uk The Unofficial Guide to Great Britain

3 4

Need to add remote screen to linux box
by Mark Rogers 10 Nov '11

10 Nov '11

I have (or will have) a small Linux server running a minimal desktop distro and web server. The server will be used daily by someone sat next to it (using a web browser). In addition, I need to put a 42" display elsewhere in the building which will use a web browser to show a page from the same server. There'll be no local mouse or keyboard. There may be more than one such display in future. Any good options? Presumably I could use an extra video card for a second display (not sure the server will have a spare slot but maybe a USB video card would do) and run everything from the server, however I don't think I can be sure to stay within distance limits for USB. On the other hand I could just stick a PC with the 42" display, but that would be overkill. Having something that sat on ethernet (and perhaps could be configured via SSH) would be ideal, I'm just not sure what exists? Note that the web application makes use of jQuery and AJAX so it may place some limitations of the choice of browser. The ability to restart the browser periodically would be useful, knowing how they all seem to leak memory! -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

7 11

basic question about scripts, change user in midstream
by James Bensley 09 Nov '11

09 Nov '11

Hi Peter, I dont understand exactly what you're getting at here. Is the -u option of the `sudo` command what you're after? sudo -u fred whoami This would echo "fred". James.

1 0

basic question about scripts, change user in midstream
by Peter Alcibiades 09 Nov '11

09 Nov '11

How do I change user in a script, and then carry on with the task at hand? What I need to do is get the user to su to root, give the password of course, then carry on. For instance: su [and this then prompts for his password of course] cd /home/fred/Desktop [ now I would get him to enter a file name of a folder on his desktop and then...] chown -R fred filename What happens when I try this is that after changing accounts, the script stops. Very basic question.........., sorry. Peter

2 1

[ALUG Announce] ALUG Norwich Pub Meet Thursday 10th November
by Viperfang 07 Nov '11

07 Nov '11

ALUG Announce Please send announcements to Announce(a)lists.alug.org.uk Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce ----- Hello Aluggers, Our monthly ALUG Norwich social meeting will be held this Thursday, 10th November at The Coach and Horses (82 Thorpe Road, Norwich, NR1 1BA). The meeting officially starts at 8pm, although some people may arrive earlier. More information on those people can be found on the list and the IRC channel. If you are unsure if you will recognise us then make yourself and your intent to attend known by either posting on list or visiting us on IRC so we can look out for you rather than hiding in the corner. Optionally you could ask at the bar if they know where the geeky computer weirdos are and they'll point you in the right direction (seriously!). Another possibility is look for heaps of electronics on a table that may possibly look like movie props that would used for detonating explosives. Feel free to bring electronics/laptops/gadgets to the meet, you will by no means be alone. Ben Bewick aka Viperfang NB: This mail is automated, please refer to the usual sources for more information. ALUG Contact Details: Website : http://www.alug.org.uk/ IRC : #alug on irc.alug.org.uk List : http://lists.alug.org.uk/mailman/listinfo Twitter : http://twitter.com/anglianlug Identica: TBA Facebook: http://www.facebook.com/group.php?gid=2381613902 ----- Send discussion replies to main(a)lists.alug.org.uk (Reply-To set) Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce

1 0

A more subtle (?) sqlite (or actually just SQL) question
by Chris Green 06 Nov '11

06 Nov '11

I have a database which, among other things has a date column and also has some text columns. Is there any way to ask for:- The value of a text column for the last date less than the current date E.g. I have data like the following:- Date Text --------- --------- 2011-11-4 Cabbages 2011-11-5 Fireworks 2011-11-7 Nutcase and I want the result 'Fireworks' given the date 2011-11-6. SELECT Text from db WHERE Date < '2011-11-6'; will give all previous rows, not just the row I want. I sort of need to to say:- SELECT Text from db WHERE Date 'is the biggest one less than' '2011-11-6'; I guess I can do:- SELECT Text from db WHERE Date < '2011-11-6' ORDER BY Date DESCENDING; and use the first row returned but this somehow seems inelegant. Does anyone have any better ideas? -- Chris Green

2 2

How to work out what "SQLSTATE[HY000]: General error: 25 bind or column index out of range" actually means
by Chris Green 06 Nov '11

06 Nov '11

I'm getting this error when using PHP's PDO to insert records into an sqlite3 database. It's only happening on some inserts. SQLSTATE[HY000]: General error: 25 bind or column index out of range Now I realise it's probably telling me that some column constraint is being contravened or maybe that I have an invaldid column name or something in the insert. However I can't work out what the error is and without some sort of pointer as to which column (or whatever) is causing the problem I'm at a bit of a loss to find the error. The insert query string being handed to the prepare() function is:- INSERT INTO log (seqno, year, month, day, hour, minute, waterway, pk, place, distance, eng_hrs, fuel_cm, fuel_lt, note, type ) VALUES (:seqno, :year, :month, :day, :hour, :minute, :waterway, :pk, :place, :distance, :eng_hrs, :fuel_cm, :fuel_lt, :note, :type ); and the execute query is being handed an array with matching keys. I'm *wondering* if the issue may be that a couple of fields have characters like '-' and ',' in them, do I need to quote or escape these maybe? -- Chris Green

1 1

HTML question - any way to do this other than using tables?
by Chris Green 02 Nov '11

02 Nov '11

I know HTML isn't strictly linux, but still it's related isn't it and there are lots of clever and helpful people here. I want to lay out some web pages in the following sort of fashion:- Top of Page Heading Sub-heading C1 Data C2 Data C3 Data More C1 data More C2 data More C3 data Sub-heading C1 Data C2 Data C3 Data More data More data More data and more etc etc Sub-heading Etc. Etc. Etc I want all of the columns under the sub-headings to be the same widths so they're aligned all the way down (i.e. the same column widths under all of the sub-headings). Using tables one could either set all the column widths explicitly (but very difficult to make it work at different resolutions then) or one could make the sub-headings a column span and just make the text bold (so as a result it's all one table). Is there any other way that would be less painful? I suppose using the column spanning method isn't too awful but it's a really pity that HTML has no other way of putting text in columns. Note that the columns are not all the same width as I have shown above. -- Chris Green

4 10

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

main