main

main@lists.alug.org.uk

10364 discussions

Any PHP PDO/Sqlite experts here, can't fathom this error message
by Chris Green 28 Nov '11

28 Nov '11

I'm flummoxed by this error, even worse is that the code seems to work sometimes but I can't see any pattern in the data that causes it. The code is as follows:- try { $insQuery = "INSERT INTO log "; // $insQuery .= "(seqno, year, month, day, hour, minute, waterway, pk, place, distance, eng_hrs, fuel_cm, fuel_lt, note, type, sailing)"; $insQuery .= "(seqno, year, month, day)"; $insQuery .= " VALUES "; // $insQuery .= "(:seqno, :year, :month, :day, :hour, :minute, :waterway, :pk, :place, :distance, :eng_hrs, :fuel_cm, :fuel_lt, :note, :type, :sailing );"; $insQuery .= "(:seqno, :year, :month, :day);"; $st = $db->prepare($insQuery); foreach ($rows as $row) { $row['seqno'] = $seqno++; $st->execute($row); } $st->closeCursor; } catch (PDOException $e) { dbglog("PDO() insert error" . $e->getMessage()); dbglog("insquery: $insQuery"); foreach($row as $k=>$v) { dbglog("k is: $k, v is $v"); } } ... and what I'm seeing in the log is:- 13:53:59 192.168.1.4: PDO() insert errorSQLSTATE[HY000]: General error: 25 bind or column index out of range 13:53:59 192.168.1.4: insquery: INSERT INTO log (seqno, year, month, day) VALUES (:seqno, :year, :month, :day); 13:53:59 192.168.1.4: k is: year, v is 2011 13:53:59 192.168.1.4: k is: month, v is 11 13:53:59 192.168.1.4: k is: day, v is 12 13:53:59 192.168.1.4: k is: hour, v is 10 13:53:59 192.168.1.4: k is: minute, v is 00e 13:53:59 192.168.1.4: k is: waterway, v is 13:53:59 192.168.1.4: k is: pk, v is 13:53:59 192.168.1.4: k is: place, v is Cappy 13:53:59 192.168.1.4: k is: distance, v is 13:53:59 192.168.1.4: k is: eng_hrs, v is 2695.3 13:53:59 192.168.1.4: k is: fuel_cm, v is 8.5 13:53:59 192.168.1.4: k is: fuel_lt, v is 13:53:59 192.168.1.4: k is: note, v is Engine started after replacing blown mega-fuse, all OK otherwise 13:53:59 192.168.1.4: k is: type, v is TEF 13:53:59 192.168.1.4: k is: price, v is 13:53:59 192.168.1.4: k is: sailing, v is 1 13:53:59 192.168.1.4: k is: seqno, v is 0 So what does "General error: 25 bind or column index out of range" actually mean, I could find nowhere that explains it. Now my guess is that it's telling me that I have a column name wrong somewhere but my 'log' table definitely has columns year, month, day and seqno of the correct type. Maybe I have the syntax wrong somehow for the VALUES() bit but again I can't find any really good explanation of exactly what the syntax is, it seems decidedly woolly. -- Chris Green

2 2

Any WordPress users here - is it really this awful to change a WordPress domain?
by Chris Green 24 Nov '11

24 Nov '11

I've been developing a simple web site for someone using WordPress (along with zillions of others I believe). I've now discovered that it is horrendously awful to move it to another domain! Not only are links in WordPress absolute but there are also loads of database entries which have the absolute URL in them. So one has to fix all the links in pages one has created *and* one has to search through the database and fix URLs there too. Aaaarrrrgggghhhh!!!! Setting the 'WordPress Address' and the 'Site Address' on the dashboard settings page only fixes URLs generated by the code (i.e. the menu links to pages). Apart from anything else it makes doing maintenance/development a nightmare. Is there any way around this or is the only approach for maintenance to have two parallel sites one 'development' and one 'live' where one tries out changes on the development site and then repeats them (hopefully correctly) on the live site. -- Chris Green

4 5

Clam
by Bev Nicolson 23 Nov '11

23 Nov '11

Now it may be that I've missed something obvious here but I've got Clam installed but can't see anyway of running it, either with mouse clicks or otherwise. How do I do that? (Lucid, 10.10) Bev.

4 4

bash getopt
by samwise 21 Nov '11

21 Nov '11

Hi, Has anyone done anything with GNU enhanced getopt in bash to process incoming command line parameters? My understanding is that I have the choice of using the built-in "getopts" command within bash (on a CentOS 5.3 derivative distro), which doesn't support long options (e.g. --long-option as opposed to -l), or I can use the getopt (enhanced) 1.1.4 binary which lives in /usr/bin/getopt. I want to use long options, so I'm using the GNU getopt binary. An example script is below. Note that there is one oddity - for compatibility with some other related scripts, I need the first parameter to be something else ... so the first few lines are intended to munch $1 and pass all the remaining parameters to getopt. I don't think that should affect anything, but I've left it in as that's how I'm currently testing it. My problem is that I don't seem to be able to get the parsing to work as I expect. Specifically: # ./cmd.sh . -i -o 1 input -i is -o So the problem here is that it's quite happy to set the required parameter for -i to be -o ... when actually I was expecting it to catch that -i was missing a parameter. I think I had this working using getopts, but I need to be able to support long options now. I've messed around a bit with several different ways of writing the case script, but not managed to get it working any better. So, idle question ... has anyone got a script like this where the error checking is a bit more robust than the sample below? Cheers, Peter. #!/bin/bash paramArray=("${@}") unset paramArray[0] paramArray=("${paramArray[@]}") getopt -T if [ "$?" != "4" ]; then echo GNU enhanced getopt not detected. Quitting ... exit 1; fi # Override defaults with incoming parameters, if specified PN=`basename $0` ARGS=`getopt --name "$PN" --longoptions input:,output:,noshort:,verbose --options i:o: -- "${paramArray[@]}"` if [ $? -ne 0 ]; then echo "Invalid option specified or expected parameter argument missing. Quitting ..." exit fi eval set -- "$ARGS" while [ $# -gt 0 ]; do case "$1" in -i | --input) echo input $1 is "$2"; shift;; -o | --output) echo output $1 is "$2"; shift;; --noshort) echo noshort $1 is "$2"; shift;; -v | --verbose) VERBOSE=yes; shift;; --) shift; break;; esac shift done exit;

1 1

Relative risks of different ports/services being open
by Chris Green 21 Nov '11

21 Nov '11

I'm wondering what are the relative risks of the different ports I have opened up on my firewall. Currently the ports I have open are:- 22 - ssh (but limited to only allowing two IP addresses to connect) 80 - http 25 - smtp 873 - rsync (not sure if I actually use this now, must check!) I'm considering what the risks of opening up port 443 (https) are to use with shellinabox and ssh. This would allow ssh from a web browser anywhere into my desktop machine (in addition to https access to the apache server of course), is this a significantly bigger risk than the limited ssh access that I have now? My thinking is that the port 443 access to ssh *is* significantly riskier than my existing ssh access, however I'm not sure if I'm being overly paranoid given that I already have open access on port 80 to my web server. What I'm really asking is whether worrying about open ssh access (with a good secure password) is a bit irrelevant given that port 80 is open to web browsers? Or is the damage that could be done if someone *does* guess my password (or it gets out by some other means, quite possible) for ssh much worse than anything using a browser/apache exploit? Any/all help appreciated, including ways that I could limit the shellinabox access to specific clients. As it is the client I'm thinking of is my Kindle but nothing at the shellinabox end can see anything to do with the Kindle because the proxying in between effectively anonymises the connection. -- Chris Green

2 2

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

21 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 ----- The monthly "Third Monday" ALUG Ipswich Social Meeting is back tonight, Monday 21st November, 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. 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

2 1

How can I deny certain countries access to my website
by Ian Douglas 19 Nov '11

19 Nov '11

For about a month one of my websites (or rather the "Contact Us" form on that website) has been under regular, daily, attack from hackers. The attacks are consistently coming from IP Addresses in Rumania and Russia. Each time an attack occurs I use my webhost's cPanel to manually add the IP to my cPanel "IP Deny Manager" list. This is however becoming rather tedious and time consuming and seems the wrong way round to do things as I am denying IP Addresses AFTER they have tried to hack in rather than blocking them BEFORE they attempt it. Is there a way I can simply deny access to my website (or, better, just it's home-made PHP based "Contact Us" form) to all Eastern European visitors? Alternatively, since my website is primarily focused on UK customers, would there be an easier way to deny all visitors access unless they came from UK, USA Canada, Eire or Australia? I realise that this is not specifically a Linux question but any suggestions would be welcome. Ian.

10 10

How to diagnose problem with special characters in a 'shellinabox' ssh login?
by Chris Green 19 Nov '11

19 Nov '11

I have set up shellinabox on my home system to allow me to connect from the web browser in my Amazon Kindle. I have it working OK to the extent that I can log in as a user whose password has no special characters in it, so the basic communications and connections are working. However my own password has non-alphanumeric characters in it and when I try and log in from the Kindle using shellinabox it always fails authentication. It fails if I log in directly or if I try and 'su -' from the login that I can do successfully. Logging in to shellinabox from Firefox works OK. So the Kindle->shellinabox connection is losing/changing something. When I type the non-alphanumeric characters in the working login they are echoed correctly so it's down to something in the interaction with login I think. Can anyone suggest a way of diagnosing this? -- Chris Green

1 1

Apache2 magic
by Barry Samuels 17 Nov '11

17 Nov '11

I have set up a second virtual site on my computer so that I can use www2 instead of www because that's already used and I want to keep it separate. I have a very simple html page in www2 and this is the exact code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  <html> <head> <title>6 Hour Live data usage</title> <meta http-equiv="refresh" content="10" > </head> <body> <img width="1250" height="800" src="/graphs/Power-6hr.png"> </body> </html> Notice the meta tag in the header which refreshes the page every 10 seconds. If I access this page with a web browser as a file i.e. file/// it works as expected, although I have to change the src= path to include / var/www2, but if I access it using http:// it doesn't update and if I use 'view/page source' I see that: <meta http-equiv="refresh" content="10" > has been replaced with: <link rev="x-refresh" href="" > Why should that happen? -- Barry Samuels http://www.beenthere-donethat.org.uk The Unofficial Guide to Great Britain

3 5

BOINC
by Chris Walker 14 Nov '11

14 Nov '11

I've recently installed (using the app manager and not by command line) the boinc program on my Mandriva machine but it's not connecting. I'm stuck now despite looking at the help pages. The manager program fires up and tried to connect to localhost and fails. If I click on the various tabs, it shows that 0 bytes of disc space are being used because it's not connected to any projects. But all the commands under the Projects tab are greyed out. So does anybody have any ideas where I'm going wrong please and what I need to to fix it? -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:cdw_alug@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|

1 0

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