Re: [SLUG] IMAP (UW imapd)

[Edwin Humphries]

David Kempe wrote:
Edwin Humphries wrote:
But seting up the IMAP folders requires a setting: IMAP Server 
Directory. Now I  know where the server binary is - that's easy. But 
is it talking about mailbox location (/var/spool/mail)  or where the 
IMAP folders usualy go (/home/username)?

it shouldn't require that setting for it to work.
you can try INBOX in capitals
dave
David,,
I tried the previous response: /home/username. I'll try your idea in a
moment. I'm having other problems now: I can see the folder, so i
created a file in it (owned by me, permissions 777) but I can't do
anything with it. I want to copy my local folder over to it so that i
can see the mail from anywhere. Hmmm...
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] IMAP (UW imapd)

[David Kempe]

Edwin Humphries wrote:
But seting up the IMAP folders requires a setting: IMAP Server 
Directory. Now I  know where the server binary is - that's easy. But is 
it talking about mailbox location (/var/spool/mail)  or where the IMAP 
folders usualy go (/home/username)?
it shouldn't require that setting for it to work.
you can try INBOX in capitals
dave
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] What Debian dev package do I need to get gd.h ?

[Jan Schmidt]

> On Fri, 2004-08-06 at 14:09, Michael Lake wrote:
> > GD.xs:7:16: gd.h: No such file or directory
> > 
> > OK so I need a dev package that will contain the gd.h file. I have 
> > searched using apt-cache search libgd | grep dev and there are many 
> > possibilities.
> 
> You can go to packages.debian.org and search for gd.h within packages.
> 
> http://packages.debian.org/cgi-bin/search_contents.pl?word=gd.h&searchmode=searchfiles&case=insensitive&version=testing&arch=i386
> 
> My guess is libgd2-xpm-dev or if you like libgd2-noxpm-dev.
> 

Another option is to configure auto-apt and use it to search the entire
Contents list of packages.

auto-apt search gd.h
usr/include/gd.h libdevel/libgd-gif1-dev,oldlibs/libgd-noxpm-dev,
oldlibs/libgd-xpm-dev,libdevel/libgd2-noxpm-dev,libdevel/libgd2-xpm-dev

Also, even though it's a bit insane, I have been known to compile things
(such as all of gnome) inside an auto-apt session in order to let it prompt
me for every possible dependency that the packages are searching for.

J.
-- 
Jan Schmidt  [EMAIL PROTECTED]

Have you been half-asleep? Have you heard voices?
I've heard them calling my name...
 -Kermit the Frog (Rainbow Connection)
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] What Debian dev package do I need to get gd.h ?

[Simon Wong]

On Fri, 2004-08-06 at 14:09, Michael Lake wrote:
> GD.xs:7:16: gd.h: No such file or directory
> 
> OK so I need a dev package that will contain the gd.h file. I have 
> searched using apt-cache search libgd | grep dev and there are many 
> possibilities.

You can go to packages.debian.org and search for gd.h within packages.

http://packages.debian.org/cgi-bin/search_contents.pl?word=gd.h&searchmode=searchfiles&case=insensitive&version=testing&arch=i386

My guess is libgd2-xpm-dev or if you like libgd2-noxpm-dev.

(Maybe the description hasn't been updated?).

-- 
Simon Wong <[EMAIL PROTECTED]>
Wongy.org

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] IMAP (UW imapd)

[Edwin Humphries]

I've been trying to switch our office server to IMAP for q while, and 
having initially problems with email clients. I've tried Outlook and 
Outlook Express (yeah, I know, boo hiss), Eudora, Pegasus and now 
Thunderbird, which seems the best of the bunch (as long as we're stuck 
in Windows; can't use Evolution).

But seting up the IMAP folders requires a setting: IMAP Server 
Directory. Now I  know where the server binary is - that's easy. But is 
it talking about mailbox location (/var/spool/mail)  or where the IMAP 
folders usualy go (/home/username)?
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] help with MySQL database to web

[amos]

