I was able to make it run after uninstalling/reinstalling the sample db
rpm. In the process I did get some errors, not sure if they were benign.
Here is the detailed transcript of what all I did:
==================================================
It might be something to do with permissions. I have installed the db as
root on my machine. I start and stop the x_server as root. These are the
steps I am following:
One
---
First I stopped the x_server (as root). Then I ran the drop db script. If
I do it as me, I get:
./drop_demo_db.sh
+ SID=TST74
+ x_server start
12751 XSERVER XSERVER started, 'X32/LINUX 7.4.3 Build
010-000-035-462'
ERR 11895 XSERVER Redirect message output to
'/var/opt/sapdb/indep_data/wrk/xserver.prt' failed:Permission denied
+ dbmcli -d TST74 -u dbm,dbm db_offline
+ dbmcli -s -d TST74 -u dbm,dbm db_drop
+ rmdir /home/tanu/TST74
+ exit 0
Since I get permission denied, I am not sure it worked. So I did this
again as root, and it worked ok.
Two
---
I tried to run create_demo_db.sh script as root but was prevented from
doing so. I then ran it as me and I get the following errors:
a) when x_server is running
./create_demo_db.sh
ERR 11641 XSERVER XSERVER is already running!
create database TST74...
create TST74 failed: ERR
-24994,ERR_RTE: runtime environment error
1,mkstemp failed:Permission denied
b) when x_server is not running
./create_demo_db.sh
12751 XSERVER XSERVER started, 'X32/LINUX 7.4.3 Build
010-000-035-462'
ERR 11895 XSERVER Redirect message output to
'/var/opt/sapdb/indep_data/wrk/xserver.prt' failed:Permission denied
create database TST74...
create TST74 failed: ERR
-24994,ERR_RTE: runtime environment error
1,mkstemp failed:Permission denied
So I don't know what permissions do I need to create the db again.
Three
-----
But then, I uninstalled the sample db rpm and reinstalled it. This is what
I get:
rpm -ivh sapdb-testdb74-7.4.3.10-1.i386.rpm
Preparing... ###########################################
[100%]
1:sapdb-testdb74 ###########################################
[100%]
12751 XSERVER XSERVER started, 'X32/LINUX 7.4.3 Build
010-000-035-462'
ERR 11641 XSERVER XSERVER is already running!
I assume the last error is benign?!
Four
----
And I test the db through dbmcli (running as me, not as root):
[tanu@klpd FirstSteps]$ dbmcli -u dbm,dbm -d TST74 db_state
OK
State
ONLINE
[tanu@klpd FirstSteps]$ dbmcli -uSQL test,test -u dbm,dbm -d TST74
sql_execute select 1 from dual;
OK
END
1
Five
----
And then finally:
[tanu@klpd Java]$ java HelloSapDB -u test,test -d TST74
hello world
It worked!!! Don't know what exactly the issue was. Maybe some
installation thing and uninstalling/reinstalling the testdb did the trick!
Hope someone can provide me some answers to what I saw here. And hopefully
the detailed transcript will help others facing this issue.
Enoy!
-Tanu
--- "Schroeder, Alexander" <[EMAIL PROTECTED]> wrote:
> Hi Tanu,
>
> can you connect and execute statements via dbmcli:
>
> dbmcli -uSQL test,test -u dbm,dbm -d TST74 sql_execute select 1 from
> dual
>
> ?
>
> Also, did the create_demo_db.sh script run without any error messages?
>
> -4008 means username/password unknown. This is quite ok if you try with
> the dbm, as dbm is a database operator, not an user suitable for SQL
> execution etc. But normally the test user should work, and also the
> message "Unknown user name/password combination" should be shown
> whenever
> this error occurs, so I assume something bad happened during DB
> creation.
>
> The script create_demo_db.sh drops the db and recreates it again, if run
>
> twice, so you may try again from here.
>
> Regards
> Alexander Schr�der
> SAP Labs Berlin
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
