- main - earth.li

Samba Printing
by Matt Parker 23 Nov '04

23 Nov '04

I'm currently working onsite at a client and I need to be able to connect my Linux laptop to their printer. Unfortunately it's a Windows share and the printer name contains spaces - which Samba absolutely refuses to connect to. I've Googled around on this but can't find a workaround. Changing the printer name is absolutely out of the question. Are there any experts here who have any tips to try in this situation? Matt

2 1

RE: [ALUG] Running total from a database table - how?
by Keith Watson 22 Nov '04

22 Nov '04

> From: Chris Green Sent: 22 November 2004 13:40 > > I'm steadily progressing with my conversion of my Access accounting > system to a Linux based system. > > I've moved from using mysql to postgresql which has made a few things > easier by having VIEWs in the database. > > Rekall seems to have most of what I need on the forms and reports > front except for one thing - I can't see how to implement a 'running > total' column. > > The Access97 report tool has a specific 'running total' column type > which does exactly what I need. Rekall doesn't have anything like > this (that I can see). > > Has anyone got any bright ideas of how I can do this, it's rather > vital on things like a Bank Reconciliation report to enable me to > check my accounts against the bank statement. > > -- > Chris Green (chris(a)areti.co.uk) > can you give a specific example as 'running total' covers a lot of ground :o) Regards, Keith ____________ Whatever thou sayest of God is untrue. - Meister Eckhart

4 6

RE: [ALUG] Re: Running total from a database table - how?
by Keith Watson 22 Nov '04

22 Nov '04

Works for me! :o) Regards, Keith ____________ Sometimes the highest form of action is inaction. - Jerry Brown > -----Original Message----- > From: main-admin(a)lists.alug.org.uk > [mailto:main-admin@lists.alug.org.uk]On Behalf Of Brett Parker > Sent: 22 November 2004 16:48 > To: main(a)lists.alug.org.uk > Subject: Re: [ALUG] Re: Running total from a database table - how? > > > On Mon, Nov 22, 2004 at 04:17:56PM +0000, Chris Green wrote: > > Yes, of course, I want a report that looks like:- > > > > Date Description Amount Balance > > 01/09/04 Initial balance +1000.00 1000.00 > > 03/09/04 Stamps -14.58 985.42 > > 06/09/04 Network Card -9.99 975.43 > > 12/09/04 Interest +0.10 975.53 > > date | description | amount | balance > ----------------------------+------------------+---------+--------- > 2004-11-22 16:39:52.046068 | Starting Balance | 1000.00 | 1000.00 > 2004-11-22 16:40:11.58727 | Booze | -50.00 | 950.00 > 2004-11-22 16:40:30.539512 | Poker Winnings | 50.00 | 1000.00 > 2004-11-22 16:40:59.067902 | CD | -10.99 | 989.01 > > > > It's a little more complicated than the above but that shows the > > essentials. (I don't guarantee my arithmetic is correct) > > > The Date, Description and Amount columns are directly from > a database > > table. The Balance column needs to ba calculated as the report is > > created. > > Yup, that's how that's done... Here's the *MAGIC* ;) > > create view testwithrunningtotal as select > date,description,amount,(select sum(amount) from test as > test2 where test2.date <= test.date) as balance from test > order by date; > > select * from testwithrunningtotal; > > > OK - so it's not pretty, but it does appear to work ;) > Obviously, if you're not > really using timestamps, like I was, and you can *assume* > that your IDs are in > the right order, then sort by those for the subselect. > > If you need to be able to 'mess' with this, then you'll also > need to set up > some insert and delete rules on the view, probably ;) > > Cheers, > -- > Brett Parker > web: http://www.sommitrealweird.co.uk/ > email: iDunno(a)sommitrealweird.co.uk > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above! >

1 0

Running total from a database table - how?
by Chris Green 22 Nov '04

22 Nov '04

I'm steadily progressing with my conversion of my Access accounting system to a Linux based system. I've moved from using mysql to postgresql which has made a few things easier by having VIEWs in the database. Rekall seems to have most of what I need on the forms and reports front except for one thing - I can't see how to implement a 'running total' column. The Access97 report tool has a specific 'running total' column type which does exactly what I need. Rekall doesn't have anything like this (that I can see). Has anyone got any bright ideas of how I can do this, it's rather vital on things like a Bank Reconciliation report to enable me to check my accounts against the bank statement. -- Chris Green (chris(a)areti.co.uk) "Never ascribe to malice, that which can be explained by incompetence."

1 0

RE SUSE Network problem
by RICHARD FLETCHER 22 Nov '04

22 Nov '04