Peter Rundle wrote:
it but you might find this a very useful feature of php. (I've heard 
that there is a perl interpreter that allows perl to be "embedded" 
within html now too).
There is ePerl for about 10 years now. I'm not sure it's still the
leading "embedded perl in HTML" implementation. Maybe something a little
newer called "embperl", which mentions other implementations in its
intro
(http://perl.apache.org/embperl/pod/intro/Intro.-page-2-.htm#sect_1)
is the one to go with now if you want to use Perl.
All in all, I used to like working with ePerl much more than PHP back
than - PHP seemed to keep adding "special feature/syntax for X" whenever
"X" was missing while ePerl and friends just used "Perl as you know it"
with all the ready-made modules available for you.  Though PHP went a
long way since.
Cheers,
--Amos
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] What Debian dev package do I need to get gd.h ?

[Michael Lake]

Hi all
Im installing a Perl package that requires the GD graphics library 
(compiled with True Type font support). I have installed
libgd-gd2-perl

Package: libgd-gd2-perl
Version: 1:2.12-1
Depends: libc6 (>= 2.3.2.ds1-4), libfreetype6 (>= 2.1.5-1), libgd2-xpm 
(>= 2.0.20), libjpeg62, libpng12-0 (>= 1.2.5.0-4), libx11-6 | xlibs (>> 
4.1.0), libxpm4 | xlibs (>> 4.1.0), zlib1g (>= 1:1.2.1), perl (>= 
5.8.3-3), perlapi-5.8.3
Conflicts: libgd-noxpm-perl, libgd-perl, libgd-gd1-perl, 
libgd-gd1-noxpm-perl, libgd-gd2-noxpm-perl
Description: Perl module wrapper for libgd - gd2 variant
 Provides PNG, JPEG, and XPM creation and manipulation routines through
 the libgd library.
 Also allows use of TrueType fonts in images created.
 This package is linked against libgd2, with Xpm (X pixmap)
 support.

When I go to install the Perl GD package I get this during the 'make test':
GD.xs:7:16: gd.h: No such file or directory
OK so I need a dev package that will contain the gd.h file. I have 
searched using apt-cache search libgd | grep dev and there are many 
possibilities.

Package: libgd-dev
Section: oldlibs
Source: libgd
Version: 1.8.4-36
Provides: libgd1g-dev, libgd1-altdev
Depends: libgd-noxpm-dev (>= 1.8.4-27) | libgd-xpm-dev (>= 1.8.4-27)
Description: GD Graphics Library (transitional package)
 GD is a graphics library...
 This is a transitional package, provided for backwards compatibility
 only. You can safely remove this package when no other package depend
 on it.
Package: libgd2-dev
Section: oldlibs
Source: libgd2
Version: 2.0.23-2
Depends: libgd2-noxpm-dev (>= 2.0.4-2) | libgd2-xpm-dev (>= 2.0.4-2)
Conflicts: libgd-dev, libgd1g-dev, libgd1-altdev
Description: GD Graphics Library version 2 (development version)
 GD is a graphics library...
 This is a transitional package, provided for backwards compatibility
 only. You can safely remove this package when no other package depend
 on it.
The above are transitional packages. I cant find the ones that are the 
curent ones ie not transitional, that I should install.

Debian testing distro.
Mike
--
Mike Lake
Caver, Linux enthusiast and interested in anything technical.
--
UTS CRICOS Provider Code:  00099F
DISCLAIMER: This email message and any accompanying attachments may contain
confidential information.  If you are not the intended recipient, do not
read, use, disseminate, distribute or copy this message or attachments.  If
you have received this message in error, please notify the sender immediately
and delete this message. Any views expressed in this message are those of the
individual sender, except where the sender expressly, and with authority,
states them to be the views the University of Technology Sydney. Before
opening any attachments, please check them for viruses and defects.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] help with MySQL database to web

[Rocci]

Peter Rundle wrote:
G'day Rocci,
I thought I'd throw in my own beginners version of a PHP/mySQL prog.

As you state that your a php beginner I thought that you may not be 
aware that php can be interspersed within html. Your example could 
have been written thus;

House Database
Listing of houses






I'm not claiming this to be any more "right" than the way you've 
written it but you might find this a very useful feature of php. (I've 
heard that there is a perl interpreter that allows perl to be 
"embedded" within html now too).

HTH
P.


Yes I was aware of this.
My choice of method was largely due to my php inexperience.
I see now though that in some circumstances it may be more appropriate 
to use an html file with embedded PHP.

Thanks for bringing that to my attention Peter.
Rocci.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] Re: [SLUG-ANNOUNCE] UTS Install day 21st August

[Cheng Lim]

Hi,

I would like to confirm UTS Install day 21st August ? Is this still on ?
I certainly would like to have my Windows NT4 PC installed with Linux.
Thanks
Cheng Lim 
IT Architect
IBM Australia

Craige McWhirter writes:

> --  
> SLUG - Sydney Linux User Group Announcements List - http://slug.org.au
> More info: http://lists.slug.org.au/listinfo/announce
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] CodeCon idea

[Peter Miller]

When I was methodically visiting all the sea caves on the central coast
(I'm not done yet) I just had this hoopy idea, as Zaphod said to Ford
Prefect.

A CodeCon is meant to be a lost-cost conference.  The gist of this idea
is a fabulous location, a big tent and a generator.  BYO laptop.  Visit
http://miller.emu.id.au/pmiller/open-air-open-source/index.html and see
what crazy idea stuck in my head.  You can't get much more low-cost than
this.

So, how about it?  Two nights of hacking and yakking.

RSVP: Thu 12-Aug-04, but preferably much earlier.

I'll start booking things iff (definite + (maybe/5) > 20)

-- 
Peter Miller <[EMAIL PROTECTED]>
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] help with MySQL database to web

[Peter Rundle]

G'day Rocci,
I thought I'd throw in my own beginners version of a PHP/mySQL prog.
As you state that your a php beginner I thought that you may not be 
aware that php can be interspersed within html. Your example could have 
been written thus;

House Database
Listing of houses






I'm not claiming this to be any more "right" than the way you've written 
it but you might find this a very useful feature of php. (I've heard 
that there is a perl interpreter that allows perl to be "embedded" 
within html now too).

HTH
P.

--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] Asterisk

[Howard Lowndes]

Is anyone in SLUGland working or playing with Asterisk.

I am having problems trying to extract a CLID from an incoming analogue
POTS connection.

-- 
Howard.
LANNet Computing Associates;
Your Linux people 
--
"When you just want a system that works, you choose Linux;
when you want a system that just works, you choose Microsoft."
--
"Flatter government, not fatter government;
Get rid of the Australian states."


-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] Debian Birthday Dinner

[Craige McWhirter]

When: Wednesday, August 18, 7:00pm - 10:00pm 
Where: La Cita's 

It's Debian's birthday so we're heading out to dinner at La Cita's, King
St Wharf, a few doors up from our usual venue. Follow the map on the
website, there also links to to the menu there. An RSVP to debian (at)
slug.org.au is essential to guarantee a spot for what should be a great
night. La Cita nights are always good value.

http://debian.slug.org.au/

Hope to see you all there.

-- 

There is no distinctly native American criminal class except Congress.
-- Mark Twain


signature.asc
Description: This is a digitally signed message part
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] Re: simple network questions . How to add a route to connect toto192.168.0.x"

[Phil Scarratt]

The Salisburys wrote:
Thanks Phil
explained really well!
works like a treat ... the two card option  "A".
BUT Have to disable NAT on 198.192.0.1 to
connect from 10.0.0.x to 192.168.0.x. 
So for both networks to use the single ADSL connection I believe you 
must have

NAT running on 10.0.0.1 and 192.168.0.1
You should only need NAT on 10.0.0.1 I think. Here goes a little "on 
paper" reasoning:

