10-05-2005
Ok, there you go :
As root.
su - dbuser -c "customers.exe upd_prclst"
or
su - dbuser -c "customers.exe upd_prclst;exit"
is putting me into a new shell as user
dbuser.
This user then has full access to all of his environment but the prog
customers.exe upd_prclst is not ran.
I then key in an
exit command which puts me back to the root environment. The prog is executed ok in the
dbuser shell.
I suppose there must be a CTRL-D or something missing but
10 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
Hello,
The system reboots in single user mode
what command to use to bring the system up regularly??
I get
INIT: cannot create /var/adm/utmpx
Type control -d to proceede with a normal startup
or give root passwd for system maintaince.
either way i don't have a change and ... (1 Reply)
Discussion started by: awk
1 Replies
2. What is on Your Mind?
Welcome to "The trouble with...." with your host, ZazzyBob.
Todays offering - "The trouble with letting other people host your website"
I use a certain web hosting service, who shall of course remain nameless here.
They are running PHP 4.3.10
I decide to write a script to test their PHP... (6 Replies)
Discussion started by: zazzybob
6 Replies
3. AIX
Hi,
we currently use a valisys licence :
it is based on a server (serv1)
it is reached only by one workstation (cam1)
In all licence files there is line with cam1 et serv1
We want to use cam22 (new workstation) instead of cam1
I made a copy the licences files with remplacing cam1 by cam22... (0 Replies)
Discussion started by: cadmanager
0 Replies
4. Solaris
I'm not sure where to post this but it's happening on a SunOS 5.8 server so I'll try here.
I've discovered some unexpected behavior when using tr.
For example:
echo a | tr
Z
echo b | tr
a
echo a | tr
B
echo a | tr
B
echo a | tr
A (8 Replies)
Discussion started by: Mike@Work
8 Replies
5. Shell Programming and Scripting
Hi folks,
there are windows device names in the sixth column of a comma separated file. A example device name is:
\\.\Tape0
I don't get the all string in to a variable, because of the preceding backslash. The first backslash is just cut off and my attempts to manipulate the string afterward... (0 Replies)
Discussion started by: wibo1
0 Replies
6. UNIX for Dummies Questions & Answers
What is the possible cause for the mount command to take ages? im trying to mount remotely : "mount -t nfs xx.x.x.x:/export/xyz/cdrom-4.0 /mnt/cdrom" on a system using bash. Im able to ping the remote server, but the system hangs or takes about half an hour to carry out this mount command.... (4 Replies)
Discussion started by: sahilb
4 Replies
7. UNIX for Dummies Questions & Answers
Hi there, I'm new to unix-environments.
I'm richard, and i'm mostly a web-developer, under php. I've done work in unix env before, but never had my own.
Today, I've got debian 3.1 r4 from the official site, and i've attempted to install it twice.
I installed it initially as "Desktop... (0 Replies)
Discussion started by: izua
0 Replies
8. UNIX for Dummies Questions & Answers
I am trying to figure awk.
I have a file in my home directory called testawk.sh, have made it executable, and have run it... But don't see any output.
This is the contents of the file:
#!/usr/bin/awk -f
{ print " - HI -" }I enter ./testawk.sh in the prompt, press enter, and watch as the... (2 Replies)
Discussion started by: matthewden
2 Replies
9. Programming
Hey, i am having a problem
First, i know java well and i have used C++ on occasion so i thought i would be able to deal with a class where they program in C. unfortunately i have hit some speed bumps that i am having problems.
Here is my problem:
I have a structure cache_t in the sample... (0 Replies)
Discussion started by: zephoid
0 Replies
10. UNIX and Linux Applications
I am having a bit of trouble plotting a histogram in gnuplot. I am trying to use it to draw bars side by side. The first bar is from column five in my data file. The second bar is actually three bars stacked on top of each other and should be as tall as the first bar. The data is from the 2nd,... (0 Replies)
Discussion started by: kingnothing
0 Replies
LEARN ABOUT DEBIAN
wiki::toolkit::setup::mysql
Wiki::Toolkit::Setup::MySQL(3pm) User Contributed Perl Documentation Wiki::Toolkit::Setup::MySQL(3pm)
NAME
Wiki::Toolkit::Setup::MySQL - Set up tables for a Wiki::Toolkit store in a MySQL database.
SYNOPSIS
use Wiki::Toolkit::Setup::MySQL;
Wiki::Toolkit::Setup::MySQL::setup($dbname, $dbuser, $dbpass, $dbhost);
Omit $dbhost if the database is local.
DESCRIPTION
Set up a MySQL database for use as a Wiki::Toolkit store.
FUNCTIONS
setup
use Wiki::Toolkit::Setup::MySQL;
Wiki::Toolkit::Setup::MySQL::setup($dbname, $dbuser, $dbpass, $dbhost);
or
Wiki::Toolkit::Setup::Mysql::setup( $dbh );
You can either provide an active database handle $dbh or connection parameters.
If you provide connection parameters the following arguments are mandatory -- the database name, the username and the password. The
username must be able to create and drop tables in the database.
The $dbhost argument is optional -- omit it if the database is local.
NOTE: If a table that the module wants to create already exists, "setup" will leave it alone. This means that you can safely run this
on an existing Wiki::Toolkit database to bring the schema up to date with the current Wiki::Toolkit version. If you wish to completely
start again with a fresh database, run "cleardb" first.
cleardb
use Wiki::Toolkit::Setup::MySQL;
# Clear out all Wiki::Toolkit tables from the database.
Wiki::Toolkit::Setup::MySQL::cleardb($dbname, $dbuser, $dbpass, $dbhost);
or
Wiki::Toolkit::Setup::Mysql::cleardb( $dbh );
You can either provide an active database handle $dbh or connection parameters.
If you provide connection parameters the following arguments are mandatory -- the database name, the username and the password. The
username must be able to drop tables in the database.
The $dbhost argument is optional -- omit if the database is local.
Clears out all Wiki::Toolkit store tables from the database. NOTE that this will lose all your data; you probably only want to use this
for testing purposes or if you really screwed up somewhere. Note also that it doesn't touch any Wiki::Toolkit search backend tables; if
you have any of those in the same or a different database see either Wiki::Toolkit::Setup::DBIxFTS or Wiki::Toolkit::Setup::SII,
depending on which search backend you're using.
ALTERNATIVE CALLING SYNTAX
As requested by Podmaster. Instead of passing arguments to the methods as
($dbname, $dbuser, $dbpass, $dbhost)
you can pass them as
( { dbname => $dbname,
dbuser => $dbuser,
dbpass => $dbpass,
dbhost => $dbhost
}
)
or indeed as
( { dbh => $dbh } )
Note that's a hashref, not a hash.
AUTHOR
Kake Pugh (kake@earth.li).
COPYRIGHT
Copyright (C) 2002-2004 Kake Pugh. All Rights Reserved.
Copyright (C) 2006-2008 the Wiki::Toolkit team. All Rights Reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Wiki::Toolkit, Wiki::Toolkit::Setup::DBIxMySQL, Wiki::Toolkit::Setup::SII
perl v5.14.2 2011-09-25 Wiki::Toolkit::Setup::MySQL(3pm)