Ok I thought Id go back one step and check if the mysql database exists.
It doesn't, I used mysqld, ser exists but there are no tables in it
whatsoever.
Ive read the contents of ser_mysql.sh and the relevant bit is I assume
the config section which is as follows.
#################################################################
# config vars
#################################################################
DBNAME=ser
DBHOST=localhost
USERNAME=ser
DEFAULT_PW=heslo
ROUSER=serro
RO_PW=47serro11
SQL_USER="root"
CMD="mysql -h $DBHOST -u$SQL_USER "
DUMP_CMD="mysqldump -h $DBHOST -u$SQL_USER -c -t "
BACKUP_CMD="mysqldump -h $DBHOST -u$SQL_USER -c "
TABLE_TYPE="TYPE=MyISAM"
# user name column
USERCOL="username"
GENHA1='gen_ha1'
#################################################################
Now when I try to set up the database using ser_mysql.sh create (I also
tried reinit too) the following is what I get.
hattie:/usr/sbin# ser_mysql.sh create
MySql password for root:
Domain (realm) for the default user 'admin': ser
creating database ser ...
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
OK so I know I put the right root password in for Mysql cos it works
with mysqld.
What is the right response to Domain (realm) for the default user
'admin': as you can see Ive used SER. Is this right.
What password is to be entered in the line after "creating database
ser". Ive tried heslo, Ive tried mysql root password, Ive tried YES.
All get the same response
Best regards Martin Coggin
-----Original Message-----
From: Andrei Pelinescu-Onciul
[mailto:pelinescu-onciul@fokus.fraunhofer.de]
Sent: 29 March 2004 14:15
To: 'Atle Samuelsen'
Cc: Martin Coggin; serusers(a)lists.iptel.org
Subject: Re: [Serusers] Quick start SER Too much shared memory
On Mar 29, 2004 at 15:09, 'Atle Samuelsen' <clona(a)camaro.no> wrote:
have you checked the /var/log/messages file? There
should be something
there.
if not, increase the debug level.. and try once more.
Or start ser with the -c switch (ser -c -f config_file ...). This will
only check the config and report the errors on stderr.
Andrei
- Atle
* Martin Coggin <martin(a)mc2-consulting.co.uk> [040329 14:57]:
> Tried that, ie put the "" around the 192.168.0.100 and get the same
> response ie Error: bad config file (2 errors).
>
> The report doesn't specify what the errors are Im afraid.
>
> Re naming of server. I don't use DNS on my network just ip
addresses.
> Im providing access to the server to the outside
world by using port
> forwarding. So Im assuming that I can use the ip address instead of
the
> name in the config file. Is this acceptable to
SER??
>
> Best regards Martin Coggin
>
> Information in this message is confidential and may be legally
> privileged. It is intended solely for the person to whom it is
> addressed. If you have received this email in error please delete
it
> immediately and also reply to me to let me know.
Thank you for your
> help.
>
>
> -----Original Message-----
> From: Atle Samuelsen [mailto:clona@cyberhouse.no]
> Sent: 29 March 2004 09:12
> To: Martin Coggin
> Subject: Re: [Serusers] Quick start SER Too much shared memory
>
> Hey Martin
>
> * Martin Coggin <martin(a)mc2-consulting.co.uk> [040329 10:04]:
> > Tks. Got through to point 6 of the section on adding my sql ser.
> >
> > I edited the ser.cfg file see the attached file. However I got 2
> errors
> > reported as per extract below and sorry I cant find them in the
file.
> >
> > hattie:/etc/init.d# ser restart
> > ERROR: bad config file (2 errors)
> > hattie:/etc/init.d#
>
>
> >
> > Note that I don't have DNS server on my network so Im using my
> internal
> # Uncomment this if you want to use digest authentication
> if (!www_authorize(192.168.0.100,
"subscriber"))
> {
> www_challenge(192.168.0.100, "0");
> break;
> };
>
>
> Im guessing without seeing the erros that you are hitting are that
you
> are missing some " in the block I pasted
erly'er..
> try to change it to !www_authorize("192.168.0.100",
> and www_channenge("192.168.0.100", ..
> tho. remeber that your domain must now be 192.168.0.100...
>
>
>
> > ip address, I assume that hence the entry for the ip address is
> > acceptable. My hosts file does include the host name. Is this
ok.
> Ill
> > be doing a forward on my firewall from my ip address to my
internal ip
> > address of the server.
> >
> > Im a little concerned that I didn't do step 3 completely. Ie
creation
> > of MySQL tables. I used the
/usr/sbin/ser_mysql.sh creation
process.
> I
> > entered a blank password for root, I entered ser as the domain: I
got
a
creating database ... message, then got another
"Enter password:"
request, entered blank and then returned to the command line.
You've been very patient with your help tks Martin
- Atle
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers