RE: [Phpip-support] hello
Brought to you by:
trilexcom
Menu
▾
▴
RE: [Phpip-support] hello
|
From: Michael E. <Mic...@cc...> - 2003-10-02 17:57:52
|
Lets start this again,
1. delete the database
2. run this command again
CREATE DATABASE phpip;
USE phpip;
#
# Table structure for table `addresses`
#
CREATE TABLE addresses (
id int(10) NOT NULL auto_increment,
ip varchar(36) default NULL,
mask varchar(16) default NULL,
gateway varchar(16) default NULL,
description varchar(255) default NULL,
client text,
clientcontact text,
phone varchar(80) default NULL,
email varchar(80) default NULL,
notes mediumtext,
UNIQUE KEY mykey (id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `history`
#
CREATE TABLE history (
date datetime default NULL,
id int(10) default '0',
ip varchar(20) NOT NULL default '',
username varchar(16) NOT NULL default '',
hostaddress varchar(16) NOT NULL default '',
KEY id (id,username,date),
KEY hostaddress (hostaddress),
KEY date (date),
KEY ip (ip),
KEY username (username)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `net_ips`
#
CREATE TABLE net_ips (
netaddress varchar(36) NOT NULL default '',
UNIQUE KEY netaddress (netaddress),
KEY netaddress_2 (netaddress)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `user`
#
CREATE TABLE user (
username varchar(16) NOT NULL default '',
passwd varchar(16) NOT NULL default '',
email varchar(100) NOT NULL default '',
access_level varchar(10) NOT NULL default 'read',
PRIMARY KEY (username),
KEY access_level (access_level)
) TYPE=MyISAM;
INSERT INTO 'user' ('username', 'passwd', 'email', 'access_level)
VALUES ('phpip_admin', PASSWORD('phpip_man'), 'phpip_admin@localhost ',
'admin');
Let me know if this works?
michael
PGP Info: KeyID 0x5EB59708 Fingerprint 108B A1D8 76F5 08A8 501A F28C
86F4 4BC5 5EB5 9708
>>> "Syam A. Yanuar" <ya...@ic...> 09/26/03 05:53PM >>>
Hello;
man, i have a lot of confuseable w/ your manual.. i am use
OpenBSD3.2
and webmin as usualy..
i has run your sql file on sql/create.sql that i have :
$ mysql -u root -p phpip < create.sql
Enter password:
ERROR 1007 at line 1: Can't create database 'phpip'. Database exists
now i disable one line one sql/create.sql "CREATE DATABASE phpip;"
now i got :
$ mysql -u root -p phpip < create.sql
Enter password:
ERROR 1064 at line 66: You have an error in your SQL syntax near
''user'
('username', 'passwd', 'email', 'access_level) VALUES ('phpip_admin',
PAS'
at line 1
your phpip is such a nice and i wanna to use it..
but i confuse w/ INSTALL manual...
pls help me..
-----Original Message-----
From: "Michael Earls" <mi...@mi...>
To: "'Syam A. Yanuar'" <ya...@ic...>
Date: Fri, 26 Sep 2003 17:48:33 -0400
Subject: RE: [Phpip-support] hello
> You need to add the username and password to phpip database, for
some
> reason it was not added, what OS do yo u run
>
> -- Linux --
> Mysql -u root -p
> Use phpip
> INSERT INTO `user` (`username`, `passwd`, `access_level`) VALUES
> (`phpip_admin`, PASSWORD(`phpip_man`), `phpip_admin@locallhost`,
`admin`
> )
>
> Let me know if this works for you, if not use phpmyadmin
> www.phpmyadmin.net
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of Syam
A.
> Yanuar
> Sent: Friday, September 26, 2003 5:25 PM
> To: php...@li...
> Subject: RE: [Phpip-support] hello
>
>
> hello;
>
> Sir, if i am login w/ (username : phpip_admin / password : phpip_man)
i
> have msg like this :
>
> "WARNING... You do not appear to be logged on.
> This could be due to your Session timing out.
> Please enter your User ID and Password."
>
> and i don't see link linke you said :
>
> "If you can then at the top right next to search
> and admin, there is a link called preferences"
>
> i just seen link on the top right " :: [SEARCH] :: [PREFERENCES] ::
> [LOGOUT] "
>
> help me...
>
> -Syam-
>
>
>
> -----Original Message-----
> From: "Michael Earls" <mi...@mi...>
> To: "'Syam A. Yanuar'" <ya...@ic...>
> Date: Fri, 26 Sep 2003 17:30:40 -0400
> Subject: RE: [Phpip-support] hello
>
> > Can you login to PHPIP? If you can then at the top right next to
> > search and admin, there is a link called preferences, this is how
you
> > change your passwd.
> >
> > Let me know if this works for you.
> >
> > michael
> >
> > -----Original Message-----
> > From: Syam A. Yanuar [mailto:ya...@ic...]
> > Sent: Friday, September 26, 2003 5:03 PM
> > To: Michael Earls
> > Subject: RE: [Phpip-support] hello
> >
> >
> > Hello;
> >
> > > 4. Login with username "phpip_admin" password "phpip_man"
> > > Change the admin password under /PREFERENCES/
> >
> > that part, i don't know what file that have word "/PREFERENCES/"
well
> > maybe u can help me..
> >
> > -Syam-
> >
> > -----Original Message-----
> > From: "Michael Earls" <mi...@mi...>
> > To: "'Syam A. Yanuar'" <ya...@ic...>
> > Date: Fri, 26 Sep 2003 17:13:35 -0400
> > Subject: RE: [Phpip-support] hello
> >
> > > What part of part 4 do you not understand?
> > >
> > > -----Original Message-----
> > > From: php...@li...
> > > [mailto:php...@li...] On Behalf Of
Syam
> > > A. Yanuar
> > > Sent: Friday, September 26, 2003 4:51 PM
> > > To: php...@li...
> > > Subject: [Phpip-support] hello
> > >
> > >
> > > Dear All;
> > >
> > > i have install phpip on my pc but the INSTALL manual maybe is
> > > not
> > > nice manual.. i am confuse w/ the option 4 that said :
> > >
> > > 4. Login with username "phpip_admin" password "phpip_man"
> > > Change the admin password under /PREFERENCES/
> > >
> > > 4. Add IP network address under /ADMIN/add_ips.php
> > > This only supports Class C network addresses
> > > 4a. Click on "Select IP Range" this will create the addresses
> 0-255
> > > for the selected range.
> > >
> > > any one can help me ?.
> > >
> > > -Syam-
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by:ThinkGeek
> > > Welcome to geek heaven.
> > > http://thinkgeek.com/sf `admin`
> )
>
>
> > > _______________________________________________
> > > Phpip-support mailing list
> > > Php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phpip-support
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpip-support mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpip-support
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Phpip-support mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpip-support
|