All internal machines know how to get to 192.168.0.x or 10.0.0.x as the 
10.0.0.1 machine knows how to get to both networks. The 10.0.0.1 machine 
is effectively the default gateway for both internal lan's as the 
192.168.0.1 machine will route anything it doesn't know about to 
10.0.0.1. To my mind, this means you only need to hide or masquerade 
addresses when they are going outside the 192.168.0.x or 10.0.0.x ranges 
- ie NAT on 10.0.0.1.

A few eg's:
Src: 192.168.0.4
Dst: 10.0.0.3
- 192.168.0.4 -> 192.168.0.1
- 192.168.0.1 becomes 10.0.0.2
- 10.0.0.2 -> 10.0.0.4 (as 192.168.0.1 knows that eth1 is the 10.0.0.x 
network

Src: 10.0.0.5
Dst: 192.168.0.7
- 10.0.0.5 -> 10.0.0.1 (as the default gateway)
- 10.0.0.1 -> 10.0.0.2 (as configured in route tables)
- 10.0.0.2 becomes 192.168.0.1
- 192.168.0.1 -> 192.168.0.7
Src: 192.168.0.8
Dst: www.google.com.au
- 192.168.0.7 -> 192.168.0.1
- 192.168.0.1 becomes 10.0.0.2
- 10.0.0.2 -> 10.0.0.1
- 10.0.0.1 -> ppp0 (NAT'ing the originating address from 192.168.0.7 to 
public IP of ppp0 so that on return it sends to 192.168.0.7, which 
10.0.0.1 knows how to get to).


Haven't tried the three card option "B" ..does it have any pros
To my mind, it seems simpler to configure and maintain. It does however 
put the 192.168.0.x network a little "closer" to the outside world, 
which may or may not matter.


PS couldn't find your  list mail ...glitch somewhere?
Not sure what you mean. I only sent the message to the list, not to you 
and the list.

Fil
Roger
##
 

Option A: As you have it
Two options:
10.0.0.1 Machine: eth0 -> 10.0.0.1 -> route to 10.0.0.x
10.0.0.1 Machine: eth1 -> ADSL ppp0 -> default route
10.0.0.1 Machine: eth1 -> route to 192.168.0.x via gateway 10.0.0.2
10.0.0.x Machines: gateway -> 10.0.0.1
192.168.0.1 Machine: eth0 -> 192.168.0.1 -> route to 192.168.0.x
192.168.0.1 Machine: eth1 -> 10.0.0.2 -> route to 10.0.0.x
192.168.0.1 Machine: eth1 -> default route -> 10.0.0.1
192.168.0.x Machines: gateway -> 192.168.0.1
To do this:
- make sure eth1 on 10.0.0.1 is the default gateway or route
- On 10.0.0.1 run
route add -net 192.168.0.0 netmask 255.255.255.0 gw 10.0.0.2 eth1
- Make sure default gateway on 192.168.0.1 is 10.0.0.1
Option B: Make one gateway with 2 networks hanging off it
GW eth0: ADSL ppp0 -> default route
GW eth1: 10.0.0.1 -> route to 10.0.0.x
GW eth2: 192.168.0.1 -> route to 192.168.0.x
This should work without any further configuring. Machines on both 
networks have gateway set to x.x.0.1, and the .0.1 machine knows how to 
get to both network arms as well as internet.

Fil


--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] Occasional question/s in exchange

[Elliott-Brennan]

Title: Message



Dear 
All,
Hello. 
I'm brand new both to the group and Linux (much experience with Win9x up 
to 2000), so please excuse me for any faux pas. I live in the inner west and 
would like to exchange/barter knowledge (is this allowed). 

 
I've 
experience with and am a regular user of (not as a form of employment) Adobe 
Photoshop, and have had sometime with Paintshop Pro. Is there anyone in the 
local area (or willing to accept e-mail) who would be interested in some graphic 
art tips (eg. can create or show how/assist to create personalised wallpaper)in 
exchange for some assistance with configuring my new system. I also have an MA 
(Hons) in Sociology - not that there's much to barter for knowing more about not 
much :))
 
I 
have:
 
