Within Ubuntu, we opened a Terminal Prompt and typed the following
1. Cd /usr/local
2. Ls - Equivalent to dir in Windows
3. LS –al - Equivalent to dir in Windows – different display
4. You’re looking for an ‘Advantage’ folder, if it exists then Advantage has already been installed.
5. Sudo -i - Supervisor DO – jump to administrative access (interactive)
6. Open up firefox, goto http://devzone.advantagedatabase.com and download the Linux ADS installer, we used ADS 9.1.
7. We also changed the screen resolution (for VMWare ease of use) by going to System > Prefs > Display and Change resolution to 1024x768.
8. Anyway, save the .gz file from the devzone.advantagedatabase.com site
9. Right click on the .gz file and goto open containing folder – it opened up to the UBuntu desktop
10. Goto applications > terminal
11. Sudo -i - Supervisor DO – jump to administrative access (interactive)
12. Pwd - shows location (where you are in the directory tree)
13. Cd /home/administrator/Desktop - Case sensitive
14. Right click on the .gz file and open with Archive Manager
15. Click Extract, and extract it to the UBuntu desktop
16. In the terminal type cd adslinux-9.10.0.9 (or use the tab key)
17. Type ./setup.pl to kick start the ADS installation process.
18. Scroll through the license agreement
19. Do you agree with this license? (y)
20. Enter the owners name (optional)
21. Destination path is fine.
22. Select defaults for language settings
23. Select “3” for American/USA
24. Select ‘Y” to start Automatically
25. Leave the user account as “Advantage”
26. Answer “N” to make further changes to complete the installation.
27. Enter the Serial Number, e.g.: 2284400
28. Enter the authorization code: 824-LUE67UICBH-4W2BY6FA66
29. Enter the data directory location. This script will give ownership of this directory to the Advantage account. We typed /DATA to create the data folder
30. At the terminal prompt enters LS / to confirm that the DATA folder was created
31. ls –al /DATA - lists the directory. Verify the owner is Advantage
32. At the terminal type /usr/local/advantage/adsd - Starts the Advantage Database Server
33. Ps –A | grep “adsd” will display if the service is started, if it’s not then nothing will be displayed
34. Typing ‘hostname’ will display the servers hostname
35. On Windows you can map a drive to the Ubuntu by typing
net use q: ptilinuxDATA * /user:root and enter the password for the account
36. We noted that the folder wasn’t shared, and did this in ubuntu
a. We went to PLACES
b. Select ‘File System’
c. Right clicked on the ‘DATA’ folder
d. Set sharing permissions as being ‘Share’ (checked), Allow (checked) and Guest (Checked – but Sybase don’t like to give full permissions).
Because we were logged in as Administrator and not Advantage it blew up as we didn’t have permissions to set permissions.
37. Su advantage - to switch accounts to the Advantage folder [Didn’t Work]
38. We tripped up with the Nautlius installation too.
-------------- Email in from Sybase, re: Sharing Under Ubuntu:
From: Michael.Loop@sybase.com [mailto:Michael.Loop@sybase.com]
Sent: Thursday, June 11, 2009 12:45 PM
To: Steven Dyson
Subject: Re: Vmware
Steven,
To share your /DATA directory, please go to Places and navigate to /etc/samba. Right-click on smb.conf and choose "Open in Text Editor".
At the very bottom of the file, add these lines:
[DATA]
comment = Any comment you want
path = /DATA
create mask = 774
directory mask = 774
force group = advantage
force user = advantage
read only = no
guest ok = yes
guest ok = yes
case sensitive = yes
preserve case = no
short preserve case = no
default case = lower
available = yes
browsable = yes
public = yes
writable = yes
These lines:
force group = advantage
force user = advantage
ensure that any files created or copied via the shared drive are owned by "advantage", and are therefore accessible to the database server.
These lines:
case sensitive = yes
preserve case = no
short preserve case = no
default case = lower
ensure that any file created or copied via the share are in lower case. This simplifies case-sensitivity issues.
Now you need to restart the samba daemon. Open a new terminal and type:
sudo /etc/init.d/samba/restart
You should see:
* Stopping Samba daemons [ OK ]
* Starting Samba daemons [ OK ]
Finally, since we have guaranteed that all database files will be in lower case, you need to tell the ADS server to look for lowercase files. Go to Places and navigate to /usr/local/advantage, right-click on ads.conf, and choose "Open in Text Editor". Find the option Lowercase_All_Paths and set it to 1. This is almost always necessary when accessing a server on Linux from Windows. This is because the many APIs Windows uses to build file requests are not consistent in how they set the case in the path and file names.
Now you need to stop and restart ADS for the setting to take effect. Apparently, when the service is started manually, we have no more elegant method to do this than:
ps -A | grep "ads"
sudo kill X (where X is the pid of the adsd process)
sudo /usr/local/advantage/adsd
I believe that when the server is automatically started on boot, you can restart the process with:
sudo /etc/init.d/ads restart
However, I don't have a VM set up this way, so I can't confirm this.
Now to back to Windows and try:
net use Q: PTILinuxDATA * /user:administrator
If this still doesn't work, I have a few more tricks we can discuss, but I don't want to go down that road yet.
Regards,
Mike Loop
Advantage Tech Support |
|
|
|
|
|
| User Opinions |
|
| No users have voted. |
|
| How would you rate this answer? |
|
|
|
