Current time: 06-16-2024, 05:20 PM Hello There, Guest! (LoginRegister)


Post Reply 
FreeBSD ?
Author Message
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #51
RE: FreeBSD ?
Is there another user who has all privileges? Debian has one...
or maybe you can try to connect from outside (first activate access from extern) and tray the root@yourhost.domain.tld...

You cannot change the table mysql.user when starting with --skip-grand-tables?

/J
03-08-2008 02:46 AM
Visit this user's website Find all posts by this user Quote this message in a reply
StevenE Offline
Junior Member
*

Posts: 104
Joined: Feb 2008
Reputation: 0
Post: #52
RE: FreeBSD ?
hi,

I started again with new mysql installation :S
and now I'm sure that the installation changes the PRIVILEGES
I created a dbuser omega with all privileges, after ispcp-setup, where I give omega as SQL user, omega has only Usage instead of all privileges....

and ispcp-setup failed with
Code:
ERROR: External command '/usr/local/bin/mysql --host=localhost --user=omega --pass=admin < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '1' status !

db.sql.stderr sais:
Code:
ERROR 1044 (42000) at line 1: Access denied for user 'omega'@'localhost' to database 'ispcp'

the installation overwrite the rights of omega everytime so here's at the moment no way out for me...
whats to do?


edit: I use the current nightly one Smile
(This post was last modified: 03-10-2008 10:32 PM by StevenE.)
03-10-2008 10:30 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #53
RE: FreeBSD ?
you *can* give ispcp an own mysql user (I do this also) but this needs to be a user with the same privileges as the root user becaus it needs to create databases and users.

I installed the r1043 tonight and this runs well. Ok, it's on debian, but I don't think that this is the reason.

/J

Upd: maybe you can post the table mysql.user before and after the installation
(This post was last modified: 03-10-2008 10:40 PM by joximu.)
03-10-2008 10:39 PM
Visit this user's website Find all posts by this user Quote this message in a reply
StevenE Offline
Junior Member
*

Posts: 104
Joined: Feb 2008
Reputation: 0
Post: #54
RE: FreeBSD ?
I created the user omega with ALL_PRIVILEGES after Installation its only Usage
so the error occurs during the installation I think.

A short look at ispcp-setup didn't get me any hint
Sorry don't know where the error could be, I'm not so well with scripting Tongue
(This post was last modified: 03-10-2008 10:49 PM by StevenE.)
03-10-2008 10:46 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #55
RE: FreeBSD ?
Really strange - there is no code in the setup which changes this.
Only the pma and vftpd users are created and "granted" - you did not mix theese users?
03-10-2008 11:06 PM
Visit this user's website Find all posts by this user Quote this message in a reply
StevenE Offline
Junior Member
*

Posts: 104
Joined: Feb 2008
Reputation: 0
Post: #56
RE: FreeBSD ?
don't know why but now it seems working only few files are not copied well....
03-10-2008 11:06 PM
Find all posts by this user Quote this message in a reply
StevenE Offline
Junior Member
*

Posts: 104
Joined: Feb 2008
Reputation: 0
Post: #57
RE: FreeBSD ?
so whyever DB works, was my mistake
but now, how could it be otherwise, some new probs occurs

Code:
ERROR: Can't open file |/usr/local/etc/ispcp/cron.d/backup/ispcp| for writing: No such file or directory

Code:
cp: directory /etc/cron.d does not exist

Code:
cp: /usr/local/etc/ispcp/cron.d/working/ispcp: No such file or directory

these 3 above seems not well copied from the routine, or am I wrong?


Code:
/usr/local/etc/named.rc: not found
cp: /usr/local/etc/ispcp/bind/backup/named.conf.ispcp: No such file or directory
ERROR: External command '/bin/cp -p /usr/local/etc/ispcp/bind/backup/named.conf.ispcp /etc/namedb/named.conf' returned '1' status !

Code:
cp: /etc/namedb/named.conf: No such file or directory
ERROR: External command '/bin/cp -p /usr/local/etc/ispcp/bind/backup/named.conf.ispcp /etc/namedb/named.conf' returned '1' status !

