From: Schmoger, Daniel (daniel.schmogersap.com)
Date: Tue Dec 13 2005 - 03:53:22 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello Orlando,
there is still a bug in rpm installation.
you can solve it by:
chmod 775 /var/opt/sdb /var/opt/sdb/data /var/opt/sdb/data/ipc
/var/opt/sdb/data/fifo
or you can add your linux user to sdba group (MaxDB administrators).

Regards,
 daniel
 

-----Original Message-----
From: Orlando Andico [mailto:orly.andicogmail.com]
Sent: Dienstag, 13. Dezember 2005 03:29
To: Heinrich, Tilo
Cc: maxdblists.mysql.com
Subject: Re: database instance creation via CLI doesn't work

On 12/12/05, Heinrich, Tilo <tilo.heinrichsap.com> wrote:
>
> Hello Orlando,
>
> File TRIGGER.py is indeed missing from the RPM's for 7.6.00.16. You
can
> either wait for the next set of RPM's, download the tgz/zip packages
or
> download just the missing file from
>
http://sapmats-de.sap-ag.de/download/download.cgi?id=FKD4YS1Q606XGB432QX
> F87IJP3C5SCFTVCR9FC49193WWZ6GZV .

Installed TRIGGER.py and the database-creation routine now works as
documented. I tried to create an SQL user with the following syntax:

user_create iguser,igpass
user_put iguser SERVERRIGHTS=+AccessSQL,+AccessUtility

then i try to log in, but it fails:

/opt/sdb/programs/bin/sqlcli -n localhost -d ig -u iguser,igpass

Welcome to the MaxDB interactive terminal.

Type: \h for help with commands
       \q to quit

sqlcli=> select * from cat;
* -10709: Connection failed (RTE:database not accesssible: stat on pipe
()

i notice that even the sysdba cannot log in unless the unix user is
su'ed to
root. permissions on a socket somewhere?

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]