SuSE 9.1 Pro + Updates 
Mandrake 10.0 Official + Updates 

Fedora Core 2 Official + Updates 

Xandros 2.01 OCE 
Peanut 
9.6
 
and am 
trying to work through this with Mandrake - though if there's a compelling 
reason not to...
 
With 
work and two children I can promise that this would not be a 
regular every evening/day request, just someone to connect with when... 
well, you know.  My particular problem at the moment is getting online 
(TPG, ADSL, DSL-200).
 
Again, 
please forgive any intrusion for misplacing my request - any assistance and 
directions/referrals gratefully accept.
 
Regards,
 
Patrick
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] help with MySQL database to web

[Rocci]

Michael Lake wrote:
Trevor Tregoweth wrote:
HI All
i was wondering if someone could help me, this is probably a simple 
task, but for someone thats not done any before it seems impossible
I have a mysql database, with data in it, and i would like to be able 
to produce that data on a web page, so would appreciate some 
examples, i don't mind if its simple, just want to be able to view it 
via a web page

This is an example of a perl script that connects to a database of 
Journals on my laptop. The MySQL database is called 'Journal'
Note this is not meant to be secure its just a test I had around.

- perl script --
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $user = 'root';
my $password = 'your_mysql_root_password';
my @row;
my $date = `date '+%a %b %d, %Y'`; chomp $date;
# Connect to the Database
my $dbh = DBI->connect('dbi:mysql:Journal', $user, $password,
{ RaiseError => 1, AutoCommit => 0 });
my $query = $dbh->prepare("SELECT * FROM journal");
$query->execute;
# Print the HTML header - note the two blank lines \r\n\r\n
print qq{Content-type: text/html\r\n\r\n

ASF KID Test
Test Database Access
};
# Print the data preformatted.
print "Todays date: $date ";
print"";
while ( @row = $query->fetchrow_array ) {
print "@row";
}
print"";
# Print the HTML end.
print qq{


};
$query->finish;
$dbh->disconnect;
-- end of Perl script --
Here is the output as a HTML page
Its the Journal_id, volume, part, the issue_month, issue_year.
Test Database Connectivity
Todays date: Thu Aug 05, 2004
2 133 3 4 December 2000
3 134 1 2 June 2001
4 134 3 4 December 2001
5 135 1 2 July 2002
6 135 3 4 April 2003
7 136 1 4 December 2003
--- end HTML --
Here is the Journal database table that was queried:
Sorry it wrapped badly so I cut bits out but you get the idea.
+-+-+
| Field | Type | Null | Key | Default | Extra
+-+-+
| journal_id | int(10) unsigned
| volume
| part
| issue_month | 
enum('January','February','March','April','May','June','July','August','September','October','November','December') 

| issue_year | year(4)
+-++
Hope this helps.
Mike
I thought I'd throw in my own beginners version of a PHP/mySQL prog.
I slapped this together quickly as I was after a small web database 
solution in a hurry.

-cut->paste---

print "House DatabaseListing of houses\n";
print "\n";
print "\n";
print "Results of search: Please note that date is in 
year-month-day format.\n";
//One day I'll do something about the date format
print "IDHouse No.Street 
NameSuburbNo. 
BedroomsPriceDateSourceDescription\n";

$user = "username_with_access_to_the_DB/Table";
$pass = "users_password";
$db = "database_name";
$table = "name_of_table";
$query = "SELECT * FROM $table WHERE stnumber LIKE '%$stnumber%' AND 
stname LIKE '%$stname%' AND suburb LIKE '%$suburb%'";

//Connect to the database:
$link = mysql_connect("localhost", $user, $pass);
if(! $link)
die("Could not connect to database");
//Select the database to work with:
mysql_select_db( $db, $link)
or die ("Couldn't open $db: ".mysql_error() );
$result = mysql_query($query , $link);
if (! $result)
die("No matches found.");
$num_rows = mysql_num_rows($result);
//While there continues to be data in the returned set, we loop and 
print this out in a table.
while ( $a_row = mysql_fetch_row( $result ) )
{
print "\n";
foreach ( $a_row as $field )
print "\t$field\n";
print "\n";
}

