Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Install - 7

Quote Reply
Install - 7
Hi

I get this when running setup.cgi via browser:
"Error: Could not connect to database. Reason: Unknown MySQL Server Host (host=localhost) (2)"

Its the same error that thos who installed 6 had.

Are

Quote Reply
Re: Install - 7 In reply to
Hi:

I get a similar error. I have a local host name (userdb.aros.net) and have subsitiuted that for SQL hostname, and the error I get is:

Error: Could not connect to database. Reason: Unknown MySQL Server Host 'host=userdb.aros.net' (0)

TIA!

Dave

Quote Reply
Re: Install - 7 In reply to
That's the same error we had, and we asked Alex,and he ssh'd to our server and fixed us right up, I don't know what he did particularly, but something to the effect of our DBI:MYSQL were too old, he stated hes now made them backwards compatible with the older versions. I dont have the original email anymore, so that's from memory and could be wrong.
Harrison

"I've got if's pretty good, but that's about it"
Quote Reply
Re: Install - 7 In reply to
Yes, it's if you have an old DBD::mysql, it won't work. You need to edit GT/SQL/Driver.pm and replace the subroutine _create_dsn with:

sub _create_dsn {
my ($self, $connect) = @_;
my $dsn;

$connect->{driver} ||= 'mysql';
$connect->{host} ||= 'localhost';
$self->{driver} = $connect->{driver};
$dsn = "DBI:$connect->{driver}:";
$dsn .= $connect->{database} if $connect->{database};
$dsn .= ":$connect->{host}" if $connect->{host};
$dsn .= ":$connect->{port}" if $connect->{port};
return $dsn;
}

and it will work.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Install - 7 In reply to
Hi

Then I get this error when setup returns to control panel:


Error: Not enough arguments for syswrite at GT/Socket.pm line 440, near "$buf)"

Stack Trace
======================================
Links (21202): Links::environment called at Links.pm line 375.Links (21202): Links::fatal called at GT/Base.pm line 257.Links (21202): GT::Base::error_handler called at GT/Mail/Send.pm line 4.Links (21202): GT::Mail::Send::BEGIN called at GT/Socket.pm line 521.Links (21202): (eval) called at GT/Socket.pm line 521.Links (21202): (eval) called at GT/Mail.pm line 26.Links (21202): GT::Mail::BEGIN called at GT/Socket.pm line 521.Links (21202): (eval) called at GT/Socket.pm line 521.Links (21202): (eval) called at Links/Tools.pm line 16.Links (21202): Links::Tools::BEGIN called at GT/Socket.pm line 521.Links (21202): (eval) called at GT/Socket.pm line 521.Links (21202): (eval) called at GT/Template.pm line 328.Links (21202): (eval) called at GT/Template.pm line 328.Links (21202): GT::Template::_check_func called at GT/Template.pm line 298.Links (21202): GT::Template::_parse_func called at GT/Template.pm line 148.Links (21202): GT::Template::_parse called at GT/Template.pm line 53.Links (21202): GT::Template::parse called at Links.pm line 201.Links (21202): Links::page called at admin.cgi line 39.Links (21202): main::main called at admin.cgi line 20.

CGI INPUT
======================================
do => page
page => home_left.html


CGI Cookies
======================================


ENVIRONMENT
======================================
DOCUMENT_ROOT => /home/xxx/xxx
GATEWAY_INTERFACE => CGI/1.1
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => no
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => xx.xx
HTTP_REFERER => http://xxxx/lsql/admin/admin.cgi?do=page&page=home_body.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
PATH => /usr/local/bin:/usr/bin:/bin
QUERY_STRING => do=page&page=home_left.html
REMOTE_ADDR => xx
REMOTE_PORT => xx
REQUEST_METHOD => GET
REQUEST_URI => /lsql/admin/admin.cgi?do=page&page=home_left.html
SCRIPT_FILENAME => /home/xxx/xxx/lsql/admin/admin.cgi
SCRIPT_NAME => /lsql/admin/admin.cgi
SERVER_ADMIN => xxx@xx.no
SERVER_NAME => xx.xx
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.9 (Unix) FrontPage/4.0.4.3 Rewrit/1.1a ApacheJServ/1.0b5 PHP/3.0.12



Quote Reply
Re: Install - 7 In reply to
Yes, that was the other issue if you were on an older perl (perl 5.004_04). Edit GT/Socket and change in sub write:

my $b_sent = syswrite($sock, $buf);

to:

my $b_sent = syswrite($sock, $buf, length $buf);

Cheers,

Alex



--
Gossamer Threads Inc.
Quote Reply
Re: Install - 7 In reply to
When trying to add a link:

Error: Not a GLOB reference at GT/SQL/Display/HTML.pm line 317.

Stack Trace
======================================
Links (7769): Links::environment called at Links.pm line 375.Links (7769): Links::fatal called at GT/Base.pm line 257.Links (7769): GT::Base::error_handler called at GT/SQL/Display/HTML.pm line 317.Links (7769): GT::SQL::Display::HTML::select called at GT/SQL/Display/HTML.pm line 146.Links (7769): GT::SQL::Display::HTML::_display called at GT/SQL/Display/HTML.pm line 78.Links (7769): GT::SQL::Display::HTML::form called at Links/Browser.pm line 719.Links (7769): Links::Browser::info_panel_link_add_form called at browser.cgi line 61.Links (7769): main::main called at browser.cgi line 28.

CGI INPUT
======================================
action => info_panel_category_del_form
category_id => 3


CGI Cookies
======================================



Quote Reply
Re: Install - 7 In reply to
Alex:

HURRAH!!!!! It worked for me- thank you for posting that fix!!!!

Dave

Quote Reply
Re: Install - 7 In reply to
wow...that wysiwyg (or whatever...) editor is nice! Now it becomes a lot simpler to edit templates.

Nice working :)