ok my fault haven't installed any nameserver before, thes should fit with excisting nameserver I think



Code:
ERROR: File '/usr/local/etc/ispcp/apache/working/fastcgi_ispcp.conf' does not exist !

my path is /usr/local/etc/ispcp/apache22/working/fastcgi_ispcp.conf

Code:
ERROR: File '/usr/local/etc/ispcp/apache/01_awstats.conf' does not exist !

don't exist in my path anyway...


after that an error occurs becaus of my slopy troubleshooting so never mind. but perhaps we can solve together things above...
03-10-2008 11:31 PM
Find all posts by this user Quote this message in a reply
StevenE Offline
Junior Member
*

Posts: 104
Joined: Feb 2008
Reputation: 0
Post: #58
RE: FreeBSD ?
tried it once again....
I belive it hates me really hard Tongue

Ok... I loaded the current nightly.

Code:
make -f BSDMakefile
works fine as allways

but now first question why you changed path from

/usr/local/www/apache22/ispcp/
to
/usr/local/www/ispcp/

this only catches more difficultes....
so I move it back to old path.

I started then...

Code:
./ispcp-setup
several errors occur

here how I solved them

Code:
mv /usr/local/www/ispcp /usr/local/www/apache22/

ln -s /usr/local/etc/ispcp/ /etc/ispcp

cp /omega/engine/setup/ispcp-setup-methods.pl /usr/local/www/apache22/ispcp/engine/setup/

cp -Rp /omega/configs/dists/freebsd/cron.d /usr/local/etc/ispcp/cron.d

mkdir /usr/local/www/apache22/fcgi/master

mkdir /etc/cron.d

cp /omega/configs/dists/freebsd/bind/named.rc /usr/local/etc/ && chmod 777 /usr/local/etc/named.rc

touch /usr/local/etc/ispcp/bind/backup/named.conf.ispcp

mkdir /etc/namedb

ln -s /usr/local/etc/ispcp/apache22 /usr/local/etc/ispcp/apache

cp /omega/configs/dists/freebsd/apache/01_awstats.conf  usr/local/etc/ispcp/apache/

but now I stuck no idea whats going wrong here, but looks familiar to the other current new topic "Installation problem on CentOS 5.1"
Code:
ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !


Greetz Steve

edit: this is the tail of ispcp-setup with debug
Code:
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Ending...
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: ERROR: '// dmn [admin.ispman.cbt-l.de] cfg entry BEGIN.
' ne '// dmn [admin.ispman.cbt-l.de] cfg entry END.
', '// dmn [admin.ispman.cbt-l.de] cfg entry BEGIN.
' or '// dmn [admin.ispman.cbt-l.de] cfg entry END.
' missing in src !
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Ending...
DEBUG: push_el() sub_name: repl_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: Ending...
DEBUG: push_el() sub_name: repl_tag(), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('cp -p /etc/namedb/named.conf /usr/local/etc/ispcp/bind/backup/named.conf.1205332667'), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Ending...
DEBUG: push_el() sub_name: get_tag(), msg: Starting...
DEBUG: push_el() sub_name: get_tag(), msg: ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !
DEBUG: pop_el() sub_name: get_tag(), msg: ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !
ERROR: Undefined intput data, bt: |// bind Data BEGIN.
|, et: |// bind Data END.
|, src !
(This post was last modified: 03-13-2008 12:35 AM by StevenE.)
03-13-2008 12:27 AM
Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #59
RE: FreeBSD ?
seems to be a bind defect. Please copy the bind-files from Debian into your ispcp/bind/ directory and retry
03-13-2008 02:06 AM
Visit this user's website Find all posts by this user Quote this message in a reply
StevenE Offline
Junior Member
*

Posts: 104
Joined: Feb 2008
Reputation: 0
Post: #60
RE: FreeBSD ?
ok that do it so long, but its not the last error at all, if there is one I can't terminate I will post again.

thanks a lot
03-13-2008 02:19 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)