- main - earth.li

Norwich 2600: This Friday!
by Ben Bewick 04 Oct '11

04 Oct '11

For those of you who are interested, there is a 2600 meeting in Norwich this friday, full details on our website! http://www.norwich2600.co.uk

1 0

Efficient/simple basic data entry application for sqlite3 or mySql database wanted
by Chris G 04 Oct '11

04 Oct '11

I want a simple, straightforward way to enter data into a sqlite3 database, by this I mean:- I want to be presented with the existing table contents with rows across the page (it will fit across the screen, the database will have only five or six columns). It would be nice if I can customise the sort order. I want to be able to add data at the bottom where there will be an empty row by simply typing the data in and tabbing to the next field, no pop-up boxes or other hoops to jump through. None of the applications that I can find provide anything remotely as easy as this, both sqlitebrowser and sqliteman are very painful to use for entering data. The application can run on the local PC or as a web application. I already have a plugin for my Wiki that does most of what I want with the database but it can only do data entry with a single row of the database shown (i.e. what Access calls 'columnar'), what I want is what Access calles 'tabular'. If there's nothing suitable for sqlite3 I could use mySql instead. -- Chris Green

1 0

How to enable WiFi from cammand line on eeePc?
by Chris G 03 Oct '11

03 Oct '11

I have an Asus eeePc 701 running Ubuntu 10.04, no GUI just the base installation plus a few bits I needed. We now have WiFi available on the boat (where the eeePc is) and so I want to use it from the eeePc - does anyone know how to do it? The eeePC sees the Wifi as an ifconfig returns some information about it, what command line tools etc. do I need to configure it? The WiFi is pretty standard with "WPA & WPA2 Personal" security. -- Chris Green

2 5

cisco router
by mick 01 Oct '11

01 Oct '11

Hi Guys Clearing my cupboard again I have an old Cisco SOHO 97 (837 equivalent) ADSL router going spare (free to a good home). Could be useful to sopmeone who wants to be able to play with cisco IOS (trust me, you wouldn't want to use the web interface, it's crap). 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

Need some router/WiFi/routing help and advice
by Chris G 26 Sep '11

26 Sep '11

I need to 'rearrange' the internet connection on our boat. We used to have a connection via a 3G router with a Mobistar (Belgian) SIM in it and everything on the boat (two PCs, printer, VOIP base station) just plugged into the router. It was flakey at times because we didn't have a good signal, but it worked. However we are now permanently in France and our long term mooring has WiFi available (whoopee!) This rather spoils my nice simple setup and I need some advice to work out how to rejig things. The trouble is that neither the printer nor the VOIP base station can do WiFi so I need to have a switch at least to interconnect things. However even that isn't straightforward (at least not to me!). What's needed is:- Local (i.e. LAN) connection between PCs and printer, can be provided by a switch or router but needs to be routed correctly so PCs use the WiFi for everythng except the printer. At present I have to disconnect WiFi and connect wired LAN to print and then vice versa to use the internet. I need to connect the VOIP base station (wired ethernet only) to the WiFi somehow so we can use the phone. The ideal solution would be if I can persuade the 3G router (which does have wireless) to connect to the WiFi here and then provide hard wired services to PCs, printer and VOIP. Is this a normal sort of thing to be able to do? The router does have something about WiFi relay in 'Lazy', 'Bridged' and another mode, should I be looking at these? -- Chris Green

3 9

usb to parallel printer converter
by Peter Alcibiades 24 Sep '11

24 Sep '11

Does anyone have any idea for this? I have a star receipt printer with a parallel interface and no linux drivers. So I am printing to it using lp and just sending raw text to the device itself. The command in question, which works just fine, is: lp -d star temprint.txt In the same way, I send the hex characters to make it cut the receipt and also to open the cash drawer. I say it works fine, it has one slight issue which we can live with, that being that if the printer goes offline, all the print requests queue up and print out in a batch when it comes back. However this being an industrial strength receipt printer, its something we can live with, it hardly ever happens. Leaving that aside.... I set up the printer in CUPS with the name of star, and addressed as parallel:/dev/lp0 Now comes the problem. Parellel interfaces having gone the way of the dodo, the new computer I'm seeking to use only has a usb port. So I got a usb to parallel converter cable. I have played with this by stopping cups, then editing the /etc/cups/printers.conf file. I can't get it to work. Supposedly from the gentoo wiki, which is usually very helpful, you should address it as parallel:/dev/usb/lp0 On the grounds that linux still thinks its dealing with a parallel port. Makes no sense to me, but I tried it, and no luck. The cable itself is recognised and visible if you do lsusb. Also, I know it works fine as cable because I can connect another printer with a parallel port for which I do have drivers, and successfully print a test page on it over that cable. I must be doing something obvious wrong, but what? How do you address the usb port directly and just send it a stream of text, as in my present setup? Is there a way? Peter

3 2

Restarting Firefox from the commandline
by Mark Rogers 23 Sep '11

23 Sep '11

I have an Ubuntu box which I can access remotely via SSH. It is primarily a server but has a GUI with Firefox running on it for people on site to access the web interface that the server provides. Firefox, being Firefox, sucks up memory the longer it's running. So I'd like a way to force it to restart via my SSH connection, and assuming I'm happy with the results probably via a cron-job every night. I can obviously "kill" it, but I'm not sure how I then restart it given that I'm not running from within the GUI environment myself; also, I don't want it to start up offering to restore tabs from a crashed session, I just want it to go to it's configured home page. Suggestions? -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450 Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER

3 6

Partitioning Laptop
by Richard Parsons 20 Sep '11

20 Sep '11

Hi, I've recently bought a Compaq laptop. It currently has Windows 7 installed and I want to dual boot with Ubuntu. Unfortunately, Compaq have already partitioned the hard disk into four partitions. The largest partition, which is 480GB is the second. If I begin the installer, and resize the second partition to create free space, then I'm told that it is "unuseable". I believe that the extra partitions are for recovery etc. So what can I do? Is there a way of getting Ubuntu installed without disturbing the contents of the partitions already setup? Thanks in advance Richard

12 22

[ALUG Announce] 3rd Monday Monthly Ipswich Social Meeting : McGintys, Northgate Street
by samwise 16 Sep '11

16 Sep '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 ----- The monthly "Third Monday" ALUG Ipswich Social Meeting is next week, Monday 19th September, at 20:00: P J McGinty & Sons 15 Northgate Street Ipswich Suffolk IP1 3BY Tel: 01473 251 515 Map/Directions URI: http://maps.google.co.uk/?q=IP1+3BY WWW: http://www.pjmcgintys.co.uk/ McGintys pub is in the centre of Ipswich. It's directly opposite the town's central library and has a reputation for good Irish beer. We're usually to be found in the lowest section of the bar, near the library entrance to the pub. All are welcome, novices and experienced users. Feel free to ask for further information on the Main ALUG mailing list. I'll be there, so if any one new wants to drop in, look for the guy in the corner with the latest copy of LXF ... ;) Peter. ----- 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

Running CUPS as normal user
by Dan 16 Sep '11

16 Sep '11

Dear All, On my Gentoo system, /usr/sbin/cupsd has permissions -r-x------ i.e. it can't be run (nor even read) as a normal user. Does anyone know why, please? Is it safe just to chmod the file then run it as a normal user? (Background: my new printer, an Epson SX525WD, needs proprietary drivers - and I like to run proprietary software only as a special, low-privileged user.) Thanks -- Regards, Dan

3 5