mysql_close($link);
print "";
print "Number of records found: $num_rows";
print "Search 
again";
print "Return to Home 
Page";

?>
- end paste ---
Obviously the variables such as "stnumber", "stname" etc.. are from the 
posted html form and used as part of the SQL search query.
I found PHP works really nicely with mySQL as it has some great support 
for it. I'm sure there's many expert PHP/SQL sluggers out there who 
would agree.
And if you're already familiar with languages such as C/C++, you will 
find picking up PHP even easier.

Hope this helps you out.
Rocci.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] GNOME slow startup

[Jeff Waugh]

> I'm assuming this is a gconf issue, mainly because gconf is alien and
> scary to me

Unfortunately, gconf is pretty modern and tightly honed. The problem you're
having is almost 100% due to GNOME's session support, which is very old and
shitty. We need to fix it.

Open up Applications > Desktop Preferences > Advanced > Sessions, go to the
Current Session tab. Now, I can't give you a reasonable summary of the kind
of things that shouldn't be there, but if you note down the process names in
a reply, I can tell you which ones to remove (and why they're broken).

- Jeff

-- 
linux.conf.au 2005: Canberra, Australiahttp://linux.conf.au/
 
 "I guess there's part of me that's always resented it... to be an
   actor, you have to have someone else say yes to you." - Edward Norton
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] GNOME slow startup

[Matthew Davidson]

Hi all,
I have a Debian unstable box at home.  My main desktop is XFCE, but my
wife uses GNOME.  She's been complaining of slow startup times for ages,
and I've only just got around to checking it out.  (I never buy her
flowers, either.)
I try starting GNOME from gdm.  The splash screen sits on "Desktop
Settings" for about two minutes, then another two minutes or so on
"Window Manager", for a total of over five minutes before I get to my
desktop (on an Athlon with 256MB of RAM).
I'm assuming this is a gconf issue, mainly because gconf is alien and
scary to me.  My wife uses GNOME every day, and I use it once a week or
so, but I'm usually out of the room while it's starting up, so I haven't
noticed how ludicrous this problem has become.
Create a new user account, and GNOME starts up too fast to measure.
Anybody have any clues on where to start looking for the cause of this
phenomenon?  I would guess that since this machine has seen GNOME 2.2,
2.4, and now 2.6, that some garbage has accumulated in the config
somewhere, but I have already resolved one GNOME problem recently by a
mass deletion of dotfiles, and really don't find that a satisfactory
solution.  Purge-and-reinstall was a system tuning technique I thought
I'd thrown out with my last proprietary OS.
Matthew.
--
0419 242 316 ... (02) 6658 1607
--
Please avoid sending me Word or PowerPoint attachments.
(Save as HTML or RTF)
See http://www.fsf.org/philosophy/no-word-attachments.html
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] .htaccess

[Trevor Tregoweth]

Hi All
 
Thanks for the information provided...it 
was a great help.
 
one other question, what do i need to setup in the 
httpd.conf file so i can use .htaccess 
 
Cheers
 
Trevor

  - Original Message - 
  From: 
  Paul 
  Robinson 
  To: Trevor Tregoweth ; Slug 
  Sent: Thursday, August 05, 2004 11:32 
  AM
  Subject: Re: [SLUG] 
  
  Hi Trevor,
   
  You need a web compatible scripting language like 
  PHP, Perl or .. well the list goes on and on.
   
  http://au2.php.net/mysql for the 
  section of the PHP manual on how php interacts with MySQL
  or 
  http://webmonkey.wired.com/webmonkey/99/21/index2a.html for 
  a tutorial
  for Perl :
   
  http://webmonkey.wired.com/webmonkey/backend/tutorials/tutorial1.html
   
  These should get you started.
   
  Cheers,
  Paul
  
- Original Message - 
From: 
Trevor Tregoweth 
To: Slug 
Sent: Thursday, August 05, 2004 11:59 
AM
Subject: [SLUG] 


HI All 
 
i was wondering if someone could help me, this 
is probably a simple task, but for someone thats not done any before it 
seems impossible
 
 
I have a mysql database, with data in it, and i 
would like to be able to produce that data on a web page, so would 
appreciate some examples, i don't mind if its simple, just want to be able 
to view it via a web page
 
Thanks in advance
 
Cheers
 
Trevor



-- SLUG - Sydney Linux User's Group Mailing List - 
http://slug.org.au/Subscription info and FAQs: 
http://slug.org.au/faq/mailinglists.html
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] Modems

[Phil Scarratt]

Christopher Bragg wrote:
I am about to venture into the world of Linux.
and would like help with the following
I have a 450 PII with 3X128 sticks of memory apparently my winmodem will 
not work with Linux.
Can you suggest a make and model that has proved popular with SLUG
Thank You
Christopher
 

I know this is not what you wanted but have you checked out
http://linmodems.org/
Fil
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

[SLUG] Modems

[Christopher Bragg]

I am about to venture into the world of 
Linux.
and would like help with the following
I have a 450 PII with 3X128 sticks of memory 
apparently my winmodem will not work with Linux. 
Can you suggest a make and model that has proved 
popular with SLUG
Thank You
Christopher
 
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] help with MySQL database to web

[Michael Lake]

Trevor Tregoweth wrote:
HI All 

i was wondering if someone could help me, this is probably a simple task, but for 
someone thats not done any before it seems impossible
I have a mysql database, with data in it, and i would like to be able to produce that 
data on a web page, so would appreciate some examples, i don't mind if its simple, 
just want to be able to view it via a web page
This is an example of a perl script that connects to a database of 
Journals on my laptop. The MySQL database is called 'Journal'
Note this is not meant to be secure its just a test I had around.

- perl script --
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $user = 'root';
my $password = 'your_mysql_root_password';
my @row;
my $date = `date '+%a %b %d, %Y'`; chomp $date;
# Connect to the Database
my $dbh = DBI->connect('dbi:mysql:Journal', $user, $password,
{ RaiseError => 1, AutoCommit => 0 });
my $query = $dbh->prepare("SELECT * FROM journal");
$query->execute;
# Print the HTML header - note the two blank lines \r\n\r\n
print qq{Content-type: text/html\r\n\r\n

ASF KID Test
Test Database Access
};
# Print the data preformatted.
print "Todays date: $date ";
print"";
while ( @row = $query->fetchrow_array ) {
print "@row";
}
print"";
# Print the HTML end.
print qq{


};
$query->finish;
$dbh->disconnect;
-- end of Perl script --
Here is the output as a HTML page
Its the Journal_id, volume, part, the issue_month, issue_year.
Test Database Connectivity
Todays date: Thu Aug 05, 2004
2 133 3 4 December 2000
3 134 1 2 June 2001
4 134 3 4 December 2001
5 135 1 2 July 2002
6 135 3 4 April 2003
7 136 1 4 December 2003
--- end HTML --
Here is the Journal database table that was queried:
Sorry it wrapped badly so I cut bits out but you get the idea.
+-+-+
| Field   | Type 
| Null | 
Key | Default | Extra
+-+-+
| journal_id  | int(10) unsigned
| volume
| part 

| issue_month | 
enum('January','February','March','April','May','June','July','August','September','October','November','December')
| issue_year  | year(4) 

+-++
Hope this helps.
Mike
--
Mike Lake
Caver, Linux enthusiast and interested in anything technical.
--
UTS CRICOS Provider Code:  00099F
DISCLAIMER: This email message and any accompanying attachments may contain
confidential information.  If you are not the intended recipient, do not
read, use, disseminate, distribute or copy this message or attachments.  If
you have received this message in error, please notify the sender immediately
and delete this message. Any views expressed in this message are those of the
individual sender, except where the sender expressly, and with authority,
states them to be the views the University of Technology Sydney. Before
opening any attachments, please check them for viruses and defects.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html