hi
as you said, iam bae to create table vpopmail, relay
when i add domain, its not writing in to database.
i did like this in voracle.h
/* Edit to match your set up */
#define ORACLE_SERVICE "ORCL"
#define ORACLE_USER "system"
#define ORACLE_PASSWD "manager"
#define ORACLE_HOME "ORACLE_HOME=/export/home/oracle" ( oracle
path)
/* End of setup section*/
WHAT ABOUT THIS, IS THIS REQUIRE OR ABOVE ONE ENOUGH.
/* defaults - no need to change */
#define ORACLE_DEFAULT_TABLE "vpopmail"
#define ORACLE_DATABASE "orcl1"
#define ORACLE_DOT_CHAR '_'
#define ORACLE_LARGE_USERS_TABLE "users"
WHEN I CRATE USER, ./VADDDOMAIN DOMAIN.COM
ITS NOT CREATING IN DATABASE,
ITS ABLE TO CREATE IN /HOME/VPOPMAIL/DOMAINS DIRECTORY.
what could be the problem
thanks
balaji
Ken Jones wrote:
> Balaji Hare Ram Balaji wrote:
> >
> > is there any body help out of creating table and database on oracle
> > i have much idea, but iam noit understand how to do that.
> > if any body supply sql scripts and how to implement
> >
> > snd help me how to corodinate with vpopmail
> >
> > i ahve already an existing user database with username and password, i
> > can use them and go with vpopmail
> >
> > help
> > balaji
>
> Hi Balaji,
>
> The vpopmail mailing list is at [EMAIL PROTECTED] not
> [EMAIL PROTECTED] ;]
>
> If you can access oracle from the command line, and log in.
> Try these sql commands.
>
> CREATE TABLE VPOPMAIL (
> pw_name char(32) not null,
> pw_domain varchar(223) not null,
> pw_passwd varchar(255) not null,
> pw_uid int,
> pw_gid int,
> pw_gecos varchar(255),
> pw_dir varchar(255),
> pw_shell varchar(255), primary key(pw_name, pw_domain)
> )
>
> CREATE TABLE RELAY (
> ip_addr char(18) not null, timestamp char(12) primary key(ip_addr)
> )
>
> Ken
