main

main@lists.alug.org.uk

1 participants
10367 discussions

SUSE 9.1 SAMBA NETWORK ERROR
by RICHARD FLETCHER 23 Nov '04

23 Nov '04

Annoying Newbie, back again. After looking around the smb.conf in SUSE 9.1 I finally descovered the problem behind the error "Network unreachable" when trying to browse the LAN in konquorer. After the workgroup name is changed from "TUX-NET" to the one that the rest of the LAN uses "MSHOME" (in YAST samba server setup) the problem occurs. When the name is changed back to "TUX-NET" browsing in konquorer is ok again. Although I have found this out I am still no closer than I was to sorting out my network. I think that I have been asking the wrong questions. What I am trying to achieve is this; I am running SUSE 9.1 on a peer to peer network along with seven WINXP machines. I want to share one folder called "My network share" and its sub folders and files. Allow others on the network to see it and read/write to it. "My network share" is in /home. I still want to be able to browse the network with my Linux box and read/write to the WINXP shares. This should be as simple as setting things up in YAST2 but as I said above, every time I change the workgroup in YAST or smb.conf I loose my ability to browse the network. Please somebody put me out of my misery one way or another as I'm still the laughing stock of this WINXP crowd. Is this a samba problem or is it KDE or SUSE or just ME?! Where am I going wrong? What am I missing? Why is this not simple? Hope someone can help. I had better go now, they mostly come at night......mostly:-) ___________________________________________________________ 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

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

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