Re: [SLUG] Case Study Speaker
Robert Collins wrote: On Mon, 2002-12-16 at 18:06, Bruce Badger wrote: Does anyone know of an open source system deployment within Australia, that would be a potential source of a speaker? The ideal would be finding someone who was on a project from evaluation through to deployment who could tell the tale. It would be even better if it were a happy tale. Any ideas? Depends on what 'system' you are looking for a speaker on. I could certainly put toghether a presentation on squid-in-a-commercial-setting. A probably a few different things (ie samba, mail-servers, IDS, mysql, ...) , if I put my mind to it. Could you be a little more specific on what you are trying to achieve with the presentation? (i.e. 'show my peers that it is possible for a business to take a thought out, risk-managing approach to a project, and still end up with an open-source tool/environment/package as part of the projects solution'). The ideal would be a speaker from some rather conservative type company (e.g. bank, insurance company). An employee who was there while a project happened, but who could not be accused of being an evangelist, or a vendor with a vested interest. It would be good, though, if the speaker knows how to give an interesting presentation :-) Stories like: "How we replaced all our web-edge system with OSS" "What benefits we saw in moving to a standards + OSS based mail solution" would be good. Does this help, Rob? Thanks, Bruce -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Case Study Speaker
On Mon, 2002-12-16 at 19:30, Bruce Badger wrote: > Robert Collins wrote: > >Could you be a little more specific on what you are trying to achieve > >with the presentation? (i.e. 'show my peers that it is possible for a > >business to take a thought out, risk-managing approach to a project, and > >still end up with an open-source tool/environment/package as part of the > >projects solution'). > > > The ideal would be a speaker from some rather conservative type company > (e.g. bank, insurance company). Ah. I know a few of those :}. I'm not sure if I know someone who is not an evangelist, and saw such a project go ahead though. > An employee who was there while a > project happened, but who could not be accused of being an evangelist, > or a vendor with a vested interest. It would be good, though, if the > speaker knows how to give an interesting presentation :-) Rules me out :[. It'd be very easy to accuse me of evangelical behaviour :}. > Stories like: > > "How we replaced all our web-edge system with OSS" > "What benefits we saw in moving to a standards + OSS based mail solution" > > would be good. > > Does this help, Rob? Yep :}. Hopefully someone on the list will meet both requirements :} (not evangelist, has seen such projects happen). Rob signature.asc Description: This is a digitally signed message part
[SLUG] prism2.5 pci wireless
Hi All, I have installed wireless cards in two of my servers and have them working with the orinoco_pci drivers with the 2.4.19 kernel. The problem is that I am getting the "Error -110 writing Tx descriptor to BAP" error, which from what I have read is caused by the orinoco drivers not working properly. This is ok, and I have read that the linux-wlan-ng drivers are better anyways, so I am attempting to get these working. I have installed the debian package, however from what I can see I still need to download the kernel source and compile the drivers with the linux-wlan-ng source?? Am I missing something?? I don't understand the point of the debian package if have to compile from source anyways? Any hints or directions would be greatly appreciated. Adam. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] prism2.5 pci wireless
Hello Adam, Depending what you wish to do, you could always use the hostap drivers and put the card into AP mode... iirc the wlan-ng drivers use a set of non-standard API's and HostAP drivers can put prism2/2.5/3 devices into client and ad hoc modes as well as AP mode... -- Best regards, evilbunnymailto:[EMAIL PROTECTED] Hey... it's me. http://www.cacert.org - Free Security Certificates http://www.nodedb.com - Think globally, network locally http://www.sydneywireless.com - Telecommunications Freedom Monday, December 16, 2002, 8:43:42 PM, you wrote: AH> Hi All, AH> I have installed wireless cards in two of my servers and have them working AH> with the orinoco_pci drivers with the 2.4.19 kernel. The problem is that I AH> am getting the "Error -110 writing Tx descriptor to BAP" error, which from AH> what I have read is caused by the orinoco drivers not working properly. AH> This is ok, and I have read that the linux-wlan-ng drivers are better AH> anyways, so I am attempting to get these working. I have installed the AH> debian package, however from what I can see I still need to download the AH> kernel source and compile the drivers with the linux-wlan-ng source?? Am I AH> missing something?? I don't understand the point of the debian package if AH> have to compile from source anyways? AH> Any hints or directions would be greatly appreciated. AH> Adam. smime.p7s Description: S/MIME Cryptographic Signature
[SLUG] RH7.3 + Gnome = X crashing
Does anyone have any clue as to what is wrong with my system? Or tips on further things to try. It is a new install on RH7.3 (standard disk) and X has been locking up suddenly (everything running on X seems to stop). I can ssh in from anoher machine. Top shows nothing doing anything (wget, rhn, etc were active). Forced to shutdown to recover the machine. -- Terry Collins {:-)}}} Ph(02) 4627 2186 Fax(02) 4628 7861 email: [EMAIL PROTECTED] www: http://www.woa.com.au Wombat Outdoor Adventures "People without trees are like fish without clean water" -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
[SLUG] YOUR DEARLY ASSISTANCE
Dear Sir, RE: YOUR ASSISTANCE I am the manager of bill and exchange at the foreign remittance department of the ECO BANK PLC LAGOS, NIGERIA. I am writing following the impressive information about you. I have the assurance that you are capable and reliable enough to champion an impending transaction. In my department, we discovered an abandoned sum of US$28.5m (twenty eight million and five hundred thousand US dollars), in an account that belonged to one of our former customers who died along with his entire family in a plane crash, in November, 1997. Since we received the information about his death, we have expected his next of kin to come forward and claim his money, as enshrined in our banking laws and regulations. So far nobody has come forward, and we cannot release the funds unless someone applies as the next of kin as stipulated in our guidelines. Unfortunately, we have discovered that all his supposed next of kin or relations died alongside with him in the plane crash, and effectively leaving nobody behind for the claim. It is consequent upon this discovery that other officials and I in my department decided to make this business proposal to you and release the money to you as the next of kin or relation of the deceased person, for safety and subsequent disbursement, since nobody is coming forward for it, and the money is not reverted into the banks treasury as unclaimed. The banks regulation stipulates that if after five years, such money remains unclaimed; the money will be reverted to the banks treasury as unclaimed fund. The request for a foreigner as the next of kin in this transaction is predicated upon the fact that the said customer was a foreign national, and no citizen of this country can claim to be the next of kin of a foreigner. We agree that 30% of the total sum we be given to you for your assistance in facilitating this transaction. My colleagues and I are going to retain 60% of the total sum, and 10% will be set aside for the expenses that we may incur in facilitating the remittance. To enable us effect this remittance, you must first apply as the next of kin of the deceased. Your application will include your bank co-ordinates, that is, your bank name, bank address and telex, your bank account. You will include your private telephone no. and fax no., for easy and effective communication during this process. My colleagues and I will visit your country for disbursement according to the agreed ratio, when this transaction is concluded. Upon the receipt of your response, I will send to you by fax, the text of the application. I must not fail to bring to your notice the fact that this transaction is hitch free, and that you should not entertain fear as you are adequately protected from any form of embarrassment Do respond to this letter today through my email address to enable us proceed with the transaction. Yours sincerely, MR. PETER OGALI. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] prism2.5 pci wireless
> Hello Adam, > > Depending what you wish to do, you could always use the hostap drivers > and put the card into AP mode... iirc the wlan-ng drivers use a set of > non-standard API's and HostAP drivers can put prism2/2.5/3 devices > into client and ad hoc modes as well as AP mode... >>prism2/2.5/3 devices Does this include the dlink 22mbps gear? -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re[2]: [SLUG] prism2.5 pci wireless
Hello Karl, >>>prism2/2.5/3 devices KB> Does this include the dlink 22mbps gear? No, the 22mbps or 11b+ gear is based on the TI ACX100 chipset... as such no currently known working drivers for anything but windows... -- Best regards, evilbunnymailto:[EMAIL PROTECTED] ABORT,RETRY, GET THE SHOTGUN AND SHOOT THE DAMNED THING http://www.cacert.org - Free Security Certificates http://www.nodedb.com - Think globally, network locally http://www.sydneywireless.com - Telecommunications Freedom smime.p7s Description: S/MIME Cryptographic Signature
Re: [SLUG] Question about text computer game from late seventies
On 16-Dec-2002 John Clarke wrote: > On Mon, Dec 16, 2002 at 04:47:19PM +1100, Ron Daniel wrote: >> Does anybody remember the name of the game which people used to play on >> their mainframes at university in the late seventies where you explored > > Advent? Also known as "Adventure" or "Colossal Cave". "You are in a > maze of twisty little passages, all alike". > > Source should be available at: > > ftp://ftp.wustl.edu/doc/misc/if-archive/games/source/advent.tar.Z Debianites can apt-get install bsdgames and run /usr/games/adventure. This is the 'classic' 350 point version. There is also a larger Colossal Cave, extant to my personal knowledge on Xerox mainframes in 1980, which has a different endgame, expanded dungeon and a 550 point maximum score. There was a Unix port of that around as well, probably still sitting on a 5.25" floppy in my attic. Level9 (remember them?) did a differently-extended version for 8 bit micros (BBC, Spectrum etc.) in the later 80s. And there's also Zork. Zork was clearly inspired by Crowther & Woods original Colossal Cave, but went futher. If you're in a maze and some sod keeps nicking the stuff you drop to disambiguate the rooms, that's Zork. Zork was commercialised by Infocom, and with the aid of a z-code interpreter like Frotz you can play Zork I - the z-code was published as a freebie a few years ago. -- Jim Hague - [EMAIL PROTECTED] (Work), [EMAIL PROTECTED] (Play) Never trust a computer you can't lift. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Woody on Spac64
On 12-Dec-2002 Colin Humphreys wrote: > I have never installed woody onto a sparc box directly. I have allways > dist-upgrade from potato. I have an Ultra 2 lying round here, so I > just tried booting a potato (2.2r3) cd on it: Try checking the Debian-Sparc mailing list archives. There was a time not so long ago when the Woody installer was known broken, and installing Potato first and then upgrading was the recommended way to go. You never know, but that may still be the case. This 'ere Ultra5 is living dangerously on Sid. -- Jim Hague - [EMAIL PROTECTED] (Work), [EMAIL PROTECTED] (Play) Never trust a computer you can't lift. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
[SLUG] problems with compiling htmldoc-1.8.23
Hi Craige, I can't build "htmldoc-1.8.23". Some one said you can help me out. I got followingerr when I build it. what did I do wrong?f:\htmldoc-1.8.23\htmldoc\http.c(279): error C2065: 'SSL_CTX' : undeclaredidentifierf:\htmldoc-1.8.23\htmldoc\http.c(279): error C2065: 'context' : undeclaredidentifierf:\htmldoc-1.8.23\htmldoc\http.c(279): warning C4552: '*' : operator has noeffect; expected operator with side-effectf:\htmldoc-1.8.23\htmldoc\http.c(280): error C2065: 'SSL' : undeclaredidentifierf:\htmldoc-1.8.23\htmldoc\http.c(280): error C2065: 'conn' : undeclaredidentifierf:\htmldoc-1.8.23\htmldoc\http.c(280): warning C4552: '*' : operator has noeffect; expected operator with side-effectf:\htmldoc-1.8.23\htmldoc\http.c(290): error C2059: syntax error : ')'f:\htmldoc-1.8.23\htmldoc\http.c(315): error C2143: syntax error : missing'{' before '*'f:\htmldoc-1.8.23\htmldoc\http.c(318): error C2371: 'httpConnect' :redefinition; different basic types f:\htmldoc-1.8.23\htmldoc\http.h(291) : see declaration of'httpConnect'f:\htmldoc-1.8.23\htmldoc\http.c(331): warning C4133: 'return' :incompatible types - from 'http_t *' to 'int *'f:\htmldoc-1.8.23\htmldoc\http.c(463): warning C4552: '*' : operator has noeffect; expected operator with side-effectf:\htmldoc-1.8.23\htmldoc\http.c(464): warning C4552: '*' : operator has noeffect; expected operator with side-effectf:\htmldoc-1.8.23\htmldoc\http.c(469): error C2059: syntax error : ')'f:\htmldoc-1.8.23\htmldoc\http.c(579): warning C4047: '=' : 'void *' differsin levels of indirection from 'int'f:\htmldoc-1.8.23\htmldoc\http.c(1137): error C2059: syntax error : ')'Roman
[SLUG] OT orders from England
Does anyone know how long it takes for packages to arrive from England? Thanks Kevin -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] problems with compiling htmldoc-1.8.23
On Mon, Dec 16, 2002 at 12:25:01PM -0800, Henry wrote: > Hi Craige, > > I can't build "htmldoc-1.8.23". Some one said you can help me out. I got following > err when I build it. what did I do wrong? > > f:\htmldoc-1.8.23\htmldoc\http.c(279): error C2065: 'SSL_CTX' : undeclared > identifier Hey, don't call me Craige! Loks like you need the openssl headers. Matt -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] prism2.5 pci wireless
We had exactly the same problem. 2.4.20 fixed it. We had to download and compile the kernel ourselves but it seemed to work fine. dave - Original Message - From: "Adam Hewitt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 8:43 PM Subject: [SLUG] prism2.5 pci wireless > Hi All, > > I have installed wireless cards in two of my servers and have them working > with the orinoco_pci drivers with the 2.4.19 kernel. The problem is that I > am getting the "Error -110 writing Tx descriptor to BAP" error, which from > what I have read is caused by the orinoco drivers not working properly. > > This is ok, and I have read that the linux-wlan-ng drivers are better > anyways, so I am attempting to get these working. I have installed the > debian package, however from what I can see I still need to download the > kernel source and compile the drivers with the linux-wlan-ng source?? Am I > missing something?? I don't understand the point of the debian package if > have to compile from source anyways? > > Any hints or directions would be greatly appreciated. > > Adam. > > > -- > SLUG - Sydney Linux User's Group - http://slug.org.au/ > More Info: http://lists.slug.org.au/listinfo/slug > -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] OT orders from England
Hmmm... Last time I ordered some radio gear from the UK, it took about 3 weeks by low-altitude carrier-pidgeon.. Depends on the size and how it was sent, although this time of year it's likely to be longer... I've had software from germany (ApplixWare) take 5 weeks, and I've had stuff from Norway take 4 days... When was it sent and how ? => -Original Message- => From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] => On Behalf Of Kevin Saenz => Sent: Tuesday, 17 December 2002 7:33 AM => To: [EMAIL PROTECTED] => Subject: [SLUG] OT orders from England => => => Does anyone know how long it takes for packages to arrive => from England? => => Thanks => => Kevin => => => => -- => SLUG - Sydney Linux User's Group - http://slug.org.au/ => More Info: http://lists.slug.org.au/listinfo/slug => -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Question about text computer game from late seventies/eighties
On 16 Dec 2002 at 16:47, Ron Daniel wrote: > Does anybody remember the name of the game which people used to play > on their mainframes at university in the late seventies where you > explored a labyrinth of caves and tunnels interactively on a teletype > machine? > Known variously as "rogue" or "hack" -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Question about text computer game from late seventies/eighties
On Tue, Dec 17, 2002 at 10:52:11AM +1000, [EMAIL PROTECTED] wrote: > On 16 Dec 2002 at 16:47, Ron Daniel wrote: > > > Does anybody remember the name of the game which people used to play > > on their mainframes at university in the late seventies where you > > explored a labyrinth of caves and tunnels interactively on a teletype > > machine? > > > Known variously as "rogue" or "hack" You'd have a tough time playing hack/rogue on a real teletype. The answer is, I believe, adventure aka colossal cave aka advent aka dungeon, a direct linear ancestor of the classic text game zork. Takes me back! I used to sneak in to the computer labs at unsw late at night to play it on the pdp11's using my brothers account. Ah those were the days. Amazing how engrossed you can get with just text on a greenscreen accompanied by the occasional soft feep. Matt jargon file entries: advent: http://www.tuxedo.org/~esr/jargon/html/entry/ADVENT.html pdp10: http://www.tuxedo.org/~esr/jargon/html/entry/PDP-10.html zork: http://www.tuxedo.org/~esr/jargon/html/entry/Zork.html feep: http://www.tuxedo.org/~esr/jargon/html/entry/feep.html -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] RH7.3 + Gnome = X crashing
On Tue, 2002-12-17 at 18:57, Terry Collins wrote: > It is a new install on RH7.3 (standard disk) and X has been locking up > suddenly (everything running on X seems to stop). I can ssh in from > anoher machine. Top shows nothing doing anything (wget, rhn, etc were > active). Forced to shutdown to recover the machine. Was X working before on this installation? Have you looked through the X log in /var/log/XFree86.0.log? That should contain some clues for you. -- ** * Simon Wong * ** -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Learning about security.
On Mon, 2002-12-16 at 13:47, Steve Downing wrote: > Also, can anyone recommend any good 'across the board' security books, > i.e covering the other major OS(es) as well? Typical attacks, how > to avoid them and system design/implementation considerations? "Hacking > Exposed" has been touted as one option. Opinions? I have the "Hacking Linux Exposed" book and found it good. The only problem is that it makes you *paranoid* :-( -- ** * Simon Wong * ** -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Woody on Spac64
Going to try this when I get my next 3G of bandwidth from Telstra next month. - Original Message - From: Jim Hague <[EMAIL PROTECTED]> Date: Tuesday, December 17, 2002 3:47 am Subject: Re: [SLUG] Woody on Spac64 > On 12-Dec-2002 Colin Humphreys wrote: > > I have never installed woody onto a sparc box directly. I have > allways > > dist-upgrade from potato. I have an Ultra 2 lying round here, so I > > just tried booting a potato (2.2r3) cd on it: > > Try checking the Debian-Sparc mailing list archives. There was a > time not so > long ago when the Woody installer was known broken, and installing > Potato first > and then upgrading was the recommended way to go. > > You never know, but that may still be the case. > > This 'ere Ultra5 is living dangerously on Sid. > > -- > Jim Hague - [EMAIL PROTECTED] (Work), [EMAIL PROTECTED] (Play) > Never trust a computer you can't lift. > -- > SLUG - Sydney Linux User's Group - http://slug.org.au/ > More Info: http://lists.slug.org.au/listinfo/slug > -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] cdroast track problem
On Mon, 2002-12-16 at 12:49, David wrote: > Is this a cd player problem or an x-cd-roast problem? > > x-cd-roast 0.98alpha9 running on woody using a "liteon" 48 times burner > running at 32 times. I've also tried it at 16 times, but that makes no > difference. The speed shouldn't be a problem. Try using cdda2wav to retrieve the contents of the CD - then you can look at whether it's reading that okay (man cdda2wav). -- ** * Simon Wong * ** -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
[SLUG] SMS
hi is it possible to send sms messages to a phone off my home pc without having to connect to the internet? I have an internal modem but no phone line pls reply because ive heard it is possible but i dont know how/where to get it from cheers _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] SMS
Hello Richard, There is a telstra number you can dial, and a vodaphone one, i think the telstra number will deliver to all numbers... -- Best regards, evilbunnymailto:[EMAIL PROTECTED] Sir,with the utmost respect,that is complete and utter shash. --Kryten http://www.cacert.org - Free Security Certificates http://www.nodedb.com - Think globally, network locally http://www.sydneywireless.com - Telecommunications Freedom Tuesday, December 17, 2002, 12:36:12 PM, you wrote: >>hi is it possible to send sms messages to a phone off my home pc without >>having to connect to the internet? I have an internal modem but no phone >>line >> >>pls reply because ive heard it is possible but i dont know how/where to >>get it from cheers RR> _ RR> STOP MORE SPAM with the new MSN 8 and get 2 months FREE* RR> http://join.msn.com/?page=features/junkmail smime.p7s Description: S/MIME Cryptographic Signature
Re: [SLUG] SMS
Richard Rooke wrote: hi is it possible to send sms messages to a phone off my home pc without having to connect to the internet? I have an internal modem but no phone line pls reply because ive heard it is possible but i dont know how/where to get it from cheers Well, there is equipment that will let your PC appear as a phone on the mobile phone network. They are like modems in many ways (I don't know if they modulate/demodulate over analog or just transmit digitally), but they are not cheap, and you'd still need an account with a phone company and a SIM. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Question about text computer game from late seventies/eighties
> "russell" == russell ashdown <[EMAIL PROTECTED]> writes: russell> On 16 Dec 2002 at 16:47, Ron Daniel wrote: >> Does anybody remember the name of the game which people used to >> play on their mainframes at university in the late seventies where >> you explored a labyrinth of caves and tunnels interactively on a >> teletype machine? >> russell> Known variously as "rogue" or "hack" No rogue and hack work only on glass ttys --- they use character graphics and the curses package to draw the maze on-screen. Peter C -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Question about text computer game from late seventies/eighties
--- Ron Daniel <[EMAIL PROTECTED]> wrote: > Does anybody remember the name of the game which people used to play > on > their mainframes at university in the late seventies where you > explored > a labyrinth of caves and tunnels interactively on a teletype machine, > usually resulting in demise by some foul or painful process often > involving a creature that you were certain was not around that corner > the first time you looked ? If you're looking for 'Colossal Cave Adventure', try here: http://www.rickadams.org/adventure/ (And watch out for the dwarf!) > involving a creature that you were certain was not around that corner > the first time you looked ? That sounds like 'hunt the wumpus' to me, a much simpler game. As already posted, if you're a Debian user then they're in the wonderful 'bsdgames' package. - mark = mark a. bell http://www.users.bigpond.com/m487396 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
[SLUG] fustrations with mysql (TIMESTAMP)
Afternoon, I've been trying (keyword trying) to attempt to use a field in mysql to record the time at which a record is created in a table. ie; -- snip -- created TIMESTAMP(14) default NULL, -- snip -- However when I submit my data into the table/fields, without success I can never get the field "created" to have the timestamp 'MMDDHHMMSS' at which it was entered. ie. -- snip -- INSERT INTO blah VALUES( 'blah','blah',''); -- snip -- I've tried '', '\n' and 'NOW()' all without success. Can anyone put me out of my misery and solve this for me, as I've read and read yet still can't get something to work. Thanks -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, 2002-12-17 at 15:21, Michael Fox wrote: > Afternoon, > > I've been trying (keyword trying) to attempt to use a field in mysql to record > the time at which a record is created in a table. > The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: * The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. * The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) * You explicitly set the TIMESTAMP column to NULL. http://www.mysql.com/doc/en/DATETIME.html Hopefully this should help in your quest. Greeno -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
Quoting Tony Green <[EMAIL PROTECTED]>: > > The TIMESTAMP column type provides a type that you can use to > automatically mark INSERT or UPDATE operations with the current date > and > time. If you have multiple TIMESTAMP columns, only the first one is > updated automatically. > > Automatic updating of the first TIMESTAMP column occurs under any of > the > following conditions: > > * The column is not specified explicitly in an INSERT or LOAD > DATA > INFILE statement. > * The column is not specified explicitly in an UPDATE statement > and some other column changes value. (Note that an UPDATE that > sets a column to the value it already has will not cause the > TIMESTAMP column to be updated, because if you set a column to > its current value, MySQL ignores the update for efficiency.) > * You explicitly set the TIMESTAMP column to NULL. > > > http://www.mysql.com/doc/en/DATETIME.html > > Hopefully this should help in your quest. Ahuh, and I've read it along with many other pages from /doc/en/ As I said, still having problems. Might just drop this field, and figure it out another time. At the end of the day I am just writing something to learn from. Since I've wanted to do some more mysql/php mucking about. Cheers -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, 2002-12-17 at 15:32, Michael Fox wrote: > > Ahuh, and I've read it along with many other pages from /doc/en/ > > As I said, still having problems. > > Might just drop this field, and figure it out another time. At the end of the > day I am just writing something to learn from. Since I've wanted to do some > more mysql/php mucking about. Your using 'INSERT INTO blah VALUES( 'blah','blah','');' and it doesn't work. Try 'INSERT INTO blah VALUES( 'blah','blah',NULL);' and see if you get any better results. Maybe way off, but I don't think '' and NULL are the same thing (but its been a while since I played DBA - they wouldn't let me once they found out my parents were married) Greeno /me runs -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, 2002-12-17 at 04:21, Michael Fox wrote: > Can anyone put me out of my misery and solve this for me, as I've read and > read yet still can't get something to work. Unlike PostgreSQL, MySQL does not have this functionality. The keyword you're looking for is probably CURRENT_DATE (or CURRENT_TIME or something similar), but you can't set it as a default. I have spent conclusively too much of my time attempting to wrap database functionality in my code so it can run on MySQL. This was one of the many problems. The best thing I could do was to get the wrapper to set the value CURRENT_DATE if the field was called "createdate" and no other value was set for that field (it's code which amongst other things takes a hash of data and puts it in the database. It knows what fields are in the table.). note: there is probably a way to make it do it by building in one of the many bizarro "options" that mysql has these days. That's not such a good answer though, because it will make your code less portable. HTH James. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, 2002-12-17 at 04:41, Tony Green wrote: > On Tue, 2002-12-17 at 15:32, Michael Fox wrote: > > > > Ahuh, and I've read it along with many other pages from /doc/en/ > > > > As I said, still having problems. > > > > Might just drop this field, and figure it out another time. At the end of the > > day I am just writing something to learn from. Since I've wanted to do some > > more mysql/php mucking about. > > > Your using 'INSERT INTO blah VALUES( 'blah','blah','');' and it doesn't > work. Try 'INSERT INTO blah VALUES( 'blah','blah',NULL);' and see if > you get any better results. I've also had issues with it, but if you want it to try it then specifying a value for it won't let it set it itself. If it is going to work, the way to do it will be to not specify that field at all in your list of fields to insert into. It's supposed to operate like a default value essentially. If you specify something else it will use that. both NULL and the empty string are "something". James. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
Quoting Tony Green <[EMAIL PROTECTED]>: > > Your using 'INSERT INTO blah VALUES( 'blah','blah','');' and it > doesn't > work. Try 'INSERT INTO blah VALUES( 'blah','blah',NULL);' and see if > you get any better results. > > Maybe way off, but I don't think '' and NULL are the same thing (but > its > been a while since I played DBA - they wouldn't let me once they found > out my parents were married) Yes, tried both previously. From what I read they are both NULL equal. I also read \n was too. But they all make no difference. Oh well I might implement it another way. No big deal after all. Thanks -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] fustrations with mysql (TIMESTAMP)
I've found in general the default values are only applied if you attempt to insert without even mentioning the things that you want to take on default values. This is pretty much what James says. eg (this is a table of engineering drawing issues): INSERT INTO dwg_issue (id, dwgissue) VALUES (NULL, "A01"); In this case I'm making a new record and only specifying one value. All other column values in this record (if it has any) should take on default values, if specified as such when the table was created. BUT! Timestamp may be a special case. Cheers, Jill. -- Jill Rowling, System Administrator Eng. Systems Dept, Aristocrat Technologies Australia Level 2, 55 Mentmore Ave Rosebery NSW 2018 Phone: (02) 9697-4484 Fax: (02) 9663-1412 Email: [EMAIL PROTECTED] -Original Message- From: James Gregory [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 December 2002 2:51 To: Tony Green Cc: Michael Fox; [EMAIL PROTECTED] Subject: Re: [SLUG] fustrations with mysql (TIMESTAMP) On Tue, 2002-12-17 at 04:41, Tony Green wrote: > On Tue, 2002-12-17 at 15:32, Michael Fox wrote: > > > > Ahuh, and I've read it along with many other pages from /doc/en/ > > > > As I said, still having problems. > > > > Might just drop this field, and figure it out another time. At the end of the > > day I am just writing something to learn from. Since I've wanted to do some > > more mysql/php mucking about. > > > Your using 'INSERT INTO blah VALUES( 'blah','blah','');' and it doesn't > work. Try 'INSERT INTO blah VALUES( 'blah','blah',NULL);' and see if > you get any better results. I've also had issues with it, but if you want it to try it then specifying a value for it won't let it set it itself. If it is going to work, the way to do it will be to not specify that field at all in your list of fields to insert into. It's supposed to operate like a default value essentially. If you specify something else it will use that. both NULL and the empty string are "something". James. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug -- IMPORTANT NOTICES This email (including any documents referred to in, or attached, to this email) may contain information that is personal, confidential or the subject of copyright or other proprietary rights in favour of Aristocrat, its affiliates or third parties. This email is intended only for the named addressee. Any privacy, confidence, copyright or other proprietary rights in favour of Aristocrat, its affiliates or third parties, is not lost because this email was sent to you by mistake. If you received this email by mistake you should: (i) not copy, disclose, distribute or otherwise use it, or its contents, without the consent of Aristocrat or the owner of the relevant rights; (ii) let us know of the mistake by reply email or by telephone (+61 2 9413 6300); and (iii) delete it from your system and destroy all copies. Any personal information contained in this email must be handled in accordance with applicable privacy laws. Electronic and internet communications can be interfered with or affected by viruses and other defects. As a result, such communications may not be successfully received or, if received, may cause interference with the integrity of receiving, processing or related systems (including hardware, software and data or information on, or using, that hardware or software). Aristocrat gives no assurances in relation to these matters. If you have any doubts about the veracity or integrity of any electronic communication we appear to have sent you, please call +61 2 9413 6300 for clarification. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, Dec 17, 2002 at 03:51:03PM +, James Gregory wrote: > If it is going to work, the way to do it will be to not specify that > field at all in your list of fields to insert into. It's supposed to > operate like a default value essentially. If you specify something else > it will use that. both NULL and the empty string are "something". If I'm not completely mistaken, NULL is as close to nothing that you're going to get. The SQL standard doesn't really allow missing values -- if you leave a value out of an insert statement you will get NULL values, a user specified default, or an error. What this means for MySQL ... I dunno. Also FWIW, putting things like CURRENT_TIME in tables is fairly brittle -- think of what happens at daylight saving time or when the time on your pc goes haywire. Bad things happen to your data. What you're usually after is a "guaranteed to be greater" value. With postgresql/oracle you'd use nextval(). http://www.au.postgresql.org/docs/faq-english.html#4.15.3 Again, I'm a little ignorant of mysql. Does it have this? Matt -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, Dec 17, 2002 at 03:51:03PM +, James Gregory wrote: > On Tue, 2002-12-17 at 04:41, Tony Green wrote: > > Your using 'INSERT INTO blah VALUES( 'blah','blah','');' and it doesn't > > work. Try 'INSERT INTO blah VALUES( 'blah','blah',NULL);' and see if > > you get any better results. > > I've also had issues with it, but if you want it to try it then > specifying a value for it won't let it set it itself. > > If it is going to work, the way to do it will be to not specify that > field at all in your list of fields to insert into. It's supposed to > operate like a default value essentially. If you specify something else > it will use that. both NULL and the empty string are "something". Nope, that's wrong. Not inserting the field OR inserting NULL are equivalent for timestamps - both set it to the current time. But '' and '\n' won't work - you have to use NULL proper. I've never had any problems like this with timestamps. What version are you using Michael? You're absolutely sure you're inserting null and not a quoted 'null'? Cheers, Gavin -- Open Fusion P/L - Open Source Business Solutions [ Linux - Perl - Apache ] http://www.openfusion.com.au - Fashion is a variable, but style is a constant - Programming Perl -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
> Also FWIW, putting things like CURRENT_TIME in tables is fairly brittle -- > think of what happens at daylight saving time or when the time on your pc > goes haywire. Bad things happen to your data. Times are usually stored in UTC, so daylight savings and timezone won't come into it. Having your clock working correctly is pretty fundamental to a lot of things, so that *shoudn't* come into it. ;-) > What you're usually after is a "guaranteed to be greater" value. With > postgresql/oracle you'd use nextval(). Only if it's a key of sorts (for which time/date fields are terrible choices). If someone wants the actual time, they really do want the actual time! (I'd add myself to the "strongly recommend PostgreSQL" list, too.) - Jeff -- "How was the opera?" "The seats were very comfortable." -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] fustrations with mysql (TIMESTAMP)
Quoting "Rowling, Jill" <[EMAIL PROTECTED]>: > I've found in general the default values are only applied if you attempt > to > insert without even mentioning the things that you want to take on > default > values. This is pretty much what James says. > > eg (this is a table of engineering drawing issues): > INSERT INTO dwg_issue (id, dwgissue) VALUES (NULL, "A01"); > > In this case I'm making a new record and only specifying one value. > All > other column values in this record (if it has any) should take on > default > values, if specified as such when the table was created. > BUT! Timestamp may be a special case. > Big Thanks to you Jill. I tried your suggestion, by using similar syntax. And it worked. Many thanks once more. By describing my fields first and then values... (excluding my created column) it inputs the creation timestamp as requested). woohoo :) -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
On Tue, Dec 17, 2002 at 04:22:34PM +1100, Jeff Waugh wrote: > Times are usually stored in UTC, so daylight savings and timezone won't come > into it. Having your clock working correctly is pretty fundamental to a lot > of things, so that *shoudn't* come into it. ;-) Doesn't stop a surprisingly high number of, say, messages to the slug list coming from the future! > > What you're usually after is a "guaranteed to be greater" value. With > > postgresql/oracle you'd use nextval(). > > Only if it's a key of sorts (for which time/date fields are terrible > choices). If someone wants the actual time, they really do want the actual > time! Yeah, fair enough. You'd want to make sure it's UTC. You might add the sequential value anyway as a safety check. > (I'd add myself to the "strongly recommend PostgreSQL" list, too.) If only it was a little easier to set up and use... Matt -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
> > (I'd add myself to the "strongly recommend PostgreSQL" list, too.) > > If only it was a little easier to set up and use... I guess it depends on your distributor. My experience on Red Hat and Debian has only been positive. It *really* helps if you're familiar with real RDBMS systems too, especially Oracle (though curious and non-brain-lazy MSSQL converts will feel pretty comfortable too). - Jeff -- o/~ In spite of all those keystrokes, you're addicted to vim. *ka-ching!* o/~ -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Question about text computer game from late seventies
On Mon, 16 Dec 2002, Jim Hague wrote: > On 16-Dec-2002 John Clarke wrote: > > On Mon, Dec 16, 2002 at 04:47:19PM +1100, Ron Daniel wrote: > >> Does anybody remember the name of the game which people used to play on > >> their mainframes at university in the late seventies where you explored > > > > Advent? Also known as "Adventure" or "Colossal Cave". "You are in a > > maze of twisty little passages, all alike". > > > > Source should be available at: > > > > ftp://ftp.wustl.edu/doc/misc/if-archive/games/source/advent.tar.Z > > Debianites can apt-get install bsdgames and run /usr/games/adventure. This is > the 'classic' 350 point version. While present on bsd systems, it might interest people to know that this game pre-dates Unix. It was written at Stanford in 1968. Andrew -- Andrew McNaughton In Sydney and looking for work [EMAIL PROTECTED] http://staff.scoop.co.nz/andrew/cv.doc Mobile: +61 422 753 792 -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] fustrations with mysql (TIMESTAMP)
My two cents: 1c) NULL is a state not a value. '' and NULL are _NOT_ the same. Hence you have SELECT blah blah... WHERE IS/IS NOT NULL instead of WHERE =/!= NULL. 2c) You might want to have a look at Firebird (Borland's Interbase reincarnated as Open Source) http://www.firebirdsql.org. It is a more complete RDMS than MySql, smaller and maybe easier to use than PostgreSql. Regards -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: Re: [SLUG] cdroast track problem
I don't have Debian "Woody" installed, but I've been using Knoppix (DEbian 3.0 based) - bootable CD - and have had great success using the included CDBakeOven for burning iso's and copying CDs. Bill [EMAIL PROTECTED] -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] Question about text computer game from late seventies
My understanding is it was originally written in FORTRAN. The spring, dry creek and cave entrance area are based on the map of a real cave up to about where you find the bird cage and the stairs, and "degenerates" from there on into fantasy. I used to play it on CP/M. FWIW there are some real caves with mazes of twisty little passages all the same. Fortunately, compasses work underground in limestone! Cheers, Jill. -- Jill Rowling, System Administrator Eng. Systems Dept, Aristocrat Technologies Australia Level 2, 55 Mentmore Ave Rosebery NSW 2018 Phone: (02) 9697-4484 Fax: (02) 9663-1412 Email: [EMAIL PROTECTED] -Original Message- From: Andrew McNaughton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 December 2002 18:14 To: Jim Hague Cc: John Clarke; [EMAIL PROTECTED] Subject: Re: [SLUG] Question about text computer game from late seventies On Mon, 16 Dec 2002, Jim Hague wrote: > On 16-Dec-2002 John Clarke wrote: > > On Mon, Dec 16, 2002 at 04:47:19PM +1100, Ron Daniel wrote: > >> Does anybody remember the name of the game which people used to play on > >> their mainframes at university in the late seventies where you explored > > > > Advent? Also known as "Adventure" or "Colossal Cave". "You are in a > > maze of twisty little passages, all alike". > > > > Source should be available at: > > > > ftp://ftp.wustl.edu/doc/misc/if-archive/games/source/advent.tar.Z > > Debianites can apt-get install bsdgames and run /usr/games/adventure. This is > the 'classic' 350 point version. While present on bsd systems, it might interest people to know that this game pre-dates Unix. It was written at Stanford in 1968. Andrew -- Andrew McNaughton In Sydney and looking for work [EMAIL PROTECTED] http://staff.scoop.co.nz/andrew/cv.doc Mobile: +61 422 753 792 -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug -- IMPORTANT NOTICES This email (including any documents referred to in, or attached, to this email) may contain information that is personal, confidential or the subject of copyright or other proprietary rights in favour of Aristocrat, its affiliates or third parties. This email is intended only for the named addressee. Any privacy, confidence, copyright or other proprietary rights in favour of Aristocrat, its affiliates or third parties, is not lost because this email was sent to you by mistake. If you received this email by mistake you should: (i) not copy, disclose, distribute or otherwise use it, or its contents, without the consent of Aristocrat or the owner of the relevant rights; (ii) let us know of the mistake by reply email or by telephone (+61 2 9413 6300); and (iii) delete it from your system and destroy all copies. Any personal information contained in this email must be handled in accordance with applicable privacy laws. Electronic and internet communications can be interfered with or affected by viruses and other defects. As a result, such communications may not be successfully received or, if received, may cause interference with the integrity of receiving, processing or related systems (including hardware, software and data or information on, or using, that hardware or software). Aristocrat gives no assurances in relation to these matters. If you have any doubts about the veracity or integrity of any electronic communication we appear to have sent you, please call +61 2 9413 6300 for clarification. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] fustrations with mysql (TIMESTAMP)
Jeff Waugh said: > > > (I'd add myself to the "strongly recommend PostgreSQL" list, too.) > > If only it was a little easier to set up and use... > I guess it depends on your distributor. My experience on Red Hat and Debian > has only been positive. It *really* helps if you're familiar with real RDBMS > systems too, especially Oracle (though curious and non-brain-lazy MSSQL > converts will feel pretty comfortable too). I've never liked postgreSQL, always used mysql and I guess its stuck ever since. As for oracle, use that most days at work, along with informix. Cheers -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: [SLUG] fustrations with mysql (TIMESTAMP)
> My two cents: > > 1c) NULL is a state not a value. '' and NULL are _NOT_ the > same. Hence you > have SELECT blah blah... WHERE IS/IS NOT NULL instead > of WHERE > =/!= NULL. > > 2c) You might want to have a look at Firebird (Borland's Interbase > reincarnated as Open Source) http://www.firebirdsql.org. It is a more > complete RDMS than MySql, smaller and maybe easier to use > than PostgreSql. Thanks for your 3 cents worth *smirks* Will check out borlands product, however I suspect I'll be sticking with mysql for now. Cheers -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
RE: Re: [SLUG] cdroast track problem
> I don't have Debian "Woody" installed, but I've been using > Knoppix (DEbian > 3.0 based) - bootable CD - and have had great success using > the included > CDBakeOven for burning iso's and copying CDs. Yeah the bootable knoppix cd is nice. Must remember to borrow it again from my mate at work. - Michael -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug