[Asterisk-Users] Astcc Configuration Problem

chawki hammoud cyhammoud at yahoo.com
Wed Aug 3 15:00:06 MST 2005


There is mysql connection problem and missing files in

var/www/html/.

This is the error I get when I configure database

[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
DBI connect('database=;host=','',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at
/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
referer:
http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
File does not exist: /var/www/html/favicon.ico
[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
DBI connect('database=;host=','',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at
/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
referer:
http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
File does not exist: /var/www/html/favicon.ico


The following error is created when I try to save the
configuration.

[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
DBI connect('database=;host=','',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at
/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
referer:
http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
[Tue Aug 02 23:43:25 2005] [error] [client 127.0.0.1]
File does not exist: /var/www/html/favicon.ico
[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
DBI connect('database=;host=','',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at
/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
referer:
http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
[Tue Aug 02 23:44:18 2005] [error] [client 127.0.0.1]
File does not exist: /var/www/html/favicon.ico


The following error is reported when I attempt the
route configuration.

[Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1]
DBI connect('database=;host=','',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) at
/var/www/cgi-bin/astcc-admin/astcc-admin.cgi line 67,
referer:
http://localhost/cgi-bin/astcc-admin/astcc-admin.cgi?mode=Configure
[Tue Aug 02 23:50:44 2005] [error] [client 127.0.0.1]
File does not exist: /var/www/html/favicon.ico







--- Darren Wiebe <darren at aleph-com.net> wrote:

> astcc-admin.cgi will post output to
> /var/log/httpd/error_log  That 
> should help solve the problem. 
> 
> Darren Wiebe
> darren at aleph-com.net
> 
> chawki hammoud wrote:
> 
> >All suggested files were changed to be owned by
> root
> >and apache and I logged in as root.
> >
> >After I unsuccessfully try the route and trunk
> pages
> >and  go back to the configure page, I get the
> message
> >database is unavailable on the same page that
> created
> >it. I manually inserted data to astcc-config.conf
> >but it seems apache is not writing or reading these
> >files.
> >Database is created successfully when I name the
> >hostname= "localhost.localdomain" and it fails for
> >hostname = "localhost". I don't know if apache is
> >loosing communication due to localhost somewhere
> and
> >localhost.localdomain in other places.
> >
> >I will uninstall apache and reinstall it.
> >I appreciate any more suggestions. 
> >
> >
> >--- Darren Wiebe <darren at aleph-com.net> wrote:
> >
> >  
> >
> >>Try this line in /var/lib/astcc and see if it
> helps.
> >>
> >>"chown apache *" and
> >>
> >>"chown -R apache *" from /var/www/cgi-bin.
> >>
> >>If it does not help, do an "ls -l" in /var/www and
> >>see who owns it.  
> >>Then repeat the command above with the correct
> user.
> >>
> >>
> >>Darren Wiebe
> >>darren at aleph-com.net
> >>
> >>chawki hammoud wrote:
> >>
> >>    
> >>
> >>>Hi:
> >>>
> >>>How do I check it? 
> >>>
> >>>Thanks
> >>>
> >>>--- Darren Wiebe <darren at aleph-com.net> wrote:
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>>>Check and make sure that astcc-config.conf is
> >>>>        
> >>>>
> >>owned
> >>    
> >>
> >>>>by the same process 
> >>>>that owns apache.  Usually the problem is that
> >>>>astcc-admin cannot write 
> >>>>to the file due to permission problems.
> >>>>
> >>>>Darren Wiebe
> >>>>darren at aleph-com.net
> >>>>
> >>>>chawki hammoud wrote:
> >>>>
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>Hi:
> >>>>>
> >>>>>I used astcc to create database. After I get
> the
> >>>>>message database created, I save the
> >>>>>          
> >>>>>
> >>configuration
> >>    
> >>
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>and
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>I move to the next step to assign trunk and
> >>>>>          
> >>>>>
> >>route.
> >>    
> >>
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>But
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>I get the message:
> >>>>>Database unavailable -- please check
> >>>>>          
> >>>>>
> >>configuration
> >>    
> >>
> >>>>>Cannot edit routes until database is configured
> >>>>>
> >>>>>I checked the databse and it's in mysql, the
> file
> >>>>>/var/lib/astcc/astcc-config.conf is empty.
> >>>>>astcc-admin.cgi is supposed to write a file
> based
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>on
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>the configuration, but for some reason doesn't
> >>>>>I inserted data manually into the databse
> tables
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>and
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>astcc works fine on asterisk and write data
> into
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>the
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>database.
> >>>>>Why the web browser can't see the database it
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>created?
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>could apache be the problem although it's
> >>>>>          
> >>>>>
> >>running?
> >>    
> >>
> >>>>>Regards;
> >>>>>Chawki
> >>>>>
> >>>>>
> >>>>>		
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
>
>>>____________________________________________________
> >>>      
> >>>
> >>>>   
> >>>>
> >>>>        
> 
=== message truncated ===



		
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 



More information about the asterisk-users mailing list