Thanks for the replies helping me to sort out this problem. few answers to questions asked. While the reinstall goes on! ( going to look at the SAMBA config files before i start the samba server this time. see if anything changes in there. slow way of doing things but i'm learning all the time! when i tried to find other computers with smb://IP, konquorer just sat there and did nothing for a while and then came back with the same message. (network unreachable) (found the "internet server" though with its static IP) my apologies to not getting back Laurie: >Check DNS, dhcp and WINS. >Do smbclient and/or smbmount work? If not, what are the synptoms? being the floundering newbie that i said i was this made my head pop! i did have a look in the control centre and alas "play with" (not check) dchp, DNS and wins. For some reason this killed konquorer and my ability to browse anything including email :-( hence the reinstall (getting really good at that now!). smbclient/smb mount will take some more investigation by me as i dont know what to do with them (I assume they are console commands). might be up and running this afternoon with a fresh beast to slaughter. I somehow think that i'll be back with other symptoms later. thankyou all for now i'll be in touch..... Fletch. ___________________________________________________________ Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k

1 0

SUSE 9.1 SAMBA NETWORK ERROR.
by RICHARD FLETCHER 22 Nov '04

22 Nov '04

This is probably a really simple one but as a floundering newbie, I is really stuck now. I'm was running SUSE 9.1 after a fresh install and all was OK. The install included ALL available packages that came with SUSE 9.1. My Linux box was the only one in a sea of Win XP machines on our network but I was able to see them and browse their shares with confidence using konqueror. I did ALL of the on-line updates with YAST and all was still OK. I then Enabled the SAMBA Server/client in YAST so the they could browse my shares and it went all pear shaped. I am now unable to browse the network using konqueror as I used to be able to do. After clicking on the "windows network" icon as I always have i get the following message. "Internal Error Please send a full bug report at http://bugs.kde.org Unknown error condition in stat: Network is unreachable" It is reachable though. Our proxy server has a fixed IP and I am able to browse its files if I put "smb://IP ADDRESS" in the address bar. The other WIN XP boxes in the network are using DHCP and I'm unable to find them. The thing is that after an extensive google search for the answer and finding several different "definate causes" for the problem, none of them work and I am still no nearer to stopping all the WIN XP moomins from laughing at my sorry attempts at running a different OS. It seems like there are a lot of people out there with the same problem but no-one knows how to sort this. I feel thick. I hope someone can help me.... my brain hurts :-( Fletch ___________________________________________________________ Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k

3 2

Weekly IRC reminder
by Neill Newman 22 Nov '04

22 Nov '04

This is the automated ALUG IRC meeting reminder sent to remind you that there is an IRC meeting tonight (Monday) at 8.00pm. The meeting takes place on the irc server irc.alug.org.uk in the #alug channel. Most IRC clients should allow you to get there with the commands "/server irc.alug.org.uk" and "/join #alug". Popular IRC clients include tkirc, bitchx, xchat and EPIC on Unix, and Mirc under windows. Here are some links to help you get started with irc. Unix http://www.xchat.org/ http://freshmeat.net/ http://www.epicsol.org/ Windows http://www.mirc.com (loads of help with irc for newbies!)

1 0

Linux
by Jeremy Dales 18 Nov '04

18 Nov '04

As requested, I'll try and outline why I am interested in Linux, along with a few first impressions, although I am certainly not a technical person, so I am more interested in what it does rather than how it does it. I like the idea of Linux being open source - in fact I would say it is something I believe in quite strongly, and I used several open source applications while I was running Windows. I was also fed up with the numerous security flaws I encountered in every version of Windows I used, and despite the best protection around, was still plagued with spam, spyware, trojans and viruses. It seems that Linux, for whatever reason, has largely avoided this. If I have a concern about using Linux, it is less to do with it as an operating system and more to do with my inability to comprehend it. While I suspect that this is not uncommon in the first week of use, I have to say that it has seemed fiendishly complicated to do even very basic things like install applications or get the hardware configured - this has necessitated ploughing through long lines of unfathomable code of the kind I usually try to avoid. I am hoping that I will either become used to it, or more likely, that having got the system set up the way I like it, I can have as little to do with opening the terminal window as possible. In short, I'm looking for a smooth and reliable graphical interface that is simple to use, relatively secure, and has the additional benefit of being open source. Jeremy

5 11

mysql users question
by Chris Green 18 Nov '04

18 Nov '04

How do I delete a mysql user? ... and how do I stop a mysql user requiring a password? -- Chris Green (chris(a)areti.co.uk) "Never ascribe to malice, that which can be explained by incompetence."

3 5

SuSE 9.1 and flash cards
by Wayne Stallwood 18 Nov '04

18 Nov '04

I am sure this topic has come up before, but I can't find a solution in the archives. Running SuSE 9.1 I would like the same automount functionality for my multi format card reader as SuSE/KDE provides for CD/DVD drives. I have a "My Computer" icon on my desktop, inside that I have an icon for each removable drive on my system. If I insert a CD/DVD with data content then it is mounted and a konq file browser window appears on the desktop. Is it possible to get the same functionality for a USB card reader (each card type appears as a different device) I can mount various card types at will using the mount command, but I have to tail /var/log/messages to check what device that card is assigned to and then manually mount/unmount it. After I have that bit working I would really like it to detect a card insertion without me having to detach/reattach the reader from the USB ports. But I am not even sure if that last bit is possible. Anyone fixed this ? Wayne